Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test

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 plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

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

Select the answer that correctly completes the sentence.

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?

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.

Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

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.

Which Azure Cosmos DB API should you use for a graph database?

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

What is a characteristic of a non-relational database?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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.

What is a characteristic of non-relational 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.

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 type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?

Which file format has defined names and data types for each column and uses compressed columnar storage?

Which statement accurately describes data processing?

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 hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

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.

You have an Azure SQL database that you access directly from the internet.

You recently changed your external IP address.

After changing the IP address, you can no longer access the database. You can connect to other resources in Azure

What is a possible cause of the issue?

From Power Bi Desktop, you are creating a sales performance report. You need to create visualizations that meet the following requirements:

• Display the relationship between the advertising budget and the number of new customers.

• Show the percentage of total sales for each region.

Which type of visualization should you use for each requirement? lo answer, select the appropriate options in the answer area.

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 component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

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.

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?

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

backups, and maintenance tasks?

Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.

Which type of data store should you use?

Select the answer that correctly completes the sentence.

Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

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

A data engineer is responsible for which task?

Match the database normalization terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term 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.

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

You have an on-premises Microsoft SQL Server database.

You need to migrate the database to the cloud. The solution must meet the following requirements:

• Minimize maintenance effort.

• Support the Database Mail and Service Broker features.

What should you include in the solution?

What should you include in the solution?

Match the Azure services to appropriate requirements.

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

NOTE: Each correct match is worth one point.

What is a primary characteristic of a relational database?

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?

Select the answer that correctly completes the sentence.

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?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

You have an Azure Cosmos DB account that uses the Core (SQL) API.

Which two settings can you configure at the container level? Each correct answer presents a complete

solution. (Choose two.)

NOTE: Each correct selection is worth one point.

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

Match the job roles to the appropriate tasks.

To answer, drag the appropriate job 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.

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

Match the job roles to the appropriate tasks.

To answer, drag the appropriate job 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.

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

NOTE: Each correct selection is worth one point.

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?

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?

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?

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.

Which Azure Storage service implements the key/value model?

What is required to provision Azure Data Lake Storage in an Azure Storage account?

Select the answer that correctly completes the sentence.

Which service is optimized for loT scenarios that involve streaming time series data?

Select the answer that correctly completes the sentence.

When can you use an Azure Resource Manager template?

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.

Match the ACID terms to the Appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Match the Azure SQL services to the appropriate use cases.

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

NOTE: Each correct match is worth one point.

Which service can be used to build extract, transform, and load (ETL) pipelines?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Which storage solution supports role-based access control (RBAC) 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

At which level in Azure Cosmos DB can you configure multiple write regions and read regions?

Select the answer that correctly completes the sentence.

When you create an Azure SQL database, which account can always connect to the database ?

Match the Azure services to the appropriate requirements.

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

NOTE: Each correct match is worth one point.

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

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.

You have an online store that is hosted in Azure. The store generates millions of transaction records daily.

You need to build a data analytics solution that detects fraudulent transactions in real time and enables analysts to run large-scale queries for deeper insights.

Which two services should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

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.

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

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

NOTE: Each correct selection is worth one point.

A bar chart showing year-to date sales by region is an example of which type of analytics?

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 Definition Language (DDL)?

tence.

Select the answer that correctly completes the sentence.