Pre-Summer 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 2 out of 10 pages
Viewing questions 11-20 out of questions
Questions # 11:

Match the terms to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Question # 11

Options:

Expert Solution
Questions # 12:

Match the types of workloads the appropriate scenario.

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

NOTE: Each correct match is worth one point.

Question # 12

Options:

Expert Solution
Questions # 13:

Match the types of analytics that can be used to answer the business questions.

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

NOTE: Each correct match is worth one point.

Question # 13

Options:

Expert Solution
Questions # 14:

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.

Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Question # 14

Options:

Expert Solution
Questions # 15:

Select the answer that correctly completes the sentence.

Question # 15

Options:

Expert Solution
Questions # 16:

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

Options:

Expert Solution
Questions # 17:

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

You must be assigned the Reader role for the resource group that contains the database.

B.

You must have SELECT access to the Products table.

C.

You must have a user in the database.

D.

You must be assigned the Contributor role for the resource group that contains the database.

E.

Your IP address must be allowed to connect to the database.

Expert Solution
Questions # 18:

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

denormalized data

B.

schema defined when reading unstructured data from a database

C.

light writes and heavy reads

D.

normalized data

E.

schema defined in a database

F.

heavy writes and moderate reads

Expert Solution
Questions # 19:

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)

Expert Solution
Questions # 20:

Which setting can only be configured during the creation of an Azure Cosmos DB account?

Options:

A.

geo-redundancy

B.

multi-region writes

C.

production or non-reduction account type

D.

API

Expert Solution
Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions