70-764

You administer all the deployments of Microsoft SQL Server 2016 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...

You have a server that has SQL Server 2014 installed. The server contains 100 user databases. You need to recommend a backup solution for the user databases. The solution must meet the following requirements: Perform a transaction log backup every hour. Perform a full backup of each database every week....

You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. You plan to synchronize SQLDev and SQLProd. You need to recommend a solution that meets the following requirements: The database schemas must be synchronized from SQLDev to SQLProd. The database on SQLDev must...

You need to address the Sales Director's requirements regarding the customer classification. You need to recommend a solution for changing the classifications. What should you recommend?A . Add each classification change to a new row in the Customers table.B . Record each change to the classification of each customer in...

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 configure...

You are the database administrator for a company that hosts Microsoft SQL Server. You manage both onpremisesand Microsoft Azure SQL Database environments. You have a user database named HRDB that contains sensitive human resources data. The HRDB backupfiles must be encrypted. You need to grant the correct permission to the...

Overview General Overview ADatum Corporation has offices in Miami and Montreal. The network contains a single Active Directory forest named adatum.com. The offices connect to each other by using a WAN link that has 5-ms latency. A. Datum standardizes its database platform by using SQL Server 2014 Enterprise edition. Databases...

DRAG DROP Background Corporate Information Fabrikam, Inc. is a retailer that sells electronics products on the Internet. The company has a headquarters site and one satellite sales office. You have been hired as the database administrator, and the company wants you to change the architecture of the Fabrikam ecommerce site...

DRAG DROP You administer a Microsoft SQL Server database named Contoso. You create a stored procedure named Sales.ReviewInvoice by running the following Transact-SQL statement: You need to create a Windows-authenticated login named ContosoSearch and ensure that ContosoSearch can run the Sales.ReviewInvoices stored procedure. Which three Transact-SQL segments should you use...

You are the new database administrator for a SQL Server 2014 instance. You conduct an assessment on the instance and determine that the auto create statistics setting on the database named DB1 has been turned off. You see no evidence that any maintenance has been occurring. You want to set...