Microsoft - DP-900: Microsoft Azure Data Fundamentals
Sample Questions
Question: 320
Measured Skill: Describe an analytics workload on Azure (25–30%)
Which type of Microsoft Power BI visual can you use to examine trends over time for one or more series of values?| A | Funnel chart |
| B | Pie chart |
| C | Table |
| D | Line chart |
Correct answer: DExplanation:
Line charts emphasize the overall shape of an entire series of values, usually over time.
Reference: Visualization types in Power BI
Question: 321
Measured Skill: Describe an analytics workload on Azure (25–30%)
Which service can be used to build extract, transform, and load (ETL) pipelines?| A | Azure Data Factory |
| B | Azure Pipelines |
| C | Azure SQL Database |
| D | Azure Cosmos DB |
| E | Azure Databricks |
Correct answer: AExplanation:
Azure Data Factory is a managed cloud service that's built for complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
Features of Azure Data Factory
Data Compression: During the Data Copy activity, it is possible to compress the data and write the compressed data to the target data source. This feature helps optimize bandwidth usage in data copying.
Extensive Connectivity Support for Different Data Sources: Azure Data Factory provides broad connectivity support for connecting to different data sources. This is useful when you want to pull or write data from different data sources.
Custom Event Triggers: Azure Data Factory allows you to automate data processing using custom event triggers. This feature allows you to automatically execute a certain action when a certain event occurs.
Data Preview and Validation: During the Data Copy activity, tools are provided for previewing and validating data. This feature helps you ensure that data is copied correctly and written to the target data source correctly.
Customizable Data Flows: Azure Data Factory allows you to create customizable data flows. This feature allows you to add custom actions or steps for data processing.
Integrated Security: Azure Data Factory offers integrated security features such as Entra ID integration and role-based access control to control access to dataflows. This feature increases security in data processing and protects your data.
Reference: What is Azure Data Factory?
Question: 322
Measured Skill: Describe an analytics workload on Azure (25–30%)
Select the answer that correctly completes the sentence.
| A | In an analytical model, any point where the dimensions intersect represents a cube. |
| B | In an analytical model, any point where the dimensions intersect represents an aggregated dimension. |
| C | In an analytical model, any point where the dimensions intersect represents an aggregated measure. |
Correct answer: CExplanation:
A cube is a multidimensional structure that contains information for analytical purposes; the main constituents of a cube are dimensions and measures. Dimensions define the structure of the cube that you use to slice and dice over, and measures provide aggregated numerical values of interest to the end user. As a logical structure, a cube allows a client application to retrieve values, of measures, as if they were contained in cells in the cube; cells are defined for every possible summarized value. A cell, in the cube, is defined by the intersection of dimension members and contains the aggregated values of the measures at that specific intersection.
Reference: Cubes in Multidimensional Models
Question: 323
Measured Skill: Describe an analytics workload on Azure (25–30%)
Select the answer that correctly completes the sentence.
| A | Azure Databricks combines a scalable, high-performance Microsoft SQL Server-based relational data warehouse with the flexibility of a data lake and open-source Apache Spark. |
| B | Azure HDInsight combines a scalable, high-performance Microsoft SQL Server-based relational data warehouse with the flexibility of a data lake and open-source Apache Spark. |
| C | Azure Stream Analytics combines a scalable, high-performance Microsoft SQL Server-based relational data warehouse with the flexibility of a data lake and open-source Apache Spark. |
| D | Azure Synapse Analytics combines a scalable, high-performance Microsoft SQL Server-based relational data warehouse with the flexibility of a data lake and open-source Apache Spark. |
Correct answer: DExplanation:
Azure Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Data Explorer for log and time series analytics, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.
Reference: What is Azure Synapse Analytics?
Question: 324
Measured Skill: Describe an analytics workload on Azure (25–30%)
Select the answer that correctly completes the sentence.
| A | The workflow for creating an analytics solution in Microsoft Power BI starts with Power BI Desktop. |
| B | The workflow for creating an analytics solution in Microsoft Power BI starts with the Power BI phone app. |
| C | The workflow for creating an analytics solution in Microsoft Power BI starts with the Power BI service. |
Correct answer: AExplanation:
The typical Power BI analytics workflow starts in Power BI Desktop, where you connect to data sources, transform and model the data, and create reports and visuals. After that, you publish the report to the Power BI service for sharing and collaboration.
The Power BI phone app is used only for consuming reports, not creating them.
Reference: What is Power BI