Pre-Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70track

Free Microsoft DP-900 Practice Exam with Questions & Answers | Set: 3

Questions 21

Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

Options:
A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Cosmos DB

D.

SQL Server on Azure virtual machines

Microsoft DP-900 Premium Access
Questions 22

What should you use to automatically delete blobs from Azure Blob Storage?

Options:
A.

soft delete

B.

archive storage

C.

the change feed

D.

a lifecycle management policy

Questions 23

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

DP-900 Question 23

Options:
Questions 24

Select the answer that correctly completes the sentence.

DP-900 Question 24

Options:
Questions 25

You plan to deploy a PostgreSQL database to Azure.

Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-900 Question 25

Options:
Questions 26

Select the answer that correctly completes the sentence.

Options:
Questions 27

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

DP-900 Question 27

Options:
Questions 28

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one poin t.

Options:
A.

You must be assigned the Reader role for the resource group that contains the database.

B.

You must have SELECT access to the Products table.

C.

You must have a user in the database.

D.

You must be assigned the Contributor role for the resource group that contains the database.

E.

Your IP address must be allowed to connect to the database.

Questions 29

Select the answer that correctly completes the sentence.

DP-900 Question 29

Options:
Questions 30

Match the types of workloads to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

DP-900 Question 30

Options: