Question 46
DRAG DROP
You administer a Microsoft SQL Server 2012 database. The database contains two tables named Table A and Table B.
You perform an import and export operation by using the following steps in sequence, as shown in the exhibit. (Click the Exhibit button.)
Load data from a third-party database to Table A.
Insert a subset of records from Table A to Table B.
Export the data from Table B to a flat file.
You also create a format file for the data export.
You need to choose the correct command or tool for each task. You need to ensure that each task is performed efficiently.
Which command(s) or tool(s) should you use? (To answer, drag the appropriate command(s) or tool(s) to their corresponding task or tasks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
Question 47
DRAG DROP
You administer a Microsoft SQL Server database server.
A variety of issues occur from time to time in the production environment. You need to identify the appropriate tool for each issue.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the correct issue or issues in the answer area. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)
Question 48
You administer a Microsoft SQL Server database.
You create an availability group named haContosoDbs. Your primary replica is available at Server01
\Contoso01.
You need to configure the availability group to prevent data loss. In the event of a database failure, the designed secondary database must come online automatically.
Which Transact-SQL statement should you use?
Question 49
You have a server named SQL1 that has SQL Server 2014 installed. SQL1 has 32 processor cores and 64 GB of RAM.
SQL1 hosts a database used for a public-facing marketing website. SQL1 performs Online Transaction Processing (OLTP) operations only.
Several of the queries that run on SQL1 use the 32 processor cores and complete in 30 ms.
You need to reduce the number of queries that use multiple cores. The solution must also reduce the number of processor cores used by the queries that require multiple processor cores.
Which two database settings should you modify? To answer, select the appropriate settings in the answer area.
Question 50
You administer a Microsoft Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?