DP-900 Sample Questions Answers

Select the answer that correctly completes the sentence.

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

You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named accounts account1 stores raw sales transaction data from multiple regions.

You need to create an analytical data store that will ingest and analyze the data.

What 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.

Which setting can only be configured during the creation of an Azure Cosmos DB account?

Which type of Azure resource supports the serverless configuration of an Azure SQL database?

You are building a Microsoft Power B1 report for a retail company. The data model for the report contains the following related Tables.

Vou need to create a visualization that shows the percentage of total sales by store type. The solution must minimize the number of fields and visuals used.

What should you do?

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?

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

NOTE: Each correct selection is worth one point.

Match the storage solutions to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

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

Match the 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.

Match the security components to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

What is the responsibility of a database administrator?

Match the 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.

What can you use to create data ingestion pipelines?

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 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?

Match the data storage options to the appropriate types of data.

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

NOTE: Each correct match is worth one point.

What are two uses of data visualization? Each correct answer present a complete solution.

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 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?

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

Select the answer that correctly completes the sentence.

You need to store event log data that is semi-structured and received as the logs occur. What should you use?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

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

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.

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.

Select the answer that correctly completes the sentence.

You have data in a tabular format as shown in the following table.

Of which type of data is this an example?

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?

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 statement is an example of Data Definition Language (DDL)?

You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

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

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

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

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

Of which type of solution is this is an example?

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 need to implement a visual that will display the stages of a sales pipeline and the number of leads from each stage. Which type of visual should you use?

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

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

Match the types of visualizations to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

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

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

Select the answer that correctly completes the sentence.

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?

Select the answer that correctly completes the sentence.

Which language is used to define queries in Azure Synapse Data Explorer?

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

How is raw data stored in a data lakehoose?

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.

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.

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 statement accurately describes data processing?

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.

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.

Which scenario is an example of a streaming workload?

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.

You have structured data in tabular format.

What represents an individual instance of a data entity?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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

Native SQL API access

Configurable indexes

What should you recommend?

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution 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.

You have an application that runs on Windows and requires across to a mapped drive.

Which Azure service should you use?

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.

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 is used to define a query in a stream processing jobs in Azure Stream Analytics?

Select the answer that correctly completes the sentence.

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.

Select the answer that correctly completes the sentence.

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

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

backups, and maintenance tasks?

Match the types of workloads to the appropriate scenarios.

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

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

maintenance.

Which Azure service should you use?

What is a characteristic of batch processing?

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

NOTE: Each correct selection is worth one point.

Match the 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.

You need to analyze data by using Azure Databricks.

Which are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.