Microsoft DP900 Exam Dumps|QAs Page -27

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

Microsoft DP900 Exam Dumps

Microsoft DP900 Exam Dumps – QAs 131-135

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

Scroll to Top