DP-900T00: Microsoft Azure Data Fundamentals Quiz Questions and Answers

You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?

Answer :
  • File

Which type of analytics helps answer questions about what has happened in the past?

Answer :
  • Descriptive analytics

Which of the following is a characteristic of non-relational databases?

Answer :
  • Non-relational databases are either schema free or have relaxed schemas

Which services should you use to implement a non-relational database?

Answer :
  • Azure Cosmos DB

What is an index?

Answer :
  • A structure that enables you to locate rows in a table quickly, using an indexed value

Which of the following statements is a characteristic of a relational database?

Answer :
  • A row in a table represents a single entity

Which one of the following roles is not a data job role?

Answer :
  • Systems Administrator

Which of the following tools is a visualization and reporting tool?

Answer :
  • Power BI

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 of the components of Azure Synapse Analytics allows you to train AI models using AzureML?

Answer :
  • Synapse Spark