DP-900

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 DatabricksB . Azure Log AnalyticsC . Azure Time Series InsightsD . Azure HDinsightView AnswerAnswer: A,D Explanation: Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/

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 dashboardB . Microsoft Power AppsC . a dataflowD...

HOTSPOT To complete the sentence select the appropriate option in the answer area. View AnswerAnswer:

Which statement is an example of Data Definition Language (DDL)?A . SELECTB . JOINC . MERGED . CREATEView AnswerAnswer: D Explanation: Reference: https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense. What should the developers use?A . Azure Data StudioB . sq1cmdC . Microsoft...

HOTSPOT You have the following SQL query. NOTE:Each correct selection is worth one point. View AnswerAnswer:

Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network. Which type of data store should you use?A . Key/valueB . GraphC . DocumentD . columnarView AnswerAnswer: B Explanation: Data as it appears in the real...

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

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 . graphB . key/valueC . documentD . columnarView AnswerAnswer: A Explanation: Data as it appears in the real world...

Which storage solution supports access control lists (ACLs) at the file and folder level?A . Azure Data Lake StorageB . Azure Cosmos DBC . Azure Queue storageD . Azure Blob storageView AnswerAnswer: A