[2023年12月30日] 完全版最新のDP-900問題集で100%カバー率問題と解答があなたをリアル試験で合格させる [Q101-Q118]

[2023年12月30日] 完全版最新のDP-900問題集で100%カバー率問題と解答があなたをリアル試験で合格させる

最新DP-900試験問題集で有効最新の問題集

Microsoft DP-900認定試験は、コアデータの概念、リレーショナルおよび非関連データ、データストレージオプション、データ処理と変換、Azureデータサービスなど、データ分析とデータベース管理に関連するさまざまなトピックを対象としています。候補者は、これらの概念とテクノロジー、およびAzure Data Servicesでの実践的な経験を基本的に理解することが期待されています。

質問 # 101
You have the following SQL query.

NOTE: Each correct selection is worth one point.

正解：

解説：

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

正解：

解説：

Reference:
https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/

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

正解：

解説：

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

正解：

解説：

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

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

正解：

解説：

Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

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

正解：

解説：

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

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

正解：

解説：

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

正解：

解説：

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

正解：

解説：

質問 # 110
You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?

A. You need to audit the transactional application.
B. You need to generate reports without affecting the transactional workload.
C. You need to implement high availability in the event of a regional outage.
D. You need to improve the recovery point objective (RPO).

正解：C

解説：
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries- readable-secondary-replicas-always-on-availability-groups?view=sql-server-ver15

質問 # 111
You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?

A. table
B. blob
C. file
D. queue

正解：B

解説：
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-files

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

正解：

解説：

質問 # 113
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

A. Azure Data Studio
B. Azure PowerShell
C. Microsoft SQL Server Management Studio (SSMS)
D. Azure CLI

正解：A

解説：
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/

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

正解：

解説：

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

正解：

解説：
See the answer in explanation below.
Answer below as:

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

正解：

解説：
Answer as below.

質問 # 117
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
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No