Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

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

Practice at least 50% of the questions to maximize your chances of passing.
Exam DP-900 Premium Access

View all detail and faqs for the DP-900 exam


830 Students Passed

91% Average Score

91% Same Questions
Viewing page 6 out of 10 pages
Viewing questions 51-60 out of questions
Questions # 51:

Match the types of data to the appropriate Azure data services.

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

NOTE: Each correct match is worth one point.

Question # 51

Options:

Questions # 52:

Select the answer that correctly completes the sentence.

Question # 52

Options:

Questions # 53:

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

Options:

Questions # 54:

You have a quality assurance application that reads data from a data warehouse.

Which type of processing does the application use?

Options:

A.

Online Transaction Processing (OLTP)

B.

batch processing

C.

Online Analytical Processing (OLAP)

D.

stream processing

Questions # 55:

Which scenario is an example of a streaming workload?

Options:

A.

sending transactions that are older than a month to an archive

B.

sending transactions daily from point of sale (POS) devices

C.

sending telemetry data from edge devices

D.

sending cloud infrastructure metadata every 30 minutes

Questions # 56:

Match the job roles to the appropriate tasks.

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

NOTE: Each correct match is worth one point.

Question # 56

Options:

Questions # 57:

Your company is designing a data store that will contain student data. The data has the following format.

Question # 57

Which type of data store should you use?

Options:

A.

graph

B.

key/value

C.

object

D.

columnar

Questions # 58:

You have data saved in the following format.

Question # 58\

Which format was used?

Options:

A.

XML

B.

yaml

C.

JSON

D.

HTML

Questions # 59:

Select the answer that correctly completes the sentence.

Question # 59

Options:

Questions # 60:

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

Viewing page 6 out of 10 pages
Viewing questions 51-60 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.