Summer Sale Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

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

Exam DP-900 Premium Access

View all detail and faqs for the DP-900 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 3 out of 10 pages
Viewing questions 21-30 out of questions
Questions # 21:

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

Question # 21

Options:

Questions # 22:

Select the answer that correctly completes the sentence.

Options:

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.

Question # 23

Options:

Questions # 24:

Match the Azure SQL services to the appropriate use cases.

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

NOTE: Each correct match is worth one point.

Question # 24

Options:

Questions # 25:

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

Options:

A.

stream processing

B.

batch processing

C.

Online Analytical Processing (OLTP)

D.

Online Transaction Processing (OLTP)

Questions # 26:

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Options:

A.

Data Definition Language (DDL)

B.

Data Control Language (DCL)

C.

Data Manipulation Language (DML)

Questions # 27:

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

Options:

A.

Microsoft SQL Server Management Studio (SSMS)

B.

Azure Data Studio

C.

Azure CLI

D.

Azure PowerShell

Questions # 28:

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 # 28

Options:

Questions # 29:

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 # 29

Options:

Questions # 30:

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

Question # 30

Options:

Viewing page 3 out of 10 pages
Viewing questions 21-30 out of questions