DRAG DROP -You administer a Microsoft SQL Server database that is used by an application.Users of the application report performance issues.You need to choose the appropriate tool for performance-tuning of SQL Server databases.Which tool or tools should you use? (To answer, drag the appropriate tool or tools to their corresponding task or tasks 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.)Select and Place:
You administer a Microsoft SQL Server 2012 database.You need to ensure that the size of the transaction log file does not exceed 2 GB.What should you do?
You administer a Microsoft SQL Server server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService.You plan to configure Instant File Initialization.You need to ensure that Data File Autogrow operations use Instant File Initialization.What should you do? Choose all that apply.
DRAG DROP -You administer a Microsoft SQL Server instance. You use a two-node SQL Server failover cluster. Node B is primary, and Node A is secondary.You need to install a security patch on both nodes.You need to ensure that the following requirements are met:✑ Both nodes receive the update.✑ Downtime is minimized.✑ No data is lost.Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
You administer a Microsoft SQL Server 2012 database.The database contains a Product table created by using the following definition:You need to ensure that the minimum amount of disk space is used to store the data in the Product table.What should you do?
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?
