Transition MCTS on SQL Serv 08 to MCSA: SQL Serv 2012, Pt 2
Exam Number/Code : 70-458 Exam freely
Questions and Answers : 95 Q&As
Update Time: 2014-03-03
Price: $ 108.00 $ 143.00
http://www.testonside.com/70-458.html
http://www.testonside.com/pdf/70-458.pdf
Question: Source:www.testonside.com
You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the contents of a fact table that contains a non-clustered columnstore index. You need to run an update statement against the table. What should you do first?
A. Drop the columnstore index.
B. Pause the columnstore index.
C. Change the recovery model of the database to Bulk-logged.
D. Change the non-clustered columnstore index to be a clustered columnstore index.
Answer: A
Question: Source:www.testonside.com
You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. The SSIS package has the following requirements:
·Every night, a very large amount of data is imported into the staging database.
·Package processing time must be minimized.
·The package must run on its own dedicated server when it is deployed to production.
·Transaction log activity when data is imported must be minimized. You need to design the package to meet the requirements. Which destination component should you use?
A. ODBC
B. OLE DB
C. Raw File
D. Bulk Insert
Answer: B
Question: Source:www.testonside.com
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database. To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP web service instead of from a weekly flat file. You need to implement the change to the existing package while minimizing the development effort. What should you use to call the web service to retrieve the daily exchange rates?
A. a Script task
B. a Script component
C. a Web Service task
D. a Web Service source
Answer: C
Question: Source:www.testonside.com
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database. The package is deployed to SQL Server. The package is not producing the desired results. You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues. What should you do?
A. Run the DTEXEC utility with the /Reporting V option.
B. Run the DTEXEC utility with the /DumpOnError option.
C. Execute the catalog.add_data_tap stored procedure with the package execution_id.
D. Execute the catalog.create_execution_dump stored procedure with the package execution_id.
Answer: B
Question: Source:www.testonside.com
You are the senior database administrator for a Microsoft SQL Server environment that uses Windows Azure SQL Database.You need to grant a junior database administrator only the permissions required to create new logins.Which Windows Azure SQL Database role should you assign the junior database administrator?
A. loginmanager
B. securityadmin
C. serveradmin
D. setupadmin
Answer: A
Question: Source:www.testonside.com
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server. The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project. You need to meet the requirements by using the least amount of administrative effort. What should you do?
A. For each target server, create a separate XML configuration file. Select the XML configuration file at package execution time.
B. For each target server, create separate registry entry configurations. Select the registry entry at package execution time.
C. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.
D. Create one SSIS catalog Environment. Change the values of each Environment variable at package execution time.
Answer: C
Exam Number/Code : 70-458 Exam freely
Questions and Answers : 95 Q&As
Update Time: 2014-03-03
Price: $ 108.00 $ 143.00
http://www.testonside.com/70-458.html
http://www.testonside.com/pdf/70-458.pdf
Question: Source:www.testonside.com
You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the contents of a fact table that contains a non-clustered columnstore index. You need to run an update statement against the table. What should you do first?
A. Drop the columnstore index.
B. Pause the columnstore index.
C. Change the recovery model of the database to Bulk-logged.
D. Change the non-clustered columnstore index to be a clustered columnstore index.
Answer: A
Question: Source:www.testonside.com
You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. The SSIS package has the following requirements:
·Every night, a very large amount of data is imported into the staging database.
·Package processing time must be minimized.
·The package must run on its own dedicated server when it is deployed to production.
·Transaction log activity when data is imported must be minimized. You need to design the package to meet the requirements. Which destination component should you use?
A. ODBC
B. OLE DB
C. Raw File
D. Bulk Insert
Answer: B
Question: Source:www.testonside.com
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database. To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP web service instead of from a weekly flat file. You need to implement the change to the existing package while minimizing the development effort. What should you use to call the web service to retrieve the daily exchange rates?
A. a Script task
B. a Script component
C. a Web Service task
D. a Web Service source
Answer: C
Question: Source:www.testonside.com
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database. The package is deployed to SQL Server. The package is not producing the desired results. You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues. What should you do?
A. Run the DTEXEC utility with the /Reporting V option.
B. Run the DTEXEC utility with the /DumpOnError option.
C. Execute the catalog.add_data_tap stored procedure with the package execution_id.
D. Execute the catalog.create_execution_dump stored procedure with the package execution_id.
Answer: B
Question: Source:www.testonside.com
You are the senior database administrator for a Microsoft SQL Server environment that uses Windows Azure SQL Database.You need to grant a junior database administrator only the permissions required to create new logins.Which Windows Azure SQL Database role should you assign the junior database administrator?
A. loginmanager
B. securityadmin
C. serveradmin
D. setupadmin
Answer: A
Question: Source:www.testonside.com
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server. The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012. Each target server requires different values for connection strings and parameters in the SSIS project. You need to meet the requirements by using the least amount of administrative effort. What should you do?
A. For each target server, create a separate XML configuration file. Select the XML configuration file at package execution time.
B. For each target server, create separate registry entry configurations. Select the registry entry at package execution time.
C. For each target server, create separate Environments in the SSIS catalog of the host SQL Server SSIS instance. Select the appropriate Environment at package execution time.
D. Create one SSIS catalog Environment. Change the values of each Environment variable at package execution time.
Answer: C