Pre-Winter Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

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

Exam DP-900 All Questions
Exam DP-900 Premium Access

View all detail and faqs for the DP-900 exam

Viewing page 11 out of 11 pages
Viewing questions 101-110 out of questions
Questions # 101:

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

Question # 101

Options:

Expert Solution
Questions # 102:

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

Options:

A.

multi-master replication

B.

Availability Zones

C.

automatic failover

D.

the strong consistency level

Expert Solution
Questions # 103:

Select the answer that correctly completes the sentence.

Question # 103

Options:

Expert Solution
Questions # 104:

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

Options:

A.

a scalar function

B.

a table

C.

an index

D.

a view

Expert Solution
Questions # 105:

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

Expert Solution
Questions # 106:

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

Question # 106

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 # 107:

What is a characteristic of a non-relational database?

Options:

A.

a fixed schema

B.

self-describing entities

C.

full support for Transact-SQL

Expert Solution
Questions # 108:

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

Expert Solution
Questions # 109:

Select the answer that correctly completes the sentence.

Question # 109

Options:

Expert Solution
Questions # 110:

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

Question # 110

Options:

Expert Solution
Viewing page 11 out of 11 pages
Viewing questions 101-110 out of questions