70-765 exam

You administer a Microsoft SQL Server 2014 instance. After a routine shutdown, the drive that contains tempdb fails. You need to be able to start the SQL Server. What should you do?A . Modify tempdb location in startup parameters.B . Start SQL Server in minimal configuration mode.C . Start SQL...

You administer a Microsoft SQL Server 2014 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?A . CREATE INDEX NCI_OrderDetail_CustomerID ON...

You manage a Microsoft SQL Server environment in a Microsoft Azure virtual machine. You must enable Always Encrypted for columns in a database. You need to configure the key store provider. What should you do?A . Manually specify the column master key.B . Modify the connection string for applications.C ....

You administer a Microsoft SQL Server 2014 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You...

You administer a Microsoft SQL Server 2014 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of...

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question...

HOTSPOT You need to set up the service accounts that the database engine and SQL Server Agent services will use. How should you design the solution? To answer, select the appropriate configuration options in the answer area. View AnswerAnswer: Explanation: Box 1: Domain Account The service startup account defines the...

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question...

You plan to migrate a database To Microsoft Azure SQL Database. The database requires 500 gigabytes (GB) of storage. The database must support 50 concurrent logins. You must minimize the cost associated with hosting the database. You need to create the database. Which pricing tier should you use?A . Standard...

You plan to deploy 20 Microsoft Azure SQL Database instances to an elastic pool in Azure to support a batch processing application. Two of the databases in the pool reach their peak workload threshold at the same time every day. This leads to inconsistent performance for batch completion. You need...