今すぐDP-900問題を使おうDP-900問題集PDF [Q58-Q75]

Share

今すぐDP-900問題を使おうDP-900問題集PDF

問題集練習試験問題学習ガイドはDP-900試験合格させます


Microsoft DP-900試験を受けるための厳格な前提条件はありませんが、データの取り扱いに関する基本的な知識があり、Azureサービスについての経験があることが推奨されています。受験者は、試験に備えてMicrosoft LearnのAzure Data Fundamentalsコースを受講することもできます。

 

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

正解:

解説:


質問 # 59
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


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

正解:

解説:


質問 # 61
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/


質問 # 62
Which statement is an example of Data Manipulation Language (DML)?

  • A. UPDATE
  • B. CREATE
  • C. DISABLE
  • D. REVOKE

正解:A

解説:
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE


質問 # 63
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 generate reports without affecting the transactional workload.
  • B. You need to implement high availability in the event of a regional outage.
  • C. You need to improve the recovery point objective (RPO).
  • D. You need to audit the transactional application.

正解:B

解説:
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


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

正解:

解説:


質問 # 65
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right.
Eachvisualization type may be used once, more than once, or not at all.
NOTE:Each correct match is worth one point.

正解:

解説:

Explanation

Box 1: Tree map
Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.

Box 2: Key influencer
A key influencer chart displays the major contributors to a selected result or value.
Box 3: Scatter
Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.


質問 # 66
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term 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/azure/storage/files/storage-how-to-create-file-share


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

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql


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

正解:

解説:


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

正解:

解説:

Reference:
https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql


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

正解:

解説:
Explanation
Text Description automatically generated with low confidence

Descriptive, to answer the question: What's happening?
Company name Description automatically generated

Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords. You can process one media file or multiple media files in a batch.


質問 # 71
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解:

解説:

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


質問 # 72
Which statement is an example of Data Definition Language (DDL)?

  • A. SELECT
  • B. INSERT
  • C. DROP
  • D. DELETE

正解:C

解説:
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
* ALTER
* Collations
* CREATE
* DROP
* DISABLE TRIGGER
* ENABLE TRIGGER
* RENAME
* UPDATE STATISTICS
* TRUNCATE TABLE


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

正解:

解説:


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

正解:

解説:


質問 # 75
......

無料Microsoft Certified: Azure Data Fundamentals DP-900試験問題:https://www.goshiken.com/Microsoft/DP-900-mondaishu.html

DP-900問題集には練習試験問題解答:https://drive.google.com/open?id=1yXTAh1F3CK8A4b7HZ3XtjJb1oKNiiBgt