DP-900 practice questions 51–60

1. Question 51 · 291 in bank

   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. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Data movement - Box 2: Data transformation - A pipeline could contain a set of activities that ingest and clean log data, and then kick off a mapping data flow to analyze the log data. Box 3: Control - Lookup Activity is a control flow activity. Lookup Activity can be used to read or look up a record/ table name/ value from any external source. This output can further be referenced by succeeding activities. Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities

   Source: Adapted from community discussion — OrangeSG

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 52 · 291 in bank

   Select 3

   What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Adenormalized data
   • Bheavy writes and moderate reads
   • Clight writes and heavy reads
   • Dschema on write
   • Eschema on read
   • Fnormalized data

   Show answer

   Answer: BDF

   Explanation

   B: Transactional data tends to be heavy writes, moderate reads. D: Typical traits of transactional data include: schema on write, strongly enforced What is Schema On Write Schema on write is defined as creating a schema for data before writing into the database. If you have done any kind of development with a database you understand the structured nature of Relational Database(RDBMS) because you have used Structured Query Language (SQL) to read data from the database. F: Transactional data tends to be highly normalized. Reference Online transaction processing (OLTP) https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

   Source: Adapted from community discussion — OrangeSG

   References

   • Microsoft Learn

   Next question

3. Question 53 · 291 in bank

   Select 2

   Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Areport and dashboard creation
   • Breport sharing and distribution
   • Cdata modeling
   • Ddata acquisition and preparation

   Show answer

   Answer: AB

   Explanation

   A, B, Sharing is only done in Power BI Service. You cannot create a Dashboard in Power BI Desktop as it's created from already existing Reports.

   Source: Adapted from community discussion — VojtechSima

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 54 · 291 in bank

   HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Reference: https://docs.microsoft.com/en-us/azure/data-factory/frequently-asked-questions

   Source: Adapted from community discussion — balan

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 55 · 291 in bank

   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?

   • Aa view
   • Ba report
   • Ca dataflow
   • DMicrosoft Power Apps

   Show answer

   Answer: B

   Explanation

   Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

   References

   • Microsoft Learn

   Next question

6. Question 56 · 291 in bank

   DRAG DROP - Match the types of visualizations to the appropriate descriptions. To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Tree map - Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles. Box 2: Key influencer - A key influencer chart displays the major contributors to a selected result or value. Box 3: Scatter - Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.

   Source: Adapted from community discussion — Crazy_Angel

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

7. Question 57 · 291 in bank

   Select 2

   Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AAzure Time Series Insights
   • BAzure HDInsight
   • CAzure Databricks
   • DAzure Log Analytics

   Show answer

   Answer: BC

   Explanation

   I took the exam 12.04.2023; this question appeared, i had to choose three Azure services on the answer list there was additionally Azure Synaps Analytics correct answers: Azure Synaps Analytics Azure HDInsight Azure Databricks

   Source: Adapted from community discussion — mamahani

   References

   • Microsoft Learn

   Next question

8. Question 58 · 291 in bank

   You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

   • AOnline Transaction Processing (OLTP)
   • Bbatch processing
   • COnline Analytical Processing (OLAP)
   • Dstream processing

   Show answer

   Answer: C

   Explanation

   Quality assurance application focuses on improving the software development process and making it efficient and effective as per quality standards. OLAP applies complex queries to large amounts of historical data, aggregated from OLTP databases and other sources, for data mining, analytics, and business intelligence projects. Moreover, the purpose of OLAP ----> Plan, solve problems, support decisions, discover hidden insights. According to the question, the application is reading data from the data warehouse for quality assurance which is clearly - discovering insights from the data. Thus, the answer is OLAP.

   Source: Adapted from community discussion — rajat7878

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

9. Question 59 · 291 in bank

   Select 3

   Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Aa report page
   • Ba Microsoft PowerPoint slide
   • Ca visualization from a report
   • Da dataflow
   • Ea text box

   Show answer

   Answer: ACE

   Explanation

   I took the exam 12.04.2023; this question appeared,correct answer a report page / a visualization from a report / a text box

   Source: Adapted from community discussion — mamahani

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

10. Question 60 · 291 in bank

    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. Hot Area:

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer: See figure below

    Explanation

    Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboardshttps://powerbi.microsoft.com/en-us/excel-and-power-bi/

    Source: Adapted from community discussion — Mjwc

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-900 practice, question 51. 291 questions available.