DP-900 practice questions 171–180

1. Question 171 · 291 in bank

   DRAG DROP - Match the cloud service model to the appropriate Azure relational database service. To answer, drag the appropriate cloud service model from the column on the left to its service on the right. Each model may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

   

   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

   Azure SQL Database - Platform as a Service (PaaS) Azure SQL Managed Instance - Platform as a Service (PaaS) SQL Server on Azure Virtual Machines - Infrastructure as a Service (IaaS)

   Source: Adapted from community discussion — MakkerHeineken

   References

   • Microsoft Learn

   

   Next question

2. Question 172 · 291 in bank

   Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit.

   

   Which type of analysis is shown in the fourth quarter?

   • Apredictive
   • Bprescriptive
   • Cdescriptive
   • Ddiagnostic

   Show answer

   Answer: A

   Explanation

   The answer is ambiguous, could be DESCRIPTIVE because i do not watch what is future or present or past in the chart. If I assume that all is present or all already happened, the answer would be DESCRIPTIVE else predictive. The colour is not a good explanation.

   Source: Adapted from community discussion — xiban

   Next question

3. Question 173 · 291 in bank

   A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail. Of which ACID semantic is this an example?

   • Aconsistency
   • Bdurability
   • Catomicity
   • Disolation

   Show answer

   Answer: C

   Explanation

   Atomicity guarantees that each transaction is treated as a single "unit", which either succeeds completely or fails completely: if any of the statements constituting a transaction fails to complete, the entire transaction fails and the database is left unchanged Consistency ensures that a transaction can only bring the database from one consistent state to another, preserving database invariants: any data written to the database must be valid according to all defined rules Isolation ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially Durability guarantees that once a transaction has been committed, it will remain committed even in the case of a system failure (e.g., power outage or crash).

   Source: Adapted from community discussion — Kapello10

   Next question

4. Question 174 · 291 in bank

   Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

   • AHot to Cool
   • BHot to Archive
   • CCool to Archive
   • DArchive to Cool

   Show answer

   Answer: D

   Explanation

   While a blob is in the archive access tier, it's considered to be offline, and can't be read or modified. In order to read or modify data in an archived blob, you must first rehydrate the blob to an online tier, either the hot or cool tier.

   Source: Adapted from community discussion — Gepro

   References

   • Microsoft Learn

   Next question

5. Question 175 · 291 in bank

   Which activity is most common for transactional workloads?

   • Arecording small units of work events in real time
   • Baggregating massive amounts of data
   • Cproducing complex reports
   • Dperforming self-service data exploration

   Show answer

   Answer: A

   Next question

6. Question 176 · 291 in bank

   You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?

   • Aonline transaction processing (OLTP)
   • Bonline analytical processing (OLAP)
   • Cextract, transform and load (ETL)
   • Da data warehouse

   Show answer

   Answer: A

   Next question

7. Question 177 · 291 in bank

   DRAG DROP - Match the job roles to the appropriate tasks. To answer, drag the appropriate job role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

   

   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

   Correct Ans: 1. Data Engineer 2. Data Administrator 3. Data Analyst Notes: The job roles define differentiated tasks and responsibilities. In some organizations, the same person might perform multiple roles; so in their role as database administrator they might provision a transactional database, and then in their role as a data engineer they might create a pipeline to transfer data from the database to a data warehouse for analysis. https://learn.microsoft.com/en-us/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles

   Source: Adapted from community discussion — KumudiniChaudhari

   References

   • Microsoft Learn

   

   Next question

8. Question 178 · 291 in bank

   DRAG DROP - Match the job roles to the appropriate tasks. To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

   

   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

   

   Next question

9. Question 179 · 291 in bank

   You need to accept and store large quantities of IoT streaming data. Which database solution should you use?

   • AAzure Database for PostgreSQL
   • BAzure Database for MariaDB
   • CAzure Cache for Redis
   • DAzure Cosmos DB

   Show answer

   Answer: D

   Next question

10. Question 180 · 291 in bank

    DRAG DROP - Match the job roles to the appropriate tasks. To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

    

    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

    

    Next question

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

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