Home / Microsoft / DP-300

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

Question list

List of questions

Question 301

(0)

You deploy an instance of SQL Server on Azure Virtual Machines named SQL1 that hosts multiple databases. You configure the full recovery model for all the databases. You perform a full backup of t

Question 302

(0)

You have an Azure SQL database named SOL1. You need to implement a disaster recovery solution for SQL1. The solution must minimize the following: * The recovery point objective JRPO) * The recove

Question 303

(0)

DRAG DROP You have an Azure key vault named Vault1 and a SQL Server on Azure Virtual Machines instance named SQL1 SQL 1 hosts a database named DB1. You need to configure Transparent Data Encryptio

Question 304

(0)

You Save an Azure SCX database named DB1. You need to query the fragmentation information of data and indexes for the tables in D61. Which command should you run?

Question 305

(0)

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL database named SQLDB1. You need to replicate D

Question 306

(0)

HOTSPOT You have an Azure subscription. You need to deploy a logical SQL server by using an Azure Resource Manager (ARM) template. The solution must ensure that the server will allow inbound conne

Question 307

(0)

You have an Azure subscription that contains the resources shown in the following table. You plan louse SQLDB11 as an elastic job database to run jobs on SQlDb11 andSOtDB22. What is the minimum n

Question 308

(0)

You have an Azure subscription. You need to deploy an Instance of SQL Server on Azure Virtual Machines. The solution must meet the following 'requirements: * Custom performance configuration. such

Question 309

(0)

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 i

Question 310

(0)

Task 1 In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table.

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?

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.

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.

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

Question 301

You deploy an instance of SQL Server on Azure Virtual Machines named SQL1 that hosts multiple databases.

You configure the full recovery model for all the databases.

You perform a full backup of the master database on SQL1.

You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup.

Which type of backup should you perform?

tail-log

differential

full

log

Show Answer Comment (0)

Question 302

You have an Azure SQL database named SOL1.

You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:

* The recovery point objective JRPO)

* The recovery time objective (RTO)

* Administrative effort

What should you include in the solution?

auto failover groups

Azure Site Recovery

availability groups

active geo - replication

Show Answer Comment (0)

Question 303

DRAG DROP

You have an Azure key vault named Vault1 and a SQL Server on Azure Virtual Machines instance named SQL1 SQL 1 hosts a database named DB1.

You need to configure Transparent Data Encryption (TDE) on D61 to use a key in Vault1

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

Show Answer Comment (0)

Question 304

You Save an Azure SCX database named DB1.

You need to query the fragmentation information of data and indexes for the tables in D61.

Which command should you run?

Show Answer Comment (0)

Question 305

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.

You have an Azure subscription that contains an Azure SQL database named SQLDB1.

You need to replicate DB1 to SQlDC1.

Which type of replication should you use?

peer-to-pec

merge

transactional

snapshot

Show Answer Comment (0)

Question 306

HOTSPOT

You have an Azure subscription.

You need to deploy a logical SQL server by using an Azure Resource Manager (ARM) template. The solution must ensure that the server will allow inbound connectivity from any Azure resource.

How should you complete the template? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 307

You have an Azure subscription that contains the resources shown in the following table.

You plan louse SQLDB11 as an elastic job database to run jobs on SQlDb11 andSOtDB22. What is the minimum number of database scoped credentials required tor the elastic jobs?

Show Answer Comment (0)

Question 308

You have an Azure subscription.

You need to deploy an Instance of SQL Server on Azure Virtual Machines. The solution must meet the following 'requirements:

* Custom performance configuration. such as lCPS. capacity, and throughout, must be supported.

* Costs must be minimized

Which type of disk should you include in the solution?

Premium SSD v2

Premium SSD

Ultra SSD

Standard SSD

Show Answer Comment (0)

Question 309

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.

Create a network security group (NSG)

Create a server-level firewall rule

Create a private endpoint

Create a database-level firewall rule.

Deny public access.

Show Answer Comment (0)

Question 310

Task 1

In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table.

See the explanation part for the complete Solution

Show Answer Comment (0)

Suggested answer: A

Explanation:

To enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.SalesOrderHeader table in db1, you can use the following Transact-SQL script:

-- Connect to the Azure SQL database named db1

USE db1;

-- Enable page compression on the clustered index

ALTER INDEX PK_SalesOrderHeader_SalesOrderlD ON SalesLT.SalesOrderHeader

REBUILD WITH (DATA_COMPRESSION = PAGE);

This script will rebuild the clustered index with page compression, which can reduce the storage space and improve the query performance

The script solution consists of three parts:

The first part isUSE db1; GO. This part connects to the Azure SQL database named db1, where the SalesLT.SalesOrderHeader table is located. TheGOcommand separates the batches of Transact-SQL statements and sends them to the server.

The second part isALTER INDEX PK_SalesOrderHeader_SalesOrderlD ON SalesLT.SalesOrderHeader REBUILD WITH (DATA_COMPRESSION = PAGE); GO. This part enables page compression on the clustered index named PK_SalesOrderHeader_SalesOrderlD, which is defined on the SalesLT.SalesOrderHeader table. TheALTER INDEXstatement modifies the properties of an existing index. TheREBUILDoption rebuilds the index from scratch, which is required to change the compression setting. TheDATA_COMPRESSION = PAGEoption specifies that page compression is applied to the index, which means that both row and prefix compression are used. Page compression can reduce the storage space and improve the query performance by compressing the data at the page level. TheGOcommand ends the batch of statements.

The third part is optional, but it can be useful to verify the compression status of the index. It isSELECT name, index_id, data_compression_desc FROM sys.indexes WHERE object_id = OBJECT_ID('SalesLT.SalesOrderHeader');. This part queries the sys.indexes catalog view, which contains information about the indexes in the database. TheSELECTstatement returns the name, index_id, and data_compression_desc columns for the indexes that belong to the SalesLT.SalesOrderHeader table. TheOBJECT_IDfunction returns the object identification number for the table name. The data_compression_desc column shows the compression type of the index, which should be PAGE for the clustered index after the script is executed.

These are the steps of the script solution for enabling page compression on the clustered index of the SalesLT.SalesOrderHeader table in db1.

Total 338 questions

29 30 31 32 33

Go to page: of 34