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

Questions 1

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

Options:
A.

SELECT

B.

JOIN

C.

MERGE

D.

CREATE

Microsoft DP-900 Premium Access
Questions 2

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 2

Options:
Questions 3

Select the answer that correctly completes the sentence.

DP-900 Question 3

Options:
Questions 4

Y ou need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.

What should you use?

Options:
A.

Synapse pipelines

B.

a Synapse SQL pool

C.

Synapse Link

D.

Synapse Studio

Questions 5

Select the answer that correctly completes the sentence.

DP-900 Question 5

Options:
Questions 6

What is a characteristic of non-relational data?

Options:
A.

a well-defined schema

B.

no indexes

C.

self-describing entities

D.

no unique key values

Questions 7

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL

database.

Which type of authentication should you use?

Options:
A.

service principal authentication

B.

Azure Active Directory (Azure AD) authentication

C.

SQL authentication

D.

certificate authentication

Questions 8

How is raw data stored in a data lakehoose?

Options:
A.

as tables

B.

as queues

C.

as files

D.

as disks

Questions 9

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Options:
A.

container

B.

item

C.

database

D.

partition

Questions 10

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 10

Options: