DP-900 Online Practice Questions and Answers

You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

A. You need to generate reports without affecting the transactional workload.

B. You need to audit the transactional application.

C. You need to implement high availability in the event of a regional outage

D. You need to improve the recovery point objective (RPO).

You have a SQL query that combines customer data and order data

The query includes calculated columns.

You need to persist the SQL query so that other users can use the query. What should you create?

A. a table

B. an index

C. scalar function

D. a view

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?

A. Azure DNS

B. Azure Application Gateway

C. Azure Private link

D. Azure Traffic Manager

Which statement is an example of Data Definition Language (DDL)?

A. SELECT

B. INSERT

C. DELETE

D. DROP

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

A. isolation

B. durability

C. atomicity

D. consistency

You have an on-premises Microsoft SQL Server database.

You need to migrate the database to the cloud. The solution must meet the following requirements:

*

Minimize maintenance effort.

*

Support the Database Mail and Service Broker features. What should you include in the solution?

A.

Azure SQL Database single database

B.

an Azure SQL Database elastic pool

C.

Azure SQL Managed instance

D.

SQL Server on Azure virtual machines

DRAG DROP

Match the terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select and Place:

HOTSPOT

To complete the sentence, select the appropriate option in the answer area.

Hot Area:

HOTSPOT

Select the answer that correctly completes the sentence.

Hot Area:

HOTSPOT

Select the answer that correctly completes the sentence.

Hot Area: