Question 51
You have an Azure SQL Database instance named DatabaseA on a server named Server1.
You plan to add a new user named App1 to DatabaseA and grant App1 db_datacenter permissions. App1 will use SQL Server Authentication.
You need to create App1. The solution must ensure that App1 can be given access to other databases by using the same credentials.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You plan to add a new user named App1 to DatabaseA and grant App1 db_datacenter permissions. App1 will use SQL Server Authentication.
You need to create App1. The solution must ensure that App1 can be given access to other databases by using the same credentials.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Question 52
Drag and Drop Question
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases.
Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
Question 53
HOTSPOT
You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1.
You need to protect the contents of Column1 at rest, in transit, and in use.
How should you protect the contents of Column1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1.
You need to protect the contents of Column1 at rest, in transit, and in use.
How should you protect the contents of Column1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Question 54
You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.
You execute the Transact-SQL query shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
You execute the Transact-SQL query shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
Question 55
ou have an Azure SQL database named DB1 that contains the following tables:
* dbo.Customers contains two columns named EmailAddress ( varchar(100) ) and PhoneNumber ( varchar (20) ).
* dbo.Orders contains a computed column named ContactHash defined as HASHBYTES( ' SHA2_256 ' , Customers.EmailAddress) .
DB1 has the following dynamic data masking configurations:
* dbo.Customers.EmailAddress uses the email() masking function.
* dbo.Customers.PhoneNumber uses the default() masking function.
DB1 contains the following users:
* dbo.Customers contains two columns named EmailAddress ( varchar(100) ) and PhoneNumber ( varchar (20) ).
* dbo.Orders contains a computed column named ContactHash defined as HASHBYTES( ' SHA2_256 ' , Customers.EmailAddress) .
DB1 has the following dynamic data masking configurations:
* dbo.Customers.EmailAddress uses the email() masking function.
* dbo.Customers.PhoneNumber uses the default() masking function.
DB1 contains the following users:
