Pre-Winter 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: 7

Questions 61

Select the answer that correctly completes the sentence.

DP-900 Question 61

Options:
Microsoft DP-900 Premium Access
Questions 62

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 62

Options:
Questions 63

Which service is optimized for loT scenarios that involve streaming time series data?

Options:
A.

SQL Server on Azure Virtual Machines

B.

Azure SQL Managed Instance

C.

Azure SQL Database

D.

Azure SQL Edge

Questions 64

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Options:
A.

WHERE

B.

SELECT

C.

JOIN

Questions 65

Select the answer that correctly completes the sentence.

DP-900 Question 65

Options:
Questions 66

Select the answer that correctly completes the sentence.

DP-900 Question 66

Options:
Questions 67

From Power Bi Desktop, you are creating a sales performance report. You need to create visualizations that meet the following requirements:

• Display the relationship between the advertising budget and the number of new customers.

• Show the percentage of total sales for each region.

Which type of visualization should you use for each requirement? lo answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-900 Question 67

Options:
Questions 68

Select the answer that correctly completes the sentence.

DP-900 Question 68

Options:
Questions 69

You need to store data in Azure Blob storage for seven years to meet your company ' s compliance

requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

Options:
A.

Archive

B.

Hot

C.

Cool

Questions 70

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

Options:
A.

document

B.

columnar

C.

graph

D.

time series