DP-900 Exam Questions

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

Drag and Drop Question Match the datastore services to the appropriate descriptions. To answer, drag the appropriate service from the column on the left to its description on the r...

Drag and Drop Question For each of the business questions, choose the appropriate type of analysis to answer the question. To answer, drag the appropriate analysis type to each que...

What do you use to create Power BI paginated reports?

Which Azure storage service includes support for Hot, Cool, and Archive access tiers?

In which two situations should you use a data warehousing solution? Each correct answer presents a complete solution.

Which type of database is Azure Database for PostgreSQL?

What is a characteristic of batch processing?

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?

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?

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

You need to create an Azure resource to store data in Azure Table storage. Which command should you run?

You need to modify a view in a relational database by adding a new column. Which statement should you use?

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

You need to store data by using Azure Table storage. What should you create first?

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 needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network. Which type of data...

What is the primary purpose of a data warehouse?

Drag and Drop Question 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) proce...

Drag and Drop Question 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...

What should you use to automatically delete blobs from Azure Blob Storage?

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

What is a characteristic of non-relational data?

You have data saved in the following format. Which format was used?

What is a primary characteristic of a relational database?

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

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

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

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

Drag and Drop Question 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....

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

You have data saved in the following format: Which format was used?

What is a characteristic of a non-relational database?

Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network. Which type of data...

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

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

In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution. NOTE: Each correct selection is...

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

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

Drag and Drop Question 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 proc...

You have data saved in the following format. Which format was used?

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

Which Azure Storage service implements the key/value model?

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

What is a function of a modern data warehouse?

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

Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?

You have the following two tables of customer data. Which type of data do the tables contain?

Drag and Drop Question 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 r...