Microsoft DP-900 Dumps

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?

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.

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

SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

Select the answer that correctly completes the sentence.

Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

Which type of database contains nodes and edges?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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?

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

Select the answer that correctly completes the sentence.

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

NOTE: Each correct selection is worth one point.

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 pre sented in the graphic.

NOTE: Each correct selection is worth one point

Select the answer that correctly completes the sentence.

You have data saved in the following format.

Which format was used?

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 corre ct selection is worth one point.

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Which type of database is Azure Database for PostgreSQL?

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.

Select the answer that correctly completes the sentence.

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.

Select the answer that correctly completes the sentence.

Which scenario is an example of a streaming workload?

Match the data terms to the appropriate descriptions.

To answer, drag the 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 are writing a set of SQL queries that administrators will use to troubleshoot an Azu re SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

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

Which command should you run?

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 is a characteristic of non-relational data?

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.

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.

correctly completes the sentence.

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

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

Select the answer that correctly completes the sentence.

Which Azure Data Factory component initiates the execution of a pipeline?

You have the following two tables of customer data.

Which type of data do the tables contain?

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 should you use to automatically delete blobs from Azure Blob Storage?

What should you use to build a Microsoft Power BI paginated report?

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

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.

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

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.

What are two characteristics of real-time data processing? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

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.

Which two act ivities 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.

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

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.

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 right. Each service may be used once, more than once, or not at all.

NOTE: Each correct match 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.

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.

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 three actions are used when performing diagnostic analytics?

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.

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?

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

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

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

NOTE: Each correct selection is worth one point.

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

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

Which command-line tool can you use to query Azure SQL databases?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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.

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

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

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

Which Azure Data Factory component provides the compute environment for activities?

Which clause should you use in a select statement to combine rows in one tab le with rows in another table?

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

Select the answer that correctly completes the sentence.

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one poin t.

Select the answer that correctly completes the sentence.

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

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.

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.

UESTION NO: 56

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.

Select the answer that correctly completes the sentence.

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?