Home / Microsoft / DP-300

Microsoft DP-300 Practice Test - Questions Answers, Page 34

Question list

List of questions

Question 331

(0)

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User

Question 332

(0)

HOTSPOT You have an Azure SQL managed instance named Server1 and an Azure Blob Storage account named storage1 that contains Microsoft SQL Server database backup files. You plan to use Log Replay S

Question 333

(0)

You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1. You create a master key

Question 334

(0)

You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines. You plan to implement a disaster recovery solution. You need to be able to perform disaster re

Question 335

(0)

HOTSPOT Vou have an Azure SQL database named DB1. You have 10 Azure virtual machines that connect to a virtual network subnet named Subnet 1. You need to implement a database-level firewall that

Question 336

(0)

HOTSPOT You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that contains two databases named DB1 and DB2. The database and log files for DB1 and DB2 are hosted on managed disks.

Question 337

(0)

DRAG DROP You have two on-premises Microsoft SQL Server instances named SQL1 and SQL2. You have an Azure subscription You need to sync a subset of tables between the databases hosted on SQL1 and

Question 338

(0)

You have 25 Azure SQL databases. You need to implement a centralized database management solution that uses Transact-SQL What should you include in the solution?

Related questions

Task 5 You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.

Task 10 You need to protect all the databases on sql37006S95 from SQL injection attacks.

You have an Azure subscription. You create a logical SQL server that hosts four databases Each database will be used by a separate customer. You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point.

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notification is sent once the job completes. What should you include in the solution?

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.

DRAG DROP You have an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. 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 have SQL Server on Azure virtual machines in an availability group. You have a database named DB1 that is NOT in the availability group. You create a full database backup of DB1. You need to add DB1 to the availability group. Which restore option should you use on the secondary replica?

HOTSPOT You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table. You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements: ▪ The first six numerals of each customer’s phone number must be masked. ▪ The first six numerals of each customer’s phone number must be masked. ▪ The last four digits of each customer’s phone number must be visible. Hyphens must be preserved and displayed. How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area.

You have a database on a SQL Server on Azure Virtual Machines instance. The current state of Query Store for the database is shown in the following exhibit.

Task 4 You need to enable change data capture (CDC) for db1.

Question 331

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User2.

On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1.

You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege.

Which role should you assign to User2?

sysadmin

SQLAgentUserRole

SQLAgentOperatorRole

SQLAgentReaderRole

Show Answer Comment (0)

Question 332

HOTSPOT

You have an Azure SQL managed instance named Server1 and an Azure Blob Storage account named storage1 that contains Microsoft SQL Server database backup files.

You plan to use Log Replay Service to migrate the backup files from storage1 to Server1. The solution must use the highest level of security when connecting to storage1.

Which PowerShell cmdlet should you run, and which parameter should you specify to secure the connection? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 333

You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1.

You create a master key in the master database of SQL1.

You need to create an encrypted backup of DB1.

What should you do?

Create a symmetric key in DB1.

Enable visualization-based security (VBS) on Server1.

Create a certificate in DB1.

Create a certificate in the master database of SQLl.

Show Answer Comment (0)

Question 334

You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines.

You plan to implement a disaster recovery solution.

You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements:

* Minimize administrative effort for the recovery drills.

* Isolate the recovery environment from the production environment.

What should you use?

Recovery Services vaults

Azure Site Recovery

Azure Backup

native Microsoft SQL Server backup

Show Answer Comment (0)

Question 335

HOTSPOT

Vou have an Azure SQL database named DB1.

You have 10 Azure virtual machines that connect to a virtual network subnet named Subnet 1.

You need to implement a database-level firewall that meets the following requirements:

* Ensures that only the 10 virtual machines can access DB1

* Follows the principle of least privilege

How should you configure the firewall rule, and how should you establish network connectivity from the virtual machines to DB1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 336

HOTSPOT

You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that contains two databases named DB1 and DB2. The database and log files for DB1 and DB2 are hosted on managed disks.

You need to perform a snapshot backup of DB1 and DB2

How should you complete the I SQL statements? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 337

DRAG DROP

You have two on-premises Microsoft SQL Server instances named SQL1 and SQL2.

You have an Azure subscription

You need to sync a subset of tables between the databases hosted on SQL1 and SQL2 by using SQL Data Sync.

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