Free and Premium Microsoft DP-900 Dumps Questions Answers

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.

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?

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

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.

Select the answer that correctly completes the sentence.

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.

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

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

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

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

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?

Select the answer that correctly completes the sentence.

You plan to deploy a PostgreSQL database to Azure.

Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

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?

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

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.

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?

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

How is raw data stored in a data lakehoose?

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

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

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.

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.

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

NOTE: Each correct selection is worth one point.

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?

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

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.

What can be used with native notebook support to query and visualize data by using a web-based interface?

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.

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?

Select the answer that correctly completes the sentence.

You have structured data in tabular format.

What represents an individual instance of a data entity?

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

backups, and maintenance tasks?

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Which storage solution supports role-based access control (RBAC) at the file and folder level?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

You have data saved in the following format.

Which format was used?

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.

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.

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 bank has a system that manages financial transactions.

When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.

Of which ACID semantic is this an example?

Select the answer that correctly completes the sentence.

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

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

NOTE: Each correct selection is worth one point.

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.

Select the answer that correctly completes the sentence.

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

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

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

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

Which Azure Storage service implements the key/value model?

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.

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

Of which type of solution is this is an example?

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.

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 gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?

You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.

What should you use in Microsoft Power BI?

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?

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?

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

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a

complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

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?

Select the answer that correctly completes the sentence.

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

Select the answer that correctly completes the sentence.

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.

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?

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

Select the answer that correctly completes the sentence.

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

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