DP-900 Microsoft Azure Data Fundamentals Questions and Answers

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Which statement is an example of Data Manipulation Language (DML)?

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

Select the answer that correctly completes the sentence.

To complete the sentence, select the appropriate option in the answer area.

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?

In a fully denormalized database, how is data read and written for a single entity?

You need to recommend a data store service that meets the following requirements:

Native SQL API access

Configurable indexes

What should you recommend?

You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.

What should you use?

Your company is designing a database that will contain session data for a website. The data will include

notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

What is a difference between structured data and semi-structured data?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Which clause should you use in a select statement to combine rows in one table with rows in another table?

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

To complete the sentence, select the appropriate option in the answer area.

What can you use to create data ingestion pipelines?

Match the Azure services to the appropriate locations in the architecture.

To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

You have data saved in the following format.

Which format was used?

Which storage solution supports access control lists (ACLs) at the file and folder level?

You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point

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.

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.

Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

You need to create an Azure Storage account.

Data in the account must replica outside the Azure region automatically.

Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one pint.

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

Match the processes to the appropriate scenarios.

To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select the answer that correctly completes the sentence.

Which Azure Storage service implements the key/value model?

What should you use to build a Microsoft Power BI paginated report?

correctly completes the sentence.

Select the answer that correctly completes the sentence.

To complete the sentence, select the appropriate option in the answer area.

To complete the sentence, select the appropriate option in the answer area.

What is the primary purpose of a data warehouse?

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have the following JSON document.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,

backups, and maintenance tasks?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

To complete the sentence, select the appropriate option in the answer area.

Select the answer that correctly completes the sentence.

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

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?

Which three actions are used when performing diagnostic analytics?

Match the job roles to the appropriate tasks.

To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

To complete the sentence, select the appropriate option in the answer area.

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

To complete the sentence, select the appropriate option in the answer area.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query. What should you create?

You have the following two tables of customer data.

Which type of data do the tables contain?

Match the types of data to the appropriate Azure data services.

To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

Select the answer that correctly completes the sentence.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Match the types of data stores to the appropriate scenarios.

To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

To complete the sentence, select the appropriate option in the answer area.

Select the answer that correctly completes the sentence.

To complete the sentence, select the appropriate option in the answer area.

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

To complete the sentence, select the appropriate option in the answer area.

To complete the sentence, select the appropriate option in the answer area.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

To complete the sentence, select the appropriate option in the answer area.

Select the answer that correctly completes the sentence.

To complete the sentence, select the appropriate option in the answer area.

You need to create an Azure resource to store data in Azure Table storage.

Which command should you run?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Which type of database is Azure Database for PostgreSQL?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

Which Azure service should you use to support the application?