web analytics

You need to configure the distribution agent by granting only the minimum required access to all accounts. What should you do?

You administer two Microsoft SQL Server 2016 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the Windows NT Service virtual accounts

In doing so, you need to output the progress of the backup. Which backup option should you use?

You administer a Microsoft SQL Server 2016 database. You want to make a full backup of the database to a file on disk. In doing so, you need to output

You want to perform a tail-log backup. You need to leave the primary database in a restoring state. Which option of the BACKUP LOG command should you use?

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

Logins are based only on Windows security groups. What should you do?

You administer a Windows Azure SQL Database database named Human_Resources. The database contains 2 tables named Employees and SalaryDetails. You add two Windows groups as logins for the server: CORP\Employees

You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use?

You administer a SQL Server 2016 database instance. You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use? A. A

You need to grant only the necessary permissions. What should you do?

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory. Users need to be able to SELECT from all tables in the database

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 file should you use?

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

You start a SQL Profiler trace. Which event should you select?

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

You need to gather more data to be able to determine which processes are being blocked and to identify the root cause. What should you do?

You administer a Microsoft SQL Server 2016 database named Orders. Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that

You need to dynamically limit resource consumption. What should you do?

You are the administrator of a Microsoft SQL Server 2016 server. Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications. You need to

You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs and to execute SQL Server Agent jobs. To which role should you add UserA?

You administer a Microsoft SQL Server 2016 database instance. You create a new user named UserA. You need to ensure that UserA is able to create SQL Server Agent jobs

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?

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

You need to ensure that the application can connect to the named instance. What should you do?

You administer two instances of Microsoft SQL Server 2016. You deploy an application that uses a database on the named instance. The application is unable to connect to the database

You need to configure SQL Server to send the email messages. What should you configure?

You administer a Microsoft SQL Server 2016 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to

You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs. What should you do?

You administer a Microsoft SQL Server 2016 instance that has several SQL Server Agent jobs configured. SQL Server Agent jobs fail, the error messages returned by the job steps are

You need to reduce the occurrence of these timeout errors. What should you do?

You administer several Microsoft SQL Server 2016 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of

You also need to minimize the amount of storage used by the database. Which configuration should you use?

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

You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?

You administer all the deployments of Microsoft SQL Server 2016 in your company. A database contains a large product catalog that is updated periodically. You need to be able to

You also need to ensure that data on the primary server is unaffected. Which configuration should you use?

You administer all the deployments of Microsoft SQL Server 2016 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near

You also need to be able to add indexes to the secondary database. Which configuration should you use?

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 off- loaded

You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections. What should you do?

You administer a Microsoft SQL Server 2016 default instance. The instance is hosted by a server that has a local firewall configured. The firewall only allows inbound connections on port

You need to ensure that AgentPortalUser can send email messages. What should you do?

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email

You need to create the authentication object so that you can connect to Azure. Which Windows PowerShell command or commands should you run?

You plan to integrate an on-premises Microsoft SQL Server environment with Microsoft Azure. You need to create the authentication object so that you can connect to Azure. Which Windows PowerShell

You want to assign maximum CPU and memory values to the third resource pool. What is the maximum CPU and memory value you can assign to this resource pool?

You have configured Resource Governor with three resource pools. You have assigned the first resource pool a minimum CPU and memory value of 20%. You have assigned the second resource

You need to maximize the time that the Query Store is in Read-Write mode. Which Transact-SQL statement should you run?

You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions of requests per hour. Queries on DB1 are taking longer than normal

You need to configure the encryption options for backups. What should you configure?

You manage a Microsoft SQL Server environment. You plan to encrypt data when you create backups. You need to configure the encryption options for backups. What should you configure? A.

You need to ensure that the database remains in the RECOVERING state until the restoration of FG2 completes. After the restoration of FG2 completes, the database must be online. What should you specify when you run the recovery command?

A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a backup strategy that creates backups for the filegroups. DB1 experiences a failure. You

You need to identify missing indexes. What should you use?

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

What should you use?

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

You need to examine disk usage, query statistics, and server activity without building custom counters. What should you use?

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

You need to examine information about logins, CPU times, and Disk I/O on a particular database in Microsoft Azure. What should you use?

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

You need to return information about processes that are not idle, that belong to a specific user, or that belong to a specific session. What should you use?

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

You need to provide permissions to a service account that will be used to provision a new database for a client. Which permission should you grant?

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

You need to grant the developers permission to alter views for DB1 while following the principle of least privilege. Which permission should you grant?

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

You need to grant the user permission to implement cell-level encryption while following the principle of least privilege. Which permission should you grant?

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

You need to grant the correct permission to the service account that backs up the HRDB database. Which permission should you grant?

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

You need to ensure that the user can view the TDE metadata while following the principle of least privilege. Which permission should you grant?

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

You need to grant an auditor permission to view the SQL Server audit logs while following the principle of least privilege. Which permission should you grant?

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

Solution: You run the DBCC CHECKDB command. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: You rebuild all indexes. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: You reorganize all indexes. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: You migrate DB1 to a named instance on a server than runs Microsoft SQL Server 2016 Standard edition. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: You migrate DB1 to a named instance on a server that runs Microsoft SQL Server 2016 Enterprise edition. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: You migrate DB1 to the default instance on a server that runs Microsoft SQL Server 2016 Standard edition. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: You add the DatabaseMailUserRole to Mail1 in the msdb database. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.

Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database. Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals.