検証済み！DP-900問題集と解答でDP-900テストエンジン正確解答付き [Q31-Q53]

検証済み！DP-900問題集と解答でDP-900テストエンジン正確解答付き

あなたを必ず合格させるDP-900問題集PDF2025年最新のに更新された300問あります

Microsoft DP-900試験は、Azure Cloudプラットフォームのデータ管理とデータ分析の分野における候補者の基本的な知識をテストするように設計されています。この試験は、データサイエンスやクラウドコンピューティングのキャリアを追求することに興味がある個人と、すでにこれらの分野で働いているが、知識とスキルを検証したい人を対象としています。 Microsoft DP-900試験では、クラウドコンピューティングの基本概念、Azureのデータストレージオプション、基礎データ分析の概念などのトピックをカバーしています。

Microsoft DP-900試験は、40-60の複数選択の質問で構成されており、候補者は試験を完了するために60分を持っています。試験はオンラインで撮影することができ、候補者は都合の良いときにテストをスケジュールすることができます。試験料は99ドルで、候補者は最初の試みに慣れていない場合は試験を再試行できます。

DP-900試験では、コアデータの概念、リレーショナルおよび非関連データサービス、Azureデータストレージオプション、Azureデータ処理ソリューション、Azureデータ分析オプションなど、幅広いトピックをカバーしています。この試験は、Azure Data Servicesの基礎能力に関する知識をテストするように設計されています。これは、将来の高度な認定に不可欠です。

質問 # 31
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?

A. az cosmosdb creace
B. az scorage share create
C. az scorage concainer creace
D. az scorage account creace

正解：C

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

正解：

解説：

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

正解：

解説：

質問 # 34
When you create an Azure SQL database, which account can always connect to the database ?

A. the sa account
B. the server admin login account of the logical server
C. the Azure Active director/ (Azure AO) account that created the database
D. the Azure Active Directly Azure AD) administrator account

正解：B

解説：
Explanation
When you first deploy Azure SQL, you specify an admin login and an associated password for that login.
This administrative account is called Server admin.

質問 # 35
Hotspot Question
Select the answer that correctly completes the sentence.

正解：

解説：

Explanation:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files

質問 # 36
Hotspot Question
Select the answer that correctly completes the sentence.

正解：

解説：

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

質問 # 37
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
Graphical user interface, text, application, email Description automatically generated

質問 # 38
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
Text Description automatically generated

Box 1: Yes
For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Box 2: No
Box 3: Yes
Box 4: Yes
Azure Cosmos DB supports multi-region writes.

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

正解：

解説：

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

正解：

解説：

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

正解：

解説：

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

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture

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

正解：

解説：

Explanation

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

正解：

解説：

Explanation

質問 # 45
Your company if 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?

A. graph
B. columnar
C. document
D. key/value

正解：B

解説：
Explanation
A key/value store associates each data value with a unique key.
An application can store arbitrary data as a set of values. Any schema information must be provided by theapplication. The key/value store simply retrieves or stores the value by key.

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

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

正解：B

解説：
Section: Describe an analytics workload on Azure
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
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

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

正解：

解説：

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

質問 # 49
Hotspot Question
Select the answer that correctly completes the sentence.

正解：

解説：

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

正解：

解説：

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

正解：

解説：

質問 # 52
Hotspot Question
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.
Incorrect Answers:
Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.
Use Cloud storage (no relational database) for geographically distributed writes.
Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77