20:00

Free Test
/ 10

Quiz

1/10
A bar chart showing year-to date sales by region is an example of which type of analytics?
Select the answer
1 correct answer
A.
descriptive
B.
diagnostic
C.
predictive
D.
prescriptive

Quiz

2/10
To complete the sentence, select the appropriate option in the answer area.
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 3-81901831



Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 1-1229087089
Select the answer
1 correct answer
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 2-29743793

Disadvantages of non-relational databases include: Data Consistency — non-relational databases do
not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and
availability. Advantages of relational databases include simplicity, ease of data retrieval, data
integrity, and flexibility.
Incorrect Answers:
Use a relational database when data that you work with is structured, and the structure is not subject
to frequent changes.
Use Cloud storage (no relational database) for geographically distributed writes.
Reference:
[https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77](https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77)

Quiz

3/10
To complete the sentence, select the appropriate option in the answer area.
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 3-81901831
Select the answer
1 correct answer
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 6-408166406



Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 4-3494461120

Quiz

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

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 5-951332782
Select the answer
1 correct answer
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 6-408166406


Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question : What’s happening?
Diagnostic, to answer the question: Why’s happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
Reference:
[https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-](https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-)
will-happen-with-iot-analytics/

Quiz

5/10
DRAG DROP
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. Each location may be used 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.

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 7-3566667153
Select the answer
1 correct answer
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 8-970827110

Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering,


sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 10-2415325272

Reference:
[https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl](https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl)

Quiz

6/10
Your company recently reported sales from the third quarter.


You have the chart shown in the following exhibit.

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 9-3888758765

Which type of analysis is shown for the fourth quarter?
Select the answer
1 correct answer
A.
predictive
B.
prescription
C.
descriptive
D.
diagnostic

Quiz

7/10
DRAG DROP
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.

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 11-3258717068
Select the answer
1 correct answer
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 12-369270564

Quiz

8/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.

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 13-575095632
Select the answer
1 correct answer
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 14-2980506740

Quiz

9/10
DRAG DROP
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.

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 15-1528111973
Select the answer
1 correct answer

Quiz

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

Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 17-2274339467
Select the answer
1 correct answer
Certification Exam Microsoft Azure Data Fundamentals Microsoft Microsoft-DP-900 18-1452589830
Looking for more questions?Buy now

Microsoft Azure Data Fundamentals Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Microsoft Azure Data Fundamentals practice test! Further deepen your knowledge on Microsoft Simulator; by unlocking the full version of our Microsoft Azure Data Fundamentals Simulator you will be able to take tests with over 306 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 306 questions.

BUY NOW

What to expect from our Microsoft Azure Data Fundamentals practice tests and how to prepare for any exam?

The Microsoft Azure Data Fundamentals Simulator Practice Tests are part of the Microsoft Database and are the best way to prepare for any Microsoft Azure Data Fundamentals exam. The Microsoft Azure Data Fundamentals practice tests consist of 306 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Microsoft Azure Data Fundamentals database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Microsoft Azure Data Fundamentals Simulator will also give you an idea of the time it will take to complete each section of the Microsoft Azure Data Fundamentals practice test . It is important to note that the Microsoft Azure Data Fundamentals Simulator does not replace the classic Microsoft Azure Data Fundamentals study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Microsoft Azure Data Fundamentals exam.

BUY NOW

Microsoft Azure Data Fundamentals Practice test therefore represents an excellent tool to prepare for the actual exam together with our Microsoft practice test . Our Microsoft Azure Data Fundamentals Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Microsoft Azure Data Fundamentals Simulator and how our unique Microsoft Azure Data Fundamentals Database made up of real questions:

Info quiz:

  • Quiz name:Microsoft Azure Data Fundamentals
  • Total number of questions:306
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Microsoft Azure Data Fundamentals exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Microsoft Azure Data Fundamentals Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Microsoft Azure Data Fundamentals Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Microsoft Azure Data Fundamentals practice tests which consist of 306 questions and also provide study material to pass the final Microsoft Azure Data Fundamentals exam with guaranteed success. Our Microsoft Azure Data Fundamentals database contain hundreds of questions and Microsoft Tests related to Microsoft Azure Data Fundamentals Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW