DP-900 practice questions 151–160

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

   

   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

   NNY The default access tier for a new general-purpose v2 storage account is set to the hot tier by default. An append blob is composed of blocks and is optimized for append operations. When you modify an append blob, blocks are added to the end of the blob only, via the Append Block operation. Updating or deleting of existing blocks is not supported. Rehydrating a blob from the Archive tier can take several hours to complete.

   Source: Adapted from community discussion — Bartin8tor

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 152 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   The Azure Cosmos DB API for NoSQL supports querying documents using SQL. This article provides a sample document and two sample SQL queries and results / found in Microsoft tutorial

   Source: Adapted from community discussion — NuriaIzard

   References

   • Microsoft Learn

   

   Next question

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

   

   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

   Yes. Azure File Storage can be created in a storage account in Azure. No. The Premium tier of Azure File Storage uses SSD-based hardware in a datacenter, not HDD-based. No. The Standard tier of Azure File Storage also uses HDD-based hardware in a datacenter, not SSD-based. However, it is worth noting that both tiers of Azure File Storage offer a combination of SSDs and HDDs to optimize performance and cost.

   Source: Adapted from community discussion — tangerine141

   

   Next question

4. Question 154 · 291 in bank

   DRAG DROP - Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload 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: Batch - Batch processing refers to the processing of blocks of data that have already been stored over a period of time. Box 2: Streaming - Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results. Box 3: Batch - Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing

   

   Next question

5. Question 155 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   Yes, Power BI Desktop is correct Desktop is a complete data analysis and report creation tool that is used to connect to, transform, visualize, and analyze your data. It includes the Query Editor, in which you can connect to many different sources of data, and combine them (often called modeling) into a data model. Then you design a report based on that data model.

   Source: Adapted from community discussion — Pranava_GCP

   References

   • Microsoft Learn

   

   Next question

6. Question 156 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   Power BI service is correct answer : Reports can be shared with others directly or by publishing to the Power BI service. Sharing reports requires a Power BI Pro license.

   Source: Adapted from community discussion — Pranava_GCP

   References

   • Microsoft Learn

   

   Next question

7. Question 157 · 291 in bank

   Which type of Azure resource supports the serverless configuration of an Azure SQL database?

   • ASQL Server on Azure Virtual Machines
   • Ban Azure SQL Database elastic pool
   • Ca single database in Azure SQL Database
   • DAzure SQL Managed Instance

   Show answer

   Answer: C

   Explanation

   Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.

   Source: Adapted from community discussion — Pranava_GCP

   References

   • Microsoft Learn

   Next question

8. Question 158 · 291 in bank

   HOTSPOT - Select the answer that correctly completes the sentence.

   

   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

   Online analytical processing (OLAP) systems are particularly suitable for analytical workloads because data is: pre-aggregated. OLAP systems are designed to handle complex analytical queries and provide fast query response times. They achieve this by pre-aggregating data, meaning that calculations and aggregations are performed in advance and stored in a way that allows for efficient retrieval. This pre-aggregation reduces the need for complex calculations at query time and significantly improves the performance of analytical queries.

   Source: Adapted from community discussion — fiksarion

   

   Next question

9. Question 159 · 291 in bank

   DRAG DROP - Match the data processing languages to the appropriate real-time analytics services. To answer, drag the appropriate language from the column on the left to its service on the right. Each language 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 Data Explorer: KQL (Kusto Query Language), which is a proprietary query language specifically designed for Azure Data Explorer. It is used to analyze and query large volumes of structured and unstructured data in real-time. Azure Stream Analytics: SQL, which is a standard query language for relational databases. It is used to analyze and process high-velocity, real-time streaming data from various sources, such as IoT devices, social media platforms, and other real-time data streams. Azure Synapse Analytics: SQL and Python. SQL is used to query and analyze structured data stored in Azure Synapse Analytics, while Python can be used for data preprocessing, machine learning, and other data science tasks.

   Source: Adapted from community discussion — tangerine141

   

   Next question

10. Question 160 · 291 in bank

    What is a difference between structured data and semi-structured data?

    • AStructured data has a fixed schema and semi-structured data has a flexible schema.
    • BOnly Structured data supports entities.
    • CStructured data has a flexible schema and semi-structured data has a fixed schema.
    • DOnly Structured data supports attributes.

    Show answer

    Answer: A

    Explanation

    Whereas structured data requires a fixed schema defined in advance, semi-structured data does not require a prior schema definition. For this reason, it can constantly evolve—new attributes can be added at any time. So therefore A is correct answer.

    Source: Adapted from community discussion — erwin_t82

    Next question

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

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