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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 3 / 10
Total 319 questions

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

A.

SELECT

B.

INSERT

C.

DELETE

D.

DROP

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

A.

stream processing

B.

batch processing

C.

Online Analytical Processing (OLTP)

D.

Online Transaction Processing (OLTP)

You have the following JSON document.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.

NOTE: Each correct selection is worth one point.

Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

A.

Archive to Cool

B.

Hot to Cool

C.

Cool to Archive

D.

Hot to Archive

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Which type of database is Azure Database for PostgreSQL?

A.

Platform as a service (PaaS)

B.

Infrastructure as a service (laaS)

C.

Microsoft SQL Server

D.

on-premises

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

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 the answer that correctly completes the sentence.

Which storage solution supports access control lists (ACLs) at the file and folder level?

A.

Azure Data Lake Storage

B.

Azure Cosmos DB

C.

Azure Queue storage

D.

Azure Blob storage