DP-900 Microsoft Azure Data Fundamentals Questions and Answers

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?

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

In Azure Table storage, each row in a table must be uniquely identified by which two components?

Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

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

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.

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

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

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

Select the answer the correctly completes the sentence.

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

Which command should you run?

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.

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.

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.

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?

You have a quality assurance application that reads data from a data warehouse.

Which type of processing does the application use?

Select the answer that correctly completes the sentence.

Which Azure Cosmos DB API stores data in the BSON format and uses MQL to query the data?

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.

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

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?

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?

Select the answer that correctly completes the sentence.

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.

Which type of data store should you recommend?

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

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

NOTE: Each correct selection 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?

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?

Select the answer that correctly completes the sentence.

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.

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.

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. Each location may be used 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.

Select the answer that correctly completes the sentence.

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

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

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 T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

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

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

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

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

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.

Select the answer that correctly completes the sentence.

Which scenario is an example of a streaming workload?

To complement 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.

A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.

Of which ACID semantic is this an example?

Select the answer that correctly completes the sentence.

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

Select the answer that correctly completes the sentence.

Match the types of analytics that can be used to answer the business questions.

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

Match the types of activities to the appropriate Azure Data Factory activities.

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

NOTE: Each correct match is worth one point.

What is an example of rehydrating a blob in an Azure Storage account?

Select the answer that correctly completes the sentence.

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

Which statement is an example of Data Definition Language (DDL)?

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.

Select the answer that correctly completes the sentence.

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

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

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

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?

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?

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.

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 contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.

Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

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

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

Select the answer that correctly completes the sentence.

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.

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.

Select the answer that correctly completes the sentence.

What can you use to create data ingestion pipelines?

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

Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?

Match the types of analytics that can be used to answer the business questions.

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

NOTE: Each correct match is worth one point.

What is a characteristic of a non-relational database?

You have a database that stores data in the format shown in the following table.

Of which type of database is this an example?

Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.

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

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

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.

What is a characteristic of non-relational data?

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

What is a primary characteristic of a relational database?