[2024年03月30日]DP-900問題集完全版問題、試験学習ガイド [Q162-Q178]

[2024年03月30日]DP-900問題集完全版問題、試験学習ガイド

Microsoft Certified: Azure Data Fundamentals無料認定試験材料Fast2testからの290問題

DP-900 試験に合格するためには、データストレージ、処理、およびセキュリティのコアコンセプトを良く理解している必要があります。また、データ管理や処理に使用される Azure サービスやツールにも精通している必要があります。試験は、複数選択肢問題から構成され、60分以内に受験することが設計されています。

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

正解：

解説：

Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

質問 # 163
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

A. denormalized data
B. light writes and heavy reads
C. schema on write
D. normalized data
E. heavy writes and moderate reads
F. schema on read

正解：C、D、E

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

質問 # 164
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:

正解：

解説：

Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview
https://docs.microsoft.com/en-us/azure/data-factory/introduction

質問 # 165
When can you use an Azure Resource Manager template?

A. to automate the creation of an interdependent group of Azure resources in a repeatable way
B. To set complex permissions automatically on existing objects in an Azure subscription
C. To provision Azure subscriptions and apply policies for multi-tenant deployments
D. to automate the creation of an interdependent and develop can deploy from the Azure portal

正解：A

解説：
Explanation
You can automate deployments and use the practice of infrastructure as code. In code, you define the
infrastructure that needs to be deployed
To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM
templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and
configuration for your project. The template uses declarative syntax, which lets you state what you intend to
deploy without having to write the sequence of programming commands to create it. In the template, you
specify the resources to deploy and the properties for those resources.

質問 # 166
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

正解：

解説：

Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/

質問 # 167
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. access to the latest features
B. in-database machine learning services
C. reduced administrative effort for managing the server infrastructure
D. complete control over backup and restore processes

正解：A、B

解説：
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

質問 # 168
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?

A. Key/value
B. columnar
C. Document
D. Graph

正解：D

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

正解：

解説：

Explanation
Table Description automatically generated

A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.

質問 # 170
To complement the sentence, select the appropriate option in the answer area.

正解：

解説：

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

正解：

解説：

質問 # 172
Which Azure SQL offering provides near-IOO percentcompatibility with on-premises Microsoft SQL Server instances, while providing automated updates, backups, and maintenance tasks?

A. Azure SQL Managed Instance
B. Azure SQL Edge
C. Azure SQLDatabase
D. SQL Server on Azure Virtual Machines

正解：A

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

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-cosmosdb-resources-portal

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

正解：

解説：

質問 # 175
You have the following JSON document.

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

正解：

解説：

Reference:
https://www.w3schools.com/js/js_json_arrays.asp
https://www.w3schools.com/js/js_json_objects.asp

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

正解：

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

質問 # 177
You have the following JSON document.

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