- All Exams Instant Download
Which three actions should you perform in sequence?
DRAG DROP You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table. You need...
What should you recommend for the updates to Sales.TransactionHistory?
Overview Application Overview Contoso, Ltd., is the developer of an enterprise resource planning (ERP) application. Contoso is designing a new version of the ERP application. The previous version of the ERP application used SQL Server 2008 R2. The new version will use SQL Server 2014. The ERP application relies on...
What should you include in the recommendation?
You have a server named Server1 that has 2 processors. You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multiple databases. You need to recommend a method to allocate processor time to each database. What should you include in the recommendation? More than...
What should you do?
You administer a Microsoft SQL Server 2016 server. The MSSQLSERVER service uses a domain account named CONTOSOSQLService. 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.A . Restart the SQL Server...
Which of the following tools would you use to accomplish this goal?
You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization's SQL Server 2016 deployment. Which of the following tools would you use to accomplish this goal?A . SQLIOB . SQLIOSimC . SQLIOStressD . chkdskView AnswerAnswer: B Explanation: The SQLIOSim utility has been upgraded from the...
Which configuration should you use?
You are implementing a SQL Server 2016 five-node failover cluster. You need to choose a quorum configuration. Which configuration should you use?A . Distributed File System (DFS)B . Node MajorityC . Cluster Shared Volume (CSV)D . Node and Disk MajorityView AnswerAnswer: D Explanation: Node and Disk Majority (recommended for clusters...
Which SQL elements should you include in the recommendation?
You have a SQL Server 2014 instance named SQL1. SQL1 creates error events in the Windows Application event log. You need to recommend a solution that will run an application when SQL1 logs a specific error in the Application log. Which SQL elements should you include in the recommendation? (Each...
You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance
HOTSPOT You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance. The environments that you manage are shown in the following table. You need to...
