70-764 exam

You need to ensure that a stored procedure fails if an INSERT statement within the stored procedure fails. What action should you take?A . THROW 51000, 'Abort!'B . SET XACT_ABORT OFFC . SET XACT_ABORT OND . TRE . ...CATCHView AnswerAnswer: C

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of...

You administer a Microsoft SQL Server 2016 database that includes a table named dbo.Log. This table contains millions of records about user activity in an application. Records in dbo.Log that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention withinserts. You...

You install Microsoft SQL Server 2016 on a new server. After setup is complete, you attempt to start the SQL Server service. After being in a starting state for a few moments, the service goes back to a stopped state. You need to determine the cause of the failure. Which...

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 are the database administrator for a company that hosts Microsoft SQL Server. You manage both onpremisesand Microsoft Azure SQL Database environments. Clients connect to databases by using line-of-business applications. Developers connect by using SQL ServerManagement Studio (SSMS). You need to provide permissions to a service account that will be...

Your network contains an Active Directory domain that has two groups named Group1 and Group2. The domain contains two SQL Server instances named SQLDev and SQLProd. Each SQL Server instance has access to various storage media. The SQL Server instances have a database that contains a table named Table1. Table1...

DRAG DROP You need to recommend a backup process for an Online Transaction Processing (OLTP) database. The process must meet the following requirements: Ensure that if a hardware failure occurs, you can bring the database online with a minimum amount of data loss. Minimize the amount of administrative effort required...

DRAG DROP You are the database administrator for a Microsoft SQL Server instance. You develop an Extended Events package to look for events related to application performance. You need to change the event session to include SQL Server errors that are greater than error severity 15. Which five Transact-SQL segments...

You are examining information about users, sessions, and processed in an on-premises Microsoft SQL ServerDatabase Engine instance. You need to return information about processes that are not idle, that belong to a specific user, or that belongto a specific session. What should you use?A . Activity MonitorB . sp_who3C ....