DP-900 : Microsoft Azure Data Fundamentals : Part 06

DP-900 : Microsoft Azure Data Fundamentals : Part 06

1. DRAG DROP

   Match the types of activities to the appropriate Azure Data Factory activities.

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

   NOTE: Each correct match is worth one point.

   

   

2. What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

   NOTE: Each correct selection is worth one point.

   • denormalized data
   • heavy writes and moderate reads
   • light writes and heavy reads
   • schema on write
   • schema on read
   • normalized data
   Explanation:
   B: Transactional data tends to be heavy writes, moderate reads.
   D: Typical traits of transactional data include: schema on write, strongly enforced
   F: Transactional data tends to be highly normalized.

3. Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)

   NOTE: Each correct selection is worth one point.

   • report and dashboard creation
   • report sharing and distribution
   • data modeling
   • data acquisition and preparation

4. HOTSPOT

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

   

   

5. You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.

   What should you use in Microsoft Power BI?

   • a dashboard
   • a report
   • a dataflow
   • Microsoft Power Apps

6. Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

   NOTE: Each correct selection is worth one point.

   • Azure Time Series Insights
   • Azure HDInsight
   • Azure Databricks
   • Azure Log Analytics

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

   Which type of processing does the application use?

   • Online Transaction Processing (OLTP)
   • batch processing
   • Online Analytical Processing (OLAP)
   • stream processing

8. Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.)

   NOTE: Each correct selection is worth one point.

   • a report page
   • a Microsoft PowerPoint slide
   • a visualization from a report
   • a dataflow
   • a text box

9. HOTSPOT

   For each of the following statements, select Yes if the statement is true. Otherwise, select No.

   NOTE: Each correct selection is worth one point.

   

   

10. Which Azure Data Factory component provides the compute environment for activities?

    • a linked service
    • an integration runtime
    • a control flow
    • a pipeline
    Explanation:
    The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:
    – Data Flow
    – Data movement
    – Activity dispatch
    – SSIS package execution

11. HOTSPOT

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

    

    

    Explanation:

    Paginated Reports in Power BI now allows users to generate these fixed-layout documents optimized for printing and archiving, such as PDF and Word files.
    These document-style reports with visualizations that provide additional control, like which tables expand horizontally and vertically to display all their data and continue from page to page as needed.

12. What are two uses of data visualization? Each correct answer presents a complete solution.

    NOTE: Each correct selection is worth one point.

    • Represent trends and patterns over time
    • Implement machine learning to predict future values
    • Communicate the significance of data
    • Consistently implement business logic across reports
    Explanation:
    Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data.
    Data visualization brings data to help you find key business insights quickly and effectively.

13. You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

    What should you use to query the files?

    • Azure Functions
    • Microsoft SQL Server Integration Services (SSIS)
    • PolyBase
    • Azure Data Factory