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?

Answer :
  • Archive