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: 8

Questions 71

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,

backups, and maintenance tasks?

Options:
A.

Azure SQL M anaged Instance

B.

SQL Server on Azure Virtual Machines

C.

Azure SQL Edge

D.

Azure SQL Database

Microsoft DP-900 Premium Access
Questions 72

Select the answer that correctly completes the sentence.

DP-900 Question 72

Options:
Questions 73

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

DP-900 Question 73

Options:
Questions 74

Select the answer that correctly completes the sentence.

DP-900 Question 74

Options:
Questions 75

Select the answer that correctly completes the sentence.

DP-900 Question 75

Options:
Questions 76

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Options:
A.

WHERE

B.

SELECT

C.

JOIN

Questions 77

Select the answer that correctly completes the sentence.

DP-900 Question 77

Options:
Questions 78

Select the answer that correctly completes the sentence.

DP-900 Question 78

Options:
Questions 79

match the Azure data factory components to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

DP-900 Question 79

Options:
Questions 80

Which setting can only be configured during the creation of an Azure Cosmos DB account?

Options:
A.

geo-redundancy

B.

multi-region writes

C.

production or non-reduction account type

D.

API