Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice m

ay be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You are examining information about users, sessions, an

d processes in an on-premises Microsoft SQL Server 2016 Standard Edition server.

You need to identify waits for resources and return only the following information:

a list of all databases on the SQL Server instance, along with information about the datab

ase files, their paths, and names

a list of the queries recently executed that use most of memory, disk, and network resources

What should you use?

A. Activity Monitor

B. Sp_who3

C. SQL Server Management Studio (SSMS) Object Explorer

D. SQL Server Data C

ollector

E. SQL Server Data Tools (SSDT)

F. SQL Server Configuration Manager

Explanation:

SQL Server Data Tools (SSDT) is a Microsoft Visual Studio environment for creating business intelligence solutions. SSDT features the Report Designer

authoring environment, where you can open, modify, preview, save, and deploy Reporting Services paginated report definitions, shared data sources, shared datasets, and report parts.

References: https://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).a

spx

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 the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You are the database administrator for a company that

hosts Microsoft SQL Server. You manage both on-premises and Microsoft Azure SQL Database environments. A service account has the required permissions to backup all databases.

You have a user database named HRDB that contains sensitive human resources data

. The HRDB backup files must be encrypted.

You need to grant the service account that backs up the HRDB database the permission necessary to access the encryption key. Your solution must use the principle of least privilege.

Which permission should you g

rant?

A. DDLAdmin

B. db_datawriter

C. dbcreator

D. dbo

E. View Database State

F. View ServerState

G. View Definition

H. sysadmin

The user account performing the restore must have VIEW DEFINITION permissions on the certificate or key.

Reference

s: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-encryption