Practice Free DP-900 Exam Online Questions
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?
- A . key/value
- B . graph
- C . columnar
- D . document
DRAG DROP
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 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.
- A . Create a Microsoft Power Bl report.
- B . Create an Azure Data Factory pipeline.
- C . Use an Apache Spark job to process data stored in an Azure Cosmos DB database.
- D . Create a data flow in Azure Data Factory.
- E . Create an Apache Spark job that will run in a Spark cluster.
HOTSPOT
For each of the following statements, select yes if he statement is true, Otherwise select No. NOTE: Each correct selection is worth one point.
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?
- A . graph
- B . key/value
- C . document
- D . columnar
HOTSPOT
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 command-line tool can you use to query Azure SQL databases?
- A . sqlcmd
- B . bcp
- C . azdata
- D . Azure CLI
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?
- A . a waterfall chart
- B . a ribbon chart
- C . a bar chart
- D . a decomposition tree
You need to store event log data that is semi-structured and received as the logs occur.
What should you use?
- A . Azure Table storage
- B . Azure Queue storage
- C . Azure Files