70-764

You administer a Microsoft SQL Server 2016 database. Users report that a billing application becomes unresponsive during busy times of the day. While investigating, you notice large number of processes taking or waiting for table locks. You suspect that SQL Server is assigning stronger locks to queries. You start a...

Overview You are a database administrator for a company named Litware, Inc. Litware is a book publishing house. Litware has a main office and a branch office. You are designing the database infrastructure to support a new web-based application that is being developed. The web application will be accessed at...

HOTSPOT You manage a Microsoft SQL Server instance. You have a user named User1. You need to grant the minimum permissions necessary to allow User1 to review audit logs. For each action, which option should you use? To answer, select the appropriate options in the answer area. View AnswerAnswer: Explanation:...

You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured...

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

General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application...

General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application...

You administer a Microsoft SQL Server 2016 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node C has been added to the existing cluster. You need to ensure that the SQL...

You need to recommend a solution to meet the recovery requirements for the manufacturing database. Your solution must minimize costs. What should you recommend?A . Database snapshotsB . Transaction log backupsC . Differential backupsD . SQL Server Failover ClusteringE . Peer-to-peer replicationView AnswerAnswer: A

You have two SQL Server 2012 instances named SQLDev and SQLProd. You plan to create a new database on SQLProd that will use SQL Server Authentication. You need to ensure that when the new database is copied from SQLProd to SQLDev, users can connect to the database on SQLDev if...