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

Pass the Microsoft Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with CertsForce

Viewing page 5 out of 10 pages
Viewing questions 41-50 out of questions
Questions # 41:

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

Question # 41

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

Options:

A.

INSERT


B.

MERGE


C.

UPDATE


D.

CREATE


Expert Solution
Questions # 42:

Select the answer that correctly completes the sentence.

Question # 42


Expert Solution
Questions # 43:

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

Question # 43


Expert Solution
Questions # 44:

Which language is used to define queries in Azure Synapse Data Explorer?

Options:

A.

Bash


B.

PowerShell


C.

KQL


D.

SQL


Expert Solution
Questions # 45:

You have an application that runs on Windows and requires across to a mapped drive.

Which Azure service should you use?

Options:

A.

Azure Cosmos DB


B.

Azure Table storage


C.

Azure Files


D.

Azure Blob Storage


Expert Solution
Questions # 46:

Select the answer that correctly completes the sentence.

Question # 46


Expert Solution
Questions # 47:

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.

Question # 47


Expert Solution
Questions # 48:

Match the job roles to the appropriate tasks.

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

NOTE: Each correct match is worth one point.

Question # 48


Expert Solution
Questions # 49:

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

Options:

A.

SELECT


B.

JOIN


C.

MERGE


D.

CREATE


Expert Solution
Questions # 50:

You need to gather real-time telemetry data from a mobile application.

Which type of workload d escribes this scenario?

Options:

A.

Online Transaction Processing (OLTP)


B.

batch


C.

massively parallel processing (MPP)


D.

streaming


Expert Solution
Viewing page 5 out of 10 pages
Viewing questions 41-50 out of questions