DP-900 exam

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)A . denormalized dataB . heavy writes and moderate readsC . light writes and heavy readsD . schema on writeE . schema on...

What are two uses of data visualization? Each correct answer present 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 reportsView...

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 . predictiveB . prescriptionC . descriptiveD . diagnosticView AnswerAnswer: A Explanation: 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/

Which three actions are used when performing diagnostic analytics?A . • Identify data anomalies • Collect anomaly-related data • Discover relationships and trends that explain anomalies.B . • Identify data anomalies • Predict when anomalies are likely to recur • Use analytical tools such as decision trees and regression.C ....

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. View AnswerAnswer: Explanation: Box 1: Yes Like IaaS, PaaS includes infrastructure C servers, storage, and networking C but also middleware, development tools, business intelligence (BI)...

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?A . Synapse pipelinesB . a Synapse SQL poolC . Synapse LinkD . Synapse StudioView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link

HOTSPOT Select the answer that correctly completes the sentence. View AnswerAnswer: Explanation: Graphical user interface, text, application, email Description automatically generated A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?A . Microsoft SQL Server Data Tools (SSDT)B . Microsoft SQL Server Management Studio (SSMS)C . Azure DatabricksD . Azure Data StudioView AnswerAnswer: A Explanation: Reference: https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-serverver15

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . complete control over backup and restore processesB . access to the latest featuresC ....

Which statement is an example of Data Definition Language (DDL)?A . SELECTB . INSERTC . DELETED . DROPView AnswerAnswer: D Explanation: Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include: ✑ ALTER ✑ Collations ✑...