DP-900 practice questions 221–230

1. Question 221 · 291 in bank

   Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

   • AAzure Table storage
   • BAzure Data Lake Storage
   • CAzure Queue storage
   • DAzure Files

   Show answer

   Answer: B

   Explanation

   B answer is correct - Azure Data Lake Storage. Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs). https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

   Source: Adapted from community discussion — erwin_t82

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 222 · 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

   I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: a tabular form of rows and columns

   Source: Adapted from community discussion — mamahani

   

   Next question

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

   When to use batch processing. You might expect latencies when using batch processing. For many situations, however, this type of delay before the transfer of data begins is not a big issue - the processes that use this function are not mission critical at the exact moment. Reference: https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/

   Source: Adapted from community discussion — dataalex

   References

   • Microsoft Learn

   

   Next question

4. Question 224 · 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/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15

   Source: Adapted from community discussion — man5484

   

   Next question

5. Question 225 · 291 in bank

   DRAG DROP - Match the types of analytics that can be used to answer the business questions. To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics 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:

   Explanation

   Box 1: Diagnostic - Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships. Box 2: Prescriptive - Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes. Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome Box 3: Cognitive - Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

   Source: Adapted from community discussion — szl0144

   Next question

6. Question 226 · 291 in bank

   Which type of database is Azure Database for PostgreSQL?

   • APlatform as a service (PaaS)
   • BInfrastructure as a service (IaaS)
   • CMicrosoft SQL Server
   • Don-premises

   Show answer

   Answer: A

   Explanation

   Azure Database for PostgreSQL is falls under the category of Database as a Service (DBaaS) or Platform as a Service (PaaS).

   Source: Adapted from community discussion — ravinperera

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

7. Question 227 · 291 in bank

   Which storage solution supports access control lists (ACLs) at the file and folder level?

   • AAzure Data Lake Storage
   • BAzure Queue storage
   • CAzure Blob storage
   • DAzure Cosmos DB

   Show answer

   Answer: A

   Explanation

   This is a trick question as both Azure Blob Storage & Azure Data Lake support ACL's at the file and directory level leveraging Security principal (user, group, service principal, or managed identity). Additionally, Azure Data Lake storage system is based on Azure Blob Storage system. However Azure Data Lake Gen2, implements ACL differently in comparison to Azure Blob Storage, with the former supporting Azure RBAC & POSIX ACL's. Azure Blob Storage implements access control using SAS and AAD authentication. So in my opinion, both A & C are correct.

   Source: Adapted from community discussion — srgopalkr

   References

   • Microsoft Learn

   Next question

8. Question 228 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence. 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

   A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy. Reference: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15

   

   Next question

9. Question 229 · 291 in bank

   What is a characteristic of batch processing?

   • AThe data ingested during batch processing must be processed as soon as the data is received.
   • BLarge datasets must be split into batches of less than 1 GB before the data can be processed.
   • CThere is a noticeable time delay between ingesting data and obtaining the data processing results.
   • DBatch processing can only process data that is structured.

   Show answer

   Answer: C

   Explanation

   I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: there is a noticeable time delay between ingesting data and obtaining the data processing results

   Source: Adapted from community discussion — mamahani

   References

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

   Next question

10. Question 230 · 291 in bank

    HOTSPOT - Select the answer that correctly completes the sentence. 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

    An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions: ✑ APPROX_COUNT_DISTINCT ✑ AVG ✑ CHECKSUM_AGG ✑ COUNT ✑ COUNT_BIG GROUPING - ✑ GROUPING_ID ✑ MAX ✑ MIN ✑ STDEV ✑ STDEVP ✑ STRING_AGG ✑ SUM ✑ VAR ✑ VARP Reference: https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15

    

    Next question

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

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