Free DP-900 Exam Practice Questions
Practice for DP-900: Microsoft Azure Data Fundamentals exam - disclaimer
-
Exam Code: DP-900
Exam Title: Microsoft Azure Data Fundamentals - Exam Provider: Microsoft
- Total Exam Questions: 123
- Last Updated On: 27 May 2024
Exercise : Exam DP 900 Microsoft Azure Data Fundamentals MCQ Questions and Answers
Question 1
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:
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. No, Yes, Yes
Description :
Reference:
https://www.sqlshack.com/what-is-database-normalization-in-sql-server/
View Answer
50/50
Workspace
Report
Discuss
Question 2
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. keys
Description :
Reference:
https://teachcomputerscience.com/relational-databases/
Question 3
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 Answer presents part of the solution. (Choose three.)
NOTE: Each correct selection is worth one point.
A. You must be assigned the Reader role for the resource group that contains the database.
B. You must have SELECT access to the Products table.
C. You must have a user in the database.
D. You must be assigned the Contributor role for the resource group that contains the database.
E. Your IP address must be allowed to connect to the database.
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. BCE
Description :
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-enginepermissions?view=sql-server-ver15
Question 4
You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Archive
Description :
Reference:
https://cloud.netapp.com/blog/azure-blob-storage-pricing-the-complete-guide-azure-cvo-blg#H1_4
Question 5
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. the database to protect data at rest.
Description :
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal
Question 6
DRAG DROP -
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Gremlin API, MongoDB API, Table API
Description :
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/faq
Question 7
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. strong consistency guarantees are required.
Description :
Question 8
You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict
various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. a report
Description :
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/powerbi/
visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Question 9
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.
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Data movement, Data transformation, Control
Description :
Question 10
Your company is designing a data store that will contain student data. The data has the following format.
Which type of data store should you use?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. columnar
Description :
No answer description available for this question. Let us discuss.