2022年02月 Microsoft DP-900実際の問題とブレーン問題集
DP-900合格させる問題集でMicrosoft24時間で試験合格できます
Microsoft DP-900 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
質問 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.
正解:
解説:
Explanation
Box 1: No
A pipeline is a logical grouping of activities that together perform a task.
Box 2: Yes
You can construct pipeline hierarchies with data factory.
Box 3: Yes
A pipeline is a logical grouping of activities that together perform a task.
質問 40
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. item
- B. container
- C. partition
- D. database
正解: A,C
質問 41
Which three actions are used when performing diagnostic analytics?
- A. * Apply serf-learning loops to draw inferences from anomalies.
* Predict when anomalies are likely to recur
* Use analytical tools such as decision trees and regression. - B. * Identify data anomalies
* Predict when anomalies are likely to recur
* Use analytical tools such as decision trees and regression. - C. * Identify data anomalies
* Collect anomaly-related data
* Discover relationships and trends that explain anomalies.
正解: C
解説:
D.
* Identify data anomalies
* Use machine learning to find patterns in large datasets.
* Discover relationships and trends that explain anomalies.
質問 42
For each of the following statements, select yes if the statement is true, Otherwise, select No.
Note: Each correct selection is worth one point.
正解:
解説:
質問 43
What should you use to build a Microsoft Power BI paginated report?
- A. Charticulator
- B. Power BI Desktop
- C. Power BI Report Builder
- D. the Power BI service
正解: C
解説:
Section: Describe an analytics workload on Azure
Explanation:
Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
Reference:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi
質問 44
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/azure/cosmos-db/high-availability
質問 45
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
質問 46
Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all.
NOTE: Each correct match is worth one point.
正解:
解説:
質問 47
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.
正解:
解説:
質問 48
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
正解:
解説:
質問 49
To complete the sentence, select the appropriate option in the answer area.
正解:
解説:
質問 50
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
- A. built-in high availability
- B. support for encryption at rest
- C. system-Initiated automatic backups
- D. native support for cross-database queries and transactions
正解: A
質問 51
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type 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/data-factory/concepts-pipelines-activities#data-transformation-activities
質問 52
To complete the sentence, select the appropriate option in the answer area.
正解:
解説:
質問 53
To complete the sentence, select the appropriate option in the answer area.
正解:
解説:
Reference:
https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/
質問 54
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.) NOTE: Each correct selection is worth one point.
- A. You must have SELECT access to the Products table.
- B. You must be assigned the Contributor role for the resource group that contains the database.
- C. You must have a user in the database.
- D. You must be assigned the Reader role for the resource group that contains the database.
- E. Your IP address must be allowed to connect to the database.
正解: A,C,E
解説:
Section: Describe how to work with relational data on Azure
Explanation:
Incorrect Answers:
A, D: Resource group permissions is not required to query an Azure SQL database table.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with- database-engine-permissions?view=sql-server-ver15
質問 55
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. Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
正解:
解説:
質問 56
To complete the sentence, select the appropriate option in the answer area.
正解:
解説:
質問 57
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?
- A. Microsoft SQL Server Management Studio (SSMS)
- B. sq1cmd
- C. Azure Data Studio
- D. Azure Data Explorer
正解: C
質問 58
Which Azure Data Factory component initiates the execution of a pipeline?
- A. a trigger
- B. a control flow
- C. an activity
- D. a parameter
正解: A
解説:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution
質問 59
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?
- A. Azure Active Directory (Azure AD) authentication
- B. certificate authentication
- C. SQL authentication
- D. service principal authentication
正解: A
解説:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview
質問 60
......
最新問題をダウンロードDP-900問題集で2022年最新のDP-900試験問題集：https://www.goshiken.com/Microsoft/DP-900-mondaishu.html
最新問題を使おうDP-900試験問題と解答PDFで一年間無料更新：https://drive.google.com/open?id=188uzNHXin4AVolvcpBRjvAy_vjWOTQ3w