DP-900: Microsoft Azure Data Fundamentals Quiz Questions and Answers
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
Answer :
Azure SQL Database
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three)
Answer :
A report page
A visualization from a report
A text box
You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist in the SQL query so other users can use the query. What should you create?
Answer :
A view
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?
Answer :
Azure Active Directory (Azure AD) authentication
Which of the following tools is a visualization and reporting tool?
Answer :
Power BI
Which one of the following roles is not a data job role?
Answer :
Systems Administrator
What is an index?
Answer :
A structure that enables you to locate rows in a table quickly, using an indexed value
When should you use Azure Synapse Analytics?
Answer :
To perform very complex queries and aggregations
Which services can be used to ingest data into Azure Synapse Analytics?
Answer :
Azure Data Factory
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?
