Updated Microsoft DP-300 Exam Questions for Effective Preparation

Question #1

You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently.You enable columnstore archival compression.What are two possible results of the configuration? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

A. n IDENTITY column

B. GUID column

C. sequence object

View answer

Correct Answer: BE

Question #2

You are modifying an existing disaster recovery solution for an Azure SQL managed instance that contains a failover group named FG1.You need to ensure the maximum in-transit time for FG1 when an automatic failover oсcurs.What should you configure?

A. n availability group

B. secondary managed instance

C. failover policy

D. grace period

View answer

Correct Answer: D

Question #3

You have an Azure SQL database named DB1.You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs.Which deployment option and pricing tier should you configure?

A. zure SQL Database Business Critical

B. zure SQL Database Standard

C. zure SQL Database managed instance General Purpose

D. zure SQL Database Hyperscale

View answer

Correct Answer: A

Question #4

HOTSPOT (Drag and Drop is not supported)You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1.You run the following query.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #5

HOTSPOT (Drag and Drop is not supported)You have an Azure SQL database.You are reviewing a slow performing query as 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.NOTE: Each correct selection is worth one point.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #6

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?

A. reate an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group

B. dd a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub

C. dd a diagnostic setting that logs Timeouts and streams to an Azure event hub

D. reate an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group

View answer

Correct Answer: D

Question #7

You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1.Several users execute adhoc queries to DW1 concurrently. You regularly perform automated data loads to DW1.You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run.What should you do?

A. ssign a smaller resource class to the automated data load queries

B. reate sampled statistics to every column in each table of DW1

C. ssign a larger resource class to the automated data load queries

D. ash distribute the large fact tables in DW1 before performing the automated data loads

View answer

Correct Answer: C

Question #8

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You nee

A. es

B. o

View answer

Correct Answer: B

Question #9

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have two Azure SQL Database servers named Server1 and Server2. Each server c

A. es

B. o

View answer

Correct Answer: A

Question #10

You have an Azure SQL database named SQL1.You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:•The recovery point objective (RPO)•The recovery time objective (RTO)•Administrative effortWhat should you include in the solution?

A. zure Site Recovery

B. ctive geo-replication

C. vailability groups

D. uto-failover groups

View answer

Correct Answer: D

Question #11

You have an Azure SQL database named db1 on a server named server1.The Intelligent Insights diagnostics log identifies that several tables are missing indexes. You need to ensure that indexes are created for the tables.What should you do?

A. un the DBCC SQLPERF command

B. un the DBCC DBREINDEX command

C. odify the automatic tuning settings for db1

D. odify the Query Store settings for db1

View answer

Correct Answer: C

Question #12

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You nee

A. es

B. o

View answer

Correct Answer: B

Question #13

DRAG DROP (Drag and Drop is not supported)Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks.You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order.Select and Place:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #14

HOTSPOT (Drag and Drop is not supported)You have an Azure SQL managed instance.You need to restore a database named DB1 by using Transact-SQL.Which command should you run? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #15

You have an Azure subscription that contains 20 Azure SQL databases.You create a Transact-SQL statement to perform index maintenance on a database.You need to schedule the statement to run once daily against each database by using Transact-SQL commands.What should you use to schedule the statement?

A. n Azure function

B. SQL Server Agent Job

C. n elastic job

D. zure Automation

View answer

Correct Answer: D

Question #16

You have an Azure SQL managed instance that hosts multiple databases.You need to configure alerts for each database based on the diagnostics telemetry of the database. What should you use?

A. zure SQL Analytics alerts based on metrics

B. QL Health Check alerts based on diagnostics logs

C. QL Health Check alerts based on metrics

D. zure SQL Analytics alerts based on diagnostics logs

View answer

Correct Answer: D

Question #17

You have the following resources:•15 SQL Server on Azure Virtual Machines instances•20 Azure SQL databasesYou need to recommend a solution to centrally monitor the resources for security vulnerabilities.What should you include in the recommendation?

A. atabase audits

B. icrosoft Defender

C. QL insights

D. zure SQL Auditing

View answer

Correct Answer: C

Question #18

A company plans to use Apache Spark analytics to analyze intrusion detection data.You need to recommend a solution to analyze network and system activity data for malicious activities and policy violations. The solution must minimize administrative efforts.What should you recommend?

A. zure Data Lake Storage

B. zure Databricks

C. zure HDInsight

D. zure Data Factory

View answer

Correct Answer: C

Question #19

You have an Azure SQL database named DB1 that contains a nonclustered index named index1.End users report slow queries when they use index1.You need to identify the operations that are being performed on the index.Which dynamic management view should you use?

A. ys

B. ys

C. ys

D. ys

View answer

Correct Answer: D

Question #20

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You nee

A. es

B. o

View answer

Correct Answer: B

Question #21

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #22

HOTSPOT (Drag and Drop is not supported)You need to deploy an Azure SQL Database elastic pool by using a Bicep template.How should you complete the template? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #23

You have an Azure SQL managed instance.You need to configure the SQL Server Agent service to email job notifications.Which statement should you execute?

A. XECUTE msdb

B. XECUTE msdb

C. XECUTE msdb

D. XECUTE msdb

View answer

Correct Answer: C

Question #24

You have an Azure Stream Analytics job.You need to ensure that the job has enough streaming units provisioned. You configure monitoring of the SU % Utilization metric.Which two additional metrics should you monitor? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. lusters

B. obs

C. BFS

D. SH

E. orkspace

View answer

Correct Answer: CD

Question #25

You have an Azure SQL database named DB1.You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs.Which deployment option and pricing tier should you configure?

A. zure SQL Database Premium

B. zure SQL Database serverless

C. zure SQL Database Basic

D. zure SQL Database Hyperscale

View answer

Correct Answer: A

Question #26

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have SQL Server 2019 on an Azure virtual machine.You are troubleshooting per

A. es

B. o

View answer

Correct Answer: A

Question #27

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:-Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.-Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.What should you create on VNet1?

A. ee Explanation section for answer

View answer

Correct Answer: C

Question #28

HOTSPOT (Drag and Drop is not supported)You configure backups for an Azure SQL database as 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.NOTE: Each correct selection is worth one point.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #29

You have an Azure SQL database named DB1. You run a query while connected to DB1.You review the actual execution plan for the query, and you add an index to a table referenced by the query. You need to compare the previous actual execution plan for the query to the Live Query Statistics.What should you do first in Microsoft SQL Server Management Studio (SSMS)?

A. or DB1, set QUERY_CAPTURE_MODE of Query Store to All

B. un the SET SHOWPLAN_ALL Transact-SQL statement

C. ave the actual execution plan

D. nable Query Store for DB1

View answer

Correct Answer: C

Question #30

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You nee

A. es

B. o

View answer

Correct Answer: B

Question #31

You have an Azure subscription that contains the resources shown in the following table.App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.What should you do?

A. ee Explanation section for answer

View answer

Correct Answer: D

Question #32

DRAG DROP (Drag and Drop is not supported)You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases.You add a user named dbadmin1 as a SQL Server Agent operator. You need to ensure that dbadmin1 receives an email alert if a job fails.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.Select and Place:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #33

You have an Azure SOI database named SQLDb1 that contains the resources shown in the following table.Column1 contains JSON data.You need to compress Column1. The solution must minimize the amount of storage used.What should you use?

A. he COMPRESS() function

B. olumnstore archive compression

C. ow compression

D. olumnstore compression

View answer

Correct Answer: A

Question #34

You have a new Azure SQL database. The database contains a column that stores confidential information.You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed.Which three actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. Turn on auditing and write audit logs to an Azure Storage account

B. Add extended properties to the column

C. Turn on auditing and write audit logs to an Event Hub

D. Apply sensitivity labels named Highly Confidential to the column

E. Turn on Azure Defender for SQL

View answer

Correct Answer: ADE

Question #35

HOTSPOT (Drag and Drop is not supported)You plan to migrate on-premises Microsoft SQL Server databases to Azure.You need to identify which deployment and resiliency options meet the following requirements:-Support user-initiated backups.-Support multiple automatically replicated instances across Azure regions.-Minimize administrative effort to implement and maintain business continuity.What should you identify? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is wort

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #36

You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.You need to update the column and index statistics for the databases.What should you use?

A. n Azure Automation runbook

B. SQL Agent job

C. zure SQL Analytics

D. utomatic tuning in Azure SQL Database

View answer

Correct Answer: A

Question #37

HOTSPOT (Drag and Drop is not supported)You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspaces named WS1 and WS2.ADF1 contains the following pipelines:P1:Uses a copy activity to copy data from a nonpartitioned table in a dedicated SQL pool of WS1 to an Azure Data Lake Storage Gen2 accountP2:Uses a copy activity to copy data from text-delimited files in an Azure Data Lake Storage Gen2 account to a nonpartitioned table in a dedicated SQL pool of WS2You need to configure

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #38

You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected.You need to identify whether the performance issue relates to the use of tempdb by Azure SQL databases on sqlsrv1.What should you do?

A. un Query Store-based queries

B. eview information provided by SQL Server Profiler-based traces

C. eview information provided by Query Performance Insight

D. un dynamic management view-based queries

View answer

Correct Answer: D

Question #39

You have an Azure virtual machine based on a custom image named VM1.VM1 hosts an instance of Microsoft SQL Server 2019 Standard.You need to automate the maintenance of VM1 to meet the following requirements:-Automate the patching of SQL Server and Windows Server.-Automate full database backups and transaction log backups of the databases on VM1.-Minimize administrative effort.What should you do first?

A. ee Explanation section for answer

View answer

Correct Answer: D

Question #40

You have SQL Server on an Azure virtual machine.You need to add a 4-TB volume that meets the following requirements: Maximizes IOPsUses premium solid state drives (SSDs) What should you do?

A. ttach two mirrored 4-TB SSDs

B. ttach a stripe set that contains four 1-TB SSDs

C. ttach a RAID-5 array that contains five 1-TB SSDs

D. ttach a single 4-TB SS

View answer

Correct Answer: B

Question #41

HOTSPOT (Drag and Drop is not supported)You have an Azure SQL database.You have a query and the associated execution plan as 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.NOTE: Each correct selection is worth one point.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #42

What should you implement to meet the disaster recovery requirements for the PaaS solution?

A. vailability Zones

B. ailover groups

C. lways On availability groups

D. eo-replication

View answer

Correct Answer: B

Question #43

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.You plan to migrate DB1 to an Azure SQL Database managed instance.What should you use to minimize downtime and data loss during the migration?

A. zure Event Hubs Standard

B. zure Stream Analytics

C. zure Data Factory

D. zure Event Hubs Dedicated

View answer

Correct Answer: D

Question #44

HOTSPOT (Drag and Drop is not supported)You have an Azure data factory that has two pipelines named PipelineA and PipelineB. PipelineA has four activities as shown in the following exhibit.PipelineB has two activities as shown in the following exhibit. You create an alert for the data factory that uses Failed pipeline runs metrics for both pipelines and all failure types. The metric has the following settings:-Operator: Greater than-Aggregation type: Total-Threshold value: 2-Aggregation granularity (Period)

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #45

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have two Azure SQL Database servers named Server1 and Server2. Each server c

A. es

B. o

View answer

Correct Answer: A

Question #46

You have an Azure subscription that contains an Azure SQL database named db1.You need to implement SQL insights for db1.Which two resources should you create first? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. nable automatic tuning for db1

B. ncrease the number of vCores allocated to db1

C. ecrease the auto-pause delay for db1

D. isable auto-pause delay for db1

View answer

Correct Answer: BE

Question #47

HOTSPOT (Drag and Drop is not supported)You have an Azure SQL database named DB1 in the General Purpose service tier.You need to monitor DB1 by using SQL Insights.What should you include in the solution? To answer, select the appropriate options in theanswer area.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #48

You receive numerous alerts from Azure Monitor for an Azure SQL database.You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. BCC SHRINKDATABASE

B. p_clean_db_free_space

C. p_clean_db_file_free_space

D. BCC SHRINKFILE

View answer

Correct Answer: BD

Question #49

You have an Azure SQL database.Users report that the executions of a stored procedure are slower than usual. You suspect that a regressed query is causing the performance issue.You need to view the query execution plan to verify whether a regressed query is causing the issue. The solution must minimize effort.What should you use?

A. erformance Recommendations in the Azure portal

B. xtended Events in Microsoft SQL Server Management Studio (SSMS)

C. uery Store in Microsoft SQL Server Management Studio (SSMS)

D. uery Performance Insight in the Azure portal

View answer

Correct Answer: C

Question #50

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.You scale up the virtual machine to 16 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb.What is the total number of data files that tempdb should contain?

A.

B.

C.

D. 4

View answer

Correct Answer: C

Question #51

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.What should you include in the re

A. zure Backup

B. zure Information Protection

C. indows Server Failover Cluster

D. zure Site Recovery

View answer

Correct Answer: D

Question #52

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have SQL Server 2019 on an Azure virtual machine.You are troubleshooting per

A. es

B. o

View answer

Correct Answer: B

Question #53

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1.You need to move a SQL Server Agent job from DB1 to SQLMI1.Which job attribute is unsupported in SQLMI1?

A. og to table

B. mail notifications

C. chedules

D. utput files

View answer

Correct Answer: D

Question #54

HOTSPOT (Drag and Drop is not supported)You have an Azure subscription that contains an Azure SQL database.The database fails to respond to queries in a timely manner.You need to identify whether the issue relates to resource_semaphore waits.How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #55

You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.Which resource type should you use to create the alert?

A. esource Groups

B. QL Servers

C. QL Databases

D. QL Virtual Machines

View answer

Correct Answer: C

Question #56

HOTSPOT (Drag and Drop is not supported)You have an Azure SQL database.You run the following PowerShell script.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #57

DRAG DROP (Drag and Drop is not supported)You have an Azure subscription that contains an Azure SQL managed instance named SQLMi1 and a SQL Agent job named Backupdb. Backupdb performs a daily backup of the databases hosted on SQLMi1.You need to be notified by email if the job fails.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.NOTE: More than one order of answer choices is correct.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #58

You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8.You need to deploy a failover cluster instance (FCI) to VM1 and VM2 that will use Azure shared disks. The solution must maximize resiliency.Which quorum option should you use?

A. ode majority with a cloud witness

B. ode majority with no witness

C. ode majority with a file share witness

D. ode majority with a disk witness

View answer

Correct Answer: D

Question #59

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have two Azure SQL Database servers named Server1 and Server2. Each server c

A. es

B. o

View answer

Correct Answer: A

Question #60

You have an Azure Data Factory that contains 10 pipelines.You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.What should you add to each pipeline?

A. n annotation

B. resource tag

C. run group ID

D. user property

E. correlation ID

View answer

Correct Answer: A

Question #61

HOTSPOT (Drag and Drop is not supported)You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1.You need to monitor DB1 by using Extended Events. The solution must meet the following requirements:•Capture raw event data and store the data in Azure Storage.•Minimize the performance impact of capturing extended events.How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answ

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #62

You have an Azure SQL managed instance.You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.What should you do?

A. enerate an estimated execution plan

B. enerate an actual execution plan

C. un sys

D. enerate Live Query Statistics

View answer

Correct Answer: C

Question #63

You have an Azure Data Factory pipeline that is triggered hourly. The pipeline has had 100% success for the past seven days.The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error. What is a possible cause of the error?

A. rom 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON

B. he parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect

C. rom 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect

D. he pipeline was triggered too early

View answer

Correct Answer: B

Question #64

You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases.You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation.You need to create the required Automation accounts.Which two accounts should you create? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. ull

B. ightweight

C. oAgent

View answer

Correct Answer: AC

Question #65

DRAG DROP (Drag and Drop is not supported)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.Select an

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #66

You have an Azure subscription.You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:•Minimize how long it takes to fail over.•Maintain existing connections to the primary replica during a failover.What should you do?

A. onnect each virtual machine to a different subnet on a virtual network

B. onnect each virtual machine to a different subnet on a single virtual network

C. onnect each virtual machine to a single subnet on a single virtual network

D. onnect each virtual machine to a single subnet on a virtual network

View answer

Correct Answer: C

Question #67

You plan to deploy an Azure SQL managed instance.You need to restore database backups across regions.Which type of storage account should you use?

A. ocally-redundant storage (LRS)

B. one-redundant storage (ZRS)

C. eo-zone-redundant storage (GZRS)

D. eo-redundant storage (GRS)

View answer

Correct Answer: D

Question #68

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances.The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1.You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements:•Provide an availability SLA.•Minimize costs.What should you create?

A. n Azure Standard Load Balancer

B. virtual network name (VNN) resource

C. Basic Azure Load Balancer

D. distributed network name (DNN) resource

View answer

Correct Answer: D

Question #69

DRAG DROP (Drag and Drop is not supported)You have an Azure subscription that contains the resources shown in the following table.You need to back up db1 to mysqlbackups, and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to a stripe set.Which three Transact-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.Se

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #70

DRAG DROP (Drag and Drop is not supported)You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator.You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication.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.Select and Place:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #71

Your company uses Azure Stream Analytics to monitor devices.The company plans to double the number of devices that are monitored.You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load.Which metric should you monitor?

A. ocal tempdb percentage

B. WU percentage

C. ata Warehouse Units (DWU) used

D. ache hit percentage

View answer

Correct Answer: D

Question #72

You need to identify the cause of the performance issues on SalesSQLDb1.Which two dynamic management views should you use? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. REATE LOGIN and the FROM WINDOWS clause

B. REATE USER and the FROM CERTIFICATE clause

C. REATE USER and the FROM LOGIN clause

D. REATE USER and the ASYMMETRIC KEY clause

E. REATE USER and the FROM EXTERNAL PROVIDER clause

View answer

Correct Answer: CF

Question #73

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.You need to recommend a deployment solution that meets the following requirements:•Provides a Service Level Agreement (SLA) of at least 99.95%•Replicates databases in the same group synchronously•Minimizes the latency of database writesWhat should you recommend?

A. reate two proximity groups and two availability sets

B. reate a proximity group and an availability set

C. reate a proximity group and two availability sets

D. reate two proximity groups and a single availability set

View answer

Correct Answer: B

Question #74

You deploy an instance of SQL Server on Azure Virtual Machines named VM1.You need to create a SQL Server Agent job that will rebuild indexes of the databases hosted on VM1. The solution must use the principle of least privilege.What should you create first?

A. local Windows account

B. user-assigned managed identity in Azure AD

C. system-assigned managed identity in Azure AD

D. n Elastic Job agent

View answer

Correct Answer: C

Question #75

You plan to move two 100-GB databases to Azure.You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.What should you use?

A. wo Azure SQL Databases in an elastic pool

B. wo databases hosted in SQL Server on an Azure virtual machine

C. wo databases in an Azure SQL Managed instance

D. wo single Azure SQL databases

View answer

Correct Answer: A

Question #76

You have an Azure Databricks resource.You need to log actions that relate to changes in compute for the Databricks resource. Which Databricks services should you log?

A. nput Deserialization Errors

B. ate Input Events

C. arly Input Events

D. atermark delay

View answer

Correct Answer: E

Question #77

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. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have SQL Server 2019 on an Azure virtual machine.You are troubleshooting per

A. es

B. o

View answer

Correct Answer: B

Question #78

You are monitoring an Azure Stream Analytics job.You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero. You need to ensure that the job can handle all the events.What should you do?

A. emove any named consumer groups from the connection and use $default

B. hange the compatibility level of the Stream Analytics job

C. reate an additional output stream for the existing input stream

D. ncrease the number of streaming units (SUs)

View answer

Correct Answer: D

Question #79

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:? Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.? Restrict network connectivity to SqlSrv1.What should you create on VNet1?

A. a VPN gateway

B. a service endpoint

C. a private link

D. an ExpressRoute gateway

View answer

Correct Answer: C

Question #80

HOTSPOT (Drag and Drop is not supported)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.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #81

You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.Which type of storage accounts should you use for the backups?

A. ocally-redundant storage (LRS)

B. ead-access geo-redundant storage (RA-GRS)

C. one-redundant storage (ZRS)

D. eo-redundant storage

View answer

Correct Answer: B

Question #82

You have an Azure subscription that contains the following resources.* 10 Azure SQL databases* Five Azure SQL managed instances* Five instances of SQL Server on Azure Virtual MachinesYou need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort. What should you include in the solution?

A. og Analytics

B. zure SQL Analytics

C. uery Performance Insight

D. QL Insights

View answer

Correct Answer: B

Question #83

You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.You need to recommend a database service for the deployment. The solution must minimize administrative effort.What should you include in the recommendation?

A. zure SQL Managed instance

B. zure SQL Database single database

C. zure Database for PostgreSQL

D. QL Server on Azure virtual machines

View answer

Correct Answer: B

Question #84

You have an instance of SQL Server on Azure Virtual Machines named VM1.You need to implement a disaster recovery solution that meets the following requirements:•Returns the solution to an operational state within 15 minutes of a failure•Can perform disaster recovery testing in an isolated environment•Minimizes administrative effortWhat should you include in the solution?

A. ctive geo-replication

B. uto-failover groups

C. zure Site Recovery

D. failover cluster instance (FCI)

View answer

Correct Answer: C

Question #85

You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLMI1 contains a database named DB1 and a user named User1.User1 drops DB1.You need to perform a point-in-time restore of DB1 to SQLMI2.What should you use to perform the restore?

A. zure CLI

B. ransact-SQL

C. he Azure portal

D. zure PowerShell

View answer

Correct Answer: C

Question #86

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:? Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.? Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.What should you create on VNet1?

A. a VPN gateway

B. a service endpoint

C. a private link

D. an ExpressRoute gateway

View answer

Correct Answer: C

Question #87

You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements:-Support failovers that do not require client applications to change their connection strings.-Replicate the database to a secondary Azure region.-Support failover to the secondary region.What should you include in the recommendation?

A. ailover groups

B. ransactional replication

C. vailability Zones

D. eo-replication

View answer

Correct Answer: A

Question #88

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?

A. estore with Recovery

B. estore with Norecovery

C. estore with Standby

View answer

Correct Answer: B

DON'T WANT TO MISS A THING?

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE!
Get Now

Updated Microsoft DP-300 Exam Questions for Effective Preparation

View Answers after Submission

DON'T WANT TO MISS A THING?

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE! Get Now

Updated Microsoft DP-300 Exam Questions for Effective Preparation

View Answers after Submission

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE!
Get Now