2026年最新のMicrosoft DP-900リアル試験問題集PDF [Q183-Q205]

2026年最新ののMicrosoft DP-900リアル試験問題集PDF

DP-900試験問題集、DP-900練習テスト問題

質問 # 183
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE:Each correct selection is worth one point.

正解：

解説：

質問 # 184
Select the answer that correctly completes the sentence.

正解：

解説：

質問 # 185
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy
https://manojchoudhari.wordpress.com/2019/12/16/azure-cosmos-db-enable-multi-region-writes

質問 # 186
Select the answer that correctly completes the sentence.For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

正解：

解説：

質問 # 187
You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point

正解：

解説：

Reference:
https://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

質問 # 188
Hotspot Question
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

質問 # 189
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

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

質問 # 190
Which Azure Data Factory component provides the compute environment for activities?

A. a pipeline
B. a linked service
C. a control flow
D. an integration runtime

正解：D

解説：
Explanation
The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the
following data integration capabilities across different network environments:
* Data Flow
* Data movement
* Activity dispatch
* SSIS package execution

質問 # 191
match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解：

解説：

Reference:
https://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/
https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

質問 # 192
Select the answer that correctly completes the sentence.

正解：

解説：

質問 # 193
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for- database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure

質問 # 194
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.

A. partition
B. item
C. container
D. database

正解：C、D

質問 # 195
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

質問 # 196
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

質問 # 197
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

正解：

解説：

Explanation:

Box 1: Yes
Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually these jobs involve reading source files from scalable storage (like HDFS, Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files in scalable storage.
Box 2: No
Box 3: No
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

質問 # 198
Which Azure Data Factory component provides the compute environment for activities?

A. a pipeline
B. an integration runtime
C. a control flow
D. a linked service

正解：D

解説：
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-compute-linked-services

質問 # 199
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

Explanation:

Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.

質問 # 200
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解：

解説：

質問 # 201
Select the answer that correctly completes the sentence.

正解：

解説：

質問 # 202
To complete the sentence, select the appropriate option in the answer area.

正解：

解説：

質問 # 203
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.