70-764 exam

You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing database on MainDB1. What should you do?A . You should configure a Database Role.B . You should configure a Server Role.C ....

You plan to migrate the db to azure. You verify that all objects are valid for azure sql database. You need to ensure that users and logins are migrated to azure. What should you do?A . Use the Copy Database wizardB . Use the Database Transfer wizardC . Use the...

You administer a Microsoft SQL Server 2016 database. The database is currently configured to log ship to a secondary server. You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online. You want to perform a tail-log backup. You need to leave...

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

You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01. You need to diagnose deadlocks that happen when executing a specific set of stored procedures by recording events and playing them back on a different test server. What should you create?A . an Extended Event...

You are the database administrator for a company that hosts Microsoft SQL Server. You manage both onpremisesand Microsoft Azure SQL Database environments. One instance hosts a user database named HRDB. The database contains sensitive human resources data. You need to grant an auditor permission to view the SQL Server audit...

You administer a single server that contains a Microsoft SQL Server 2016 default instance. You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions. You need to ensure that the application login is unable to access other...

A company has a server that runs Microsoft SQL Server 2016 Web edition. The server has a default instancethat hosts a database named DB1. You need to ensure that you can perform auditing at the database level for DB1. Solution: You migrate DB1 to a named instance on a server...

DRAG DROP You are planning to deploy a database to Windows Azure SQL Database. You need to design a stored procedure to update rows. The stored procedure must meet the following requirements: If more than one row is updated, an error must be raised to the application and the update...

You administer all the deployments of Microsoft SQL Server 2016 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be offloaded from the primary database to another server. You also need to be able to add indexes to the secondary database. Which...