更新された2021年12月公式問題DP-900認定にはDP-900問題集PDF [Q14-Q31]

更新された2021年12月公式問題DP-900認定にはDP-900問題集PDF

2021年最新のに更新された最新DP-900問題集を掴み取れ！

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

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views

 

質問 15
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/

 

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

正解:

解説:

 

質問 17
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/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboardshttps://powerbi.microsoft.com/en-us/excel-and-power-bi/

 

質問 18
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

 

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

正解:

解説:

 

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

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

 

質問 21
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?

• A. Azure Functions
• B. Microsoft SQL Server Integration Services (SSIS)
• C. PolyBase
• D. Azure Data Factory

正解: C

解説:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html

 

質問 22
Match the types of workloads the appropriate scenario.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once or not at all.
NOTE: Each correct match is worth one point.

正解:

解説:

 

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

正解:

解説:

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

 

質問 24
You have a SQL query that combines customer data and order dat
a. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query. What should you create?

• A. a table
• B. scalar function
• C. a view
• D. an index

正解: C

解説:
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views

 

質問 25
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

正解:

解説:

 

質問 26
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

• A. Azure SQL Database serveless
• B. Azure SQL Database Hyperscale
• C. Azure SQL Database elastic pod
• D. Azure SQL managed instance

正解: D

 

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

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console

 

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

正解:

解説:

 

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

正解:

解説:

 

質問 30
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.

正解:

解説:

 

質問 31
......

Microsoft DP-900 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Describe Azure Database for PostgreSQL, Azure Database for MariaDB, andAzure Database for MySQL Describe types of core data workloads
トピック 2	Describe the components of a modern data warehouse Describe the characteristics of relational data
トピック 3	Identify Azure data services for non-relational workloads Describe how to work with relational data on Azure
トピック 4	Describe how to work with non-relational data on Azure Identify the right data offering for a relational workload
トピック 5	Determine when a data warehouse solution is needed Describe relational Azure data services
トピック 6	Describe the types of non-relational and NoSQL data Describe relational data structures
トピック 7	Describe the concepts of data processing Describe data analytics core concepts Describe streaming data
トピック 8	Describe and compare PaaS, IaaS, and SaaS solutions Describe ELT and ETL processing

 

最新のDP-900試験問題集でMicrosoft試験にはトレーニング：https://jp.fast2test.com/DP-900-premium-file.html

最新を提供していますDP-900問題集でMicrosoft Certified: Azure Data Fundamentals認定：https://drive.google.com/open?id=1t5UDwjBpZjkgINci2TBfjldPxDJEGNZF