You administer a Microsoft SQL Server 2012 database named Orders.Orders contain a table named OrderShip that is defined as follows:A NULL value represents a domestic order. Ninety percent of the values in CountryCode are NULL.Customers require a procedure that will return orders for all customers from a specified country. You create a new procedure:Performance on this procedure is slow.You need to alter the schema to optimize this query. Objects created must use a minimum amount of resources.Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server database. The database is currently configured to log ship to a secondary server.You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online. You want to perform a tail-log backup.You need to leave the primary database in a restoring state.Which option of the BACKUP LOG command should you use?
HOTSPOT -You administer a Microsoft SQL Server database.The database is in the Simple recovery mode.You schedule the following backup plan:✑ Full backup every day at midnight✑ Differential backups every hour on the hour, except at midnight✑ Transaction log backups every ten minutes, starting 10 minutes from the hour, except on the hourThe database fails at 20:45 hours.You need to use SQL Server Management Studio (SSMS) to begin restoring the database with a minimum amount of data loss.Which options should you select on the Options page of the Restore Database window? (To answer, configure the appropriate option or options in the dialog box in the answer area.)Hot Area:
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.)Select and Place:
You administer a Microsoft SQL Server 2012 database. You want to make a full backup of the database to a file on disk.In doing so, you need to output the progress of the backup.Which backup option should you use?
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.You administer all the deployments of Microsoft SQL Server in your company.You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail.You also need to minimize the amount of storage used by the database.Which configuration should you use?
