DP-900

Which statement is an example of Data Manipulation Language (DML)?A . INSERTB . DISABLEC . ALTERD . DROPView AnswerAnswer: A Explanation: Data Manipulation Language (DML) statements: ✑ DELETE ✑ INSERT ✑ UPDATE Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements

Which storage solution supports role-based access control (RBAC) at the file and folder level?A . Azure Disk StorageB . Azure Data Lake StorageC . Azure Blob storageD . Azure Queue storageView AnswerAnswer: B Explanation: Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

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

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

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?A . Azure SQL Database HyperscaleB . Azure SQL managed instanceC . Azure SQL Database servelessD . Azure SQL Database elastic podView AnswerAnswer: B

DRAG DROP Match the Azure Cosmos DB APIs to the appropriate data structures. To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all. NOTE: Each correct match is...

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

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:

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Text Description automatically generated with medium confidence With ELT, the data store used to perform the transformation is the same data store where the data is ultimately consumed.