DP-300 Online Practice Questions and Answers

You have the following Azure Data Factory pipelines:

1.

Ingest Data from System1

2.

Ingest Data from System2

3.

Populate Dimensions

4.

Populate Facts

Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.

What should you do to schedule the pipelines for execution?

A. Add a schedule trigger to all four pipelines.

B. Add an event trigger to all four pipelines.

C. Create a parent pipeline that contains the four pipelines and use an event trigger.

D. Create a parent pipeline that contains the four pipelines and use a schedule trigger.

You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.

FactSales has 6 billion rows and is loaded nightly by using a batch process.

Which type of compression provides the greatest space reduction for the database?

A. page compression

B. row compression

C. columnstore compression

D. columnstore archival compression

You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features.

You plan to migrate to Azure SQL.

Which service should you use?

A. Azure SQL Database

B. SQL Server on an Azure Virtual Machine

C. Azure SQL Managed Instance

D. Azure Database for MySQL

You have an Azure subscription that contains a logical SQL server named Server1. The master database of Server1 contains a user named User1. You need to ensure that User1 can create databases on Server1.

Which database role should you assign to User1?

A. db_owner

B. dbmanager

C. dbo

D. db_ddladmin

You have a Microsoft SQL Server 2017 server.

You need to migrate the server to Azure. The solution must meet the following requirements:

Ensure that the latest version of SQL Server is used.

Support the SQL Server Agent service.

Minimize administrative effort.

What should you use?

A. an Azure SQL Database elastic pool

B. Azure SQL Database

C. SQL Server on Azure Virtual Machines

D. Azure SQL Managed Instance

You manage 100 Azure SQL managed instances located across 10 Azure regions.

You need to receive voice message notifications when a maintenance event affects any of the 10 regions.

The solution must minimize administrative effort.

What should you do?

A. From the Azure portal, create a service health alert.

B. From the Azure portal, create an Azure Advisor operational excellence alert.

C. From Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.

D. From the Azure portal, configure an activity log alert.

You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019.

The virtual machine has 4 vCPUs and 28 GB of memory.

Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory.

You need to reduce tempdb contention without regatively affecting server performance.

What is the number of secondary data files that you should configure for tempdb?

A. 2

B. 4

C. 8

D. 64

HOTSPOT

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:

HOTSPOT

You have an Azure subscription.

You need to deploy a logical SQL server by using PowerShell. The solution must ensure that the logical SQL server can create Azure AD users and provide Transparent Data Encryption (TDE) with a customer-managed key.

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

NOTE: Each correct selection is worth one point.

Hot Area:

DRAG DROP

You have an Azure subscription.

You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance.

You need to configure the disks on the virtual machine. The solution must meet the following requirements:

1.

Minimize latency for transaction logs.

2.

Minimize the impact on IO Of the virtual machine.

Which type of disk should you use for each workload?

To answer. drag the appropriate disk types to the correct workloads. Each disk type may be used once, at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place: