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

Exact2Pass Menu

Microsoft Azure Data Fundamentals

Last Update 18 hours ago Total Questions : 316

The Microsoft Azure Data Fundamentals content is now fully updated, with all current exam questions added 18 hours ago. Deciding to include DP-900 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our DP-900 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these DP-900 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Microsoft Azure Data Fundamentals practice test comfortably within the allotted time.

Question # 71

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

A.

INSERT

B.

MERGE

C.

UPDATE

D.

CREATE

Question # 72

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

A.

soft delete

B.

archive storage

C.

the change feed

D.

a lifecycle management policy

Question # 73

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

A.

an Azure SQL Database elastic pool

B.

Azure SQL Managed Instance

C.

Azure Database for MySQL

D.

Azure SQL Database

Question # 74

Select the answer that correctly completes the sentence.

Question # 75

Select the answer that correctly completes the sentence.

Question # 76

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

A.

supports partitioning

B.

provides resiliency if art Azure region fads

C.

provides a higher storage capacity

D.

supports a multi-master model

Question # 77

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

NOTE: Each correct selection is worth one point.

Question # 78

In a fully denormalized database, how is data read and written for a single entity?

A.

Data is read from a single table and written to a single table.

B.

Data is read from multiple tables and written to a single table.

C.

Data is read from a single table and written to multiple tables.

D.

Data is read from multiple tables and written to multiple tables.

Question # 79

Select the answer that correctly completes the sentence.

Question # 80

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

A.

MERGE

B.

ALTER

C.

INSERT

D.

UPD ATE

Go to page: