DP-900 Microsoft Azure Data Fundamentals Questions and Answers

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

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 store should you use?

You have structured data in tabular format.

What represents an individual instance of a data entity?

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.

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

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?

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.

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?

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

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.

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

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

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

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

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.

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 is a difference between structured data and semi-structured data?

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.

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

What is the responsibility of a database administrator?

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.

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

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 a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.

Select the answer that correctly completes the sentence.

You need to store data by using Azure Table storage.

What should you create first?

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 data engineer is responsible for which task?

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.

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

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?

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

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

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

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

Which statement accurately describes data processing?

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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.

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.

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.

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.

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

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.

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

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.

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

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

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.

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

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

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?

What is a primary characteristic of a relational database?

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

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

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.

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

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

Of which type of database is this an example?

Select the answer that correctly completes the sentence.

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?

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

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

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

What should you use?

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.

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.

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?

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.

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.

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.

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.

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 storage solution supports access control lists (ACLs) at the file and folder level?

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

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.

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.

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

NOTE: Each correct selection is worth one point.