Sample questions and answers

In this section, you will see sample questions about Microsoft tools. Do not be alarmed; we will cover them in the next chapters, but usually, the data analytics concepts are evaluated in DP-900 asking questions or analyzing implementation scenarios in Microsoft analytics platforms.

Here are some questions:

1. You’ve gathered data in a variety of formats from a variety of sources. Now, you must convert the data into a single, consistent format. Which of the following processes would you use?
   1. Data ingestion
   2. Data modeling
   3. Data storage
   4. Dataset
2. The process of transforming and translating raw data into a more useable format for analysis is known as ____________:
   1. Data cleaning
   2. Data ingestion
   3. Data modeling
   4. Data analysis
3. Choose the best sequence for putting the ELT process into action on Azure:
   1. Prepare the data for loading by extracting the source data into text files. Use PolyBase or the COPY command to load the data into staging tables. Transform...