70-457 Exam and Demo freely
Transition MCTS on SQL Serv 08 to MCSA: SQL Serv 2012, Pt 1
· Exam Number/Code : 70-457
· Exam Name : Transition MCTS on SQL Serv 08 to MCSA: SQL Serv 2012, Pt 1
· Questions and Answers : 95 Q&As
· Update Time: 2013-11-15
· Price: $ 108.00 $ 89.00
· http://www.testonside.com/70-457.html
· http://www.testonside.com/pdf/70-457.pdf
Question: 1
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?
A. Install Master Data services.
B. Install Data Quality services.
C. Create an Integration Services catalog.
D. Create SSIS configuration files for the packages.
Answer: C
Question: 2
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?
A. Install Master Data services.
B. Install Data Quality services.
C. Create an Integration Services catalog.
D. Create SSIS configuration files for the packages.
Answer: C
Question: 3
You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?
A. Start the SQL Server Browser Service.
B. Start the SQL Server Integration Services Service.
C. Use the Data Quality Client to configure the application.
D. Use the Master Data Services Configuration Manager to configure the application.
Answer: A
Question: 4
You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?
A. Start the SQL Server Browser Service.
B. Configure the application as data-tiered.
C. Open port 1433 on the Windows firewall on the server.
D. Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.
Answer: A
Question: 5
You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products. You want to create an object that will prevent the applications from accessing the table directly while still providing access to the required data. You need to ensure that the following requirements are met:
·Future modifications to the table definition will not affect the applications’ ability to access data.
·The new object can accommodate data retrieval and data modification. You need to achieve this goal by using the minimum amount of changes to the applications. What should you create for each application?
A. Common table expressions
B. Synonyms
C. Temporary tables
D. Views
Answer: D
Question: 6
You develop a Microsoft SQL Server 2012 database.
You create a view that performs the following tasks:
·Joins 8 tables that contain up to 500,000 records each.
·Performs aggregations on 5 fields. The view is frequently used in several reports. You need to improve the performance of the reports. What should you do?
A. Convert the view into an indexed view.
B. Convert the view into a table-valued function.
C. Convert the view into a Common Table Expression (CTE).
D. Convert the view into a stored procedure and retrieve the result from the stored procedure into a temporary table.
Answer: A
Transition MCTS on SQL Serv 08 to MCSA: SQL Serv 2012, Pt 1
· Exam Number/Code : 70-457
· Exam Name : Transition MCTS on SQL Serv 08 to MCSA: SQL Serv 2012, Pt 1
· Questions and Answers : 95 Q&As
· Update Time: 2013-11-15
· Price: $ 108.00 $ 89.00
· http://www.testonside.com/70-457.html
· http://www.testonside.com/pdf/70-457.pdf
Question: 1
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?
A. Install Master Data services.
B. Install Data Quality services.
C. Create an Integration Services catalog.
D. Create SSIS configuration files for the packages.
Answer: C
Question: 2
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?
A. Install Master Data services.
B. Install Data Quality services.
C. Create an Integration Services catalog.
D. Create SSIS configuration files for the packages.
Answer: C
Question: 3
You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?
A. Start the SQL Server Browser Service.
B. Start the SQL Server Integration Services Service.
C. Use the Data Quality Client to configure the application.
D. Use the Master Data Services Configuration Manager to configure the application.
Answer: A
Question: 4
You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?
A. Start the SQL Server Browser Service.
B. Configure the application as data-tiered.
C. Open port 1433 on the Windows firewall on the server.
D. Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.
Answer: A
Question: 5
You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products. You want to create an object that will prevent the applications from accessing the table directly while still providing access to the required data. You need to ensure that the following requirements are met:
·Future modifications to the table definition will not affect the applications’ ability to access data.
·The new object can accommodate data retrieval and data modification. You need to achieve this goal by using the minimum amount of changes to the applications. What should you create for each application?
A. Common table expressions
B. Synonyms
C. Temporary tables
D. Views
Answer: D
Question: 6
You develop a Microsoft SQL Server 2012 database.
You create a view that performs the following tasks:
·Joins 8 tables that contain up to 500,000 records each.
·Performs aggregations on 5 fields. The view is frequently used in several reports. You need to improve the performance of the reports. What should you do?
A. Convert the view into an indexed view.
B. Convert the view into a table-valued function.
C. Convert the view into a Common Table Expression (CTE).
D. Convert the view into a stored procedure and retrieve the result from the stored procedure into a temporary table.
Answer: A