Microsoft DP900 Exam Dumps|QAs Page -6

/ Microsoft Certification / Certification Exam, DP900, Exam Dumps, Microsoft

Last updated on October 25th, 2024 at 09:44 pm

Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.

Microsoft DP900 Exam Dumps

Microsoft DP900 Exam Dumps – QAs 126-150

Q126. 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:

dp_900 question 126
Correct Answer
dp_900 answer 126

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview

Q127. You need to recommend a data store service that meets the following requirements:
✑ Native SQL API access
✑ Configurable indexes
What should you recommend?

  1. Azure Files
  2. Azure Blob storage
  3. Azure Table storage
  4. Azure Cosmos DB
Correct Answer

4. Azure Cosmos DB

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy

Q128. DRAG DROP –
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description 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:

dp_900 question 128
Correct Answer
dp_900 answer 128

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-working-with-json

Q129. You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

  1. Azure Files
  2. Azure Blob storage
  3. Azure Cosmos DB
  4. Azure Table storage
Correct Answer

1. Azure Files

Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows

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

dp_900 question 130
Correct Answer
dp_900 answer 130

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

Q131. 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:

dp_900 question 131
Correct Answer
dp_900 answer 131

Reference:
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview
https://azure.microsoft.com/en-us/pricing/details/bandwidth/

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

dp_900 question 132
Correct Answer
dp_900 answer 132

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15

Q133. You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.
What should you do on the dedicated SQL pool?

  1. Scale down the data warehouse units (DWUs).
  2. Pause the pool.
  3. Create a user-defined restore point.
  4. Delete the pool
Correct Answer

2. Pause the pool.

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview

Q134. You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?

  1. key/value
  2. columnar
  3. object
  4. document
Correct Answer

3. object

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q135. Which Azure Data Factory component initiates the execution of a pipeline?

  1. a control flow
  2. a trigger
  3. a parameter
  4. an activity
Correct Answer

2. a trigger

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution

Q136. 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.

  1. denormalized data
  2. heavy writes and moderate reads
  3. light writes and heavy reads
  4. schema on write
  5. schema on read
  6. normalized data
Correct Answer

2. heavy writes and moderate reads
4. schema on write
6. normalized data

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

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

dp_900 question 137
Correct Answer
dp_900 answer 137

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

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

dp_900 question 138
Correct Answer
dp_900 answer 138
  1. relational
  2. time series
  3. graph
  4. columnar
Correct Answer

2. time series

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q140. 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.

  1. Azure Time Series Insights
  2. Azure HDInsight
  3. Azure Databricks
  4. Azure Log Analytics
Correct Answer

2. Azure HDInsight
3. Azure Databricks

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

  1. Online Transaction Processing (OLTP)
  2. batch processing
  3. Online Analytical Processing (OLAP)
  4. stream processing
Correct Answer

1. Online Transaction Processing (OLTP)

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

Q142. 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:

dp900_question 142
Correct Answer
dp900_answer 142

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

Q143. Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

  1. columnar
  2. key/value
  3. document
  4. graph
Correct Answer

2. key/value

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q144. At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  1. database
  2. item
  3. container
  4. partition
Correct Answer

1. database
3. container

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput

Q145. What is a characteristic of non-relational data?

  1. no indexes
  2. self-describing entities
  3. a well-defined schema
  4. no unique key values
Correct Answer

4. no unique key values

Q146. You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?

  1. Online Transaction Processing (OLTP)
  2. batch
  3. massively parallel processing (MPP)
  4. streaming
Correct Answer

4. streaming

Reference:
https://docs.microsoft.com/en-in/azure/azure-monitor/overview

Q147. 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?

  1. a view
  2. a report
  3. a dataflow
  4. Microsoft Power Apps
Correct Answer

2. a report

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

Q148. Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?

  1. stream processing
  2. batch processing
  3. Online Analytical Processing (OLAP)
  4. Online Transaction Processing (OLTP)
Correct Answer

3. Online Analytical Processing (OLAP)

Q149. 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.

  1. report and dashboard creation
  2. report sharing and distribution
  3. data modeling
  4. data acquisition and preparation
Correct Answer

1. report and dashboard creation
4. data acquisition and preparation

Q150. 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:

dp900_question 150
Correct Answer
dp900_answer 150

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities

Related Posts

Scroll to Top