DP-900 practice questions 71–80

1. Question 71 · 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

   Box 1: No - A pipeline is a logical grouping of activities that together perform a task. Box 2: Yes - You can construct pipeline hierarchies with data factory. Box 3: Yes - A pipeline is a logical grouping of activities that together perform a task. Reference: https://mrpaulandrew.com/2019/09/25/azure-data-factory-pipeline-hierarchies-generation-control/

   Source: Adapted from community discussion — Yomzie

   

   Next question

2. Question 72 · 291 in bank

   DRAG DROP - Match the Azure services to the appropriate requirements. To answer, drag the appropriate service from the column on the left to its requirement on the right. Each service 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: Azure Data Factory - Box 2: Azure Data Lake Storage - Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the native extractor and outputter for the popular Parquet file format Box 3: Azure Synapse Analytics - Use Azure Synapse Analytics Workspaces. Reference: https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs

   Source: Adapted from community discussion — FabianW

   

   Next question

3. Question 73 · 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

   Box 1: Yes - Compute is separate from storage, which enables you to scale compute independently of the data in your system. Box 2: Yes - You can use the Azure portal to pause and resume the dedicated SQL pool compute resources. Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute during that hour. Box 3: No - Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs. Reference: https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/

   Source: Adapted from community discussion — EstbanFTP

   

   Next question

4. Question 74 · 291 in bank

   What should you use to build a Microsoft Power BI paginated report?

   • ACharticulator
   • BPower BI Desktop
   • Cthe Power BI service
   • DPower BI Report Builder

   Show answer

   Answer: D

   Explanation

   Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service. Reference: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

   References

   • Microsoft Learn

   Next question

5. Question 75 · 291 in bank

   DRAG DROP - Match the Azure services to the appropriate locations in the architecture. To answer, drag the appropriate service from the column on the left to its location on the right. Each service 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: Azure Data factory - Relevant Azure service for the three ETL phases are Azure Data Factory and SQL Server Integration Services (SSIS). Box 2: Azure Synapse Analytics - You can copy and transform data in Azure Synapse Analytics by using Azure Data Factory Note: Azure Synapse Analytics connector is supported for the following activities: ✑ Copy activity with supported source/sink matrix table ✑ Mapping data flow ✑ Lookup activity ✑ GetMetadata activity Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse

   Source: Adapted from community discussion — [Removed]

   

   Next question

6. Question 76 · 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/azure/databricks/scenarios/what-is-azure-databricks https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview https://docs.microsoft.com/en-us/azure/data-factory/introduction

   

   Next question

7. Question 77 · 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

   Box 1: Yes - Like IaaS, PaaS includes infrastructure ג€" servers, storage, and networking ג€" but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating. PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: No - You manage the applications and services you develop, and the cloud service provider typically manages everything else. Box 3: No - There really is no way to pause / stop billing for your Azure SQL Database. Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB." Reference: https://azure.microsoft.com/en-us/overview/what-is-paas

   Source: Adapted from community discussion — FunMiles

   References

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

   

   Next question

8. Question 78 · 291 in bank

   Which scenario is an example of a streaming workload?

   • Asending transactions that are older than a month to an archive
   • Bsending transactions daily from point of sale (POS) devices
   • Csending telemetry data from edge devices
   • Dsending cloud infrastructure metadata every 30 minutes

   Show answer

   Answer: C

   Explanation

   C. sending telemetry data from edge devices A streaming workload typically involves the continuous and real-time ingestion and processing of data as it is generated. In the given scenario, sending telemetry data from edge devices involves the continuous flow of data from these devices to a central system for immediate analysis and processing. This aligns with the characteristics of a streaming workload where data is ingested in real-time and processed as it arrives.

   Source: Adapted from community discussion — fiksarion

   References

   • Microsoft Learn

   Next question

9. Question 79 · 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

   Don't get tricked with this one: A) doesn't make any sense as there is no data processing in the background. Batch means to process a big volume of data in a particular time of the day (e.g. in the night with idle VMs) B) You can once per day if you define it as such but in any case you are limited by "one day". So it's no. C) Nonsense. Batch data is not a design for RT/streaming data OTA. You would use a different solution as data bricks. Reason that data bricks service exists. D) Correct. You can define your condition. Once it's met, you can execute it.

   Source: Adapted from community discussion — AlfuryDB

   

   Next question

10. Question 80 · 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

    Option C says it sends the "readingS" once a day, which makes me think it has multiple readings and wait to send them all once a day. So with given information I'm more inclined to Yes, Yes, No.

    Source: Adapted from community discussion — KAYSERSOZE

    

    Next question

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

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