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

Questions 91

You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.

Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options:
A.

JOIN

B.

ORDERBY

C.

INDEX

D.

SLLLCT

E.

EXISTS

Microsoft DP-900 Premium Access
Questions 92

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

NOTE: Each correct selection is worth one point.

DP-900 Question 92

Options:
Questions 93

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

Options:
A.

SELECT

B.

INSERT

C.

DELETE

D.

DROP

Questions 94

Match the types of data stores to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

DP-900 Question 94

Options: