Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 211:

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

  A. Azure Queue storage

  B. Azure Data Lake Storage

  C. Azure table storage

  D. Azure Files

  Correct Answer: B

  Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

• Question 212:

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

  B. Online Transaction Processing (OLTP)

  C. batch processing

  D. Online Analytical Processing (OLAP)

  Correct Answer: D

  Reference: https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

• Question 213:

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

  A. Power BI report Builder

  B. Power BI Desktop

  C. Charticulator

  D. the Power BI service

  Correct Answer: A

  Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service. Reference: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

• Question 214:

  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?

  A. a dashboard

  B. Microsoft Power Apps

  C. a dataflow

  D. a report

  Correct Answer: D

  Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

• Question 215:

  What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.

  A. Data is processed as it is created.

  B. Low latency is expected

  C. High latency acceptable

  D. Data is processed periodically

  Correct Answer: AB

  Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.

  Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing

• Question 216:

  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.

  A. Azure Databricks

  B. Azure Log Analytics

  C. Azure Time Series Insights

  D. Azure HDinsight

  Correct Answer: AD

  Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/

• Question 217:

  What are two uses of data visualization? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Represent trends and patterns over time.

  B. Communicate the significance of data.

  C. implement machine learning to predict future values.

  D. Consistently implement business logic across reports

  Correct Answer: AB

  Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data. Data visualization brings data to help you find key business insights quickly and effectively.

  Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization

• Question 218:

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

  A. stream processing

  B. batch processing

  C. Online Analytical Processing (OLTP)

  D. Online Transaction Processing (OLTP)

  Correct Answer: D

  OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.

  Reference: https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/

• Question 219:

  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?

  A. predictive

  B. prescription

  C. descriptive

  D. diagnostic

  Correct Answer: A

  Predictive, to answer the question: What will happen?

  Reference:

  https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

  https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

• Question 220:

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

  A. descriptive

  B. diagnostic

  C. predictive

  D. prescriptive

  Correct Answer: B