logo
Exam overview and study plan

DP-900 Practice Questions

Azure Data Fundamentals

Read questions, check verified answers and discuss the reasoning. Use reading options to shape your revision, or switch to the simulator for timed practice.

View 82 free questions

82 questions in this view

Page 1 of 14

Question 1

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

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 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.
Answer Area
StatementsYesNo

If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates.

If you have a platform as a service (PaaS) database in Azure, backups are performed automatically.

If you have a platform as a service (PaaS) database in Azure, you are responsible for installation of the database engine.

Question 3

You have an online store that is hosted in Azure. The store generates millions of transaction records daily.

You need to build a data analytics solution that detects fraudulent transactions in real time and enables analysts to run large-scale queries for deeper insights.

Which two services should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 4

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.
Job role
Answer Area
Assign permissions to users.
Derive meaning from data by creating visualizations and charts.
Implement which pipelines to transfer and transform data between systems.

Question 5

What is a difference between structured data and semi-structured data?

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 6

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.
Term
Answer Area
A solution that copies data from files and online transaction processing (OLTP) databases into an analytical processing system.
Contains numeric values that can be analyzed.
A solution that stores data in a relational schema that is optimized for read operations.