DP-900 exam

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 processingB . batch processingC . Online Analytical Processing (OLTP)D . Online Transaction Processing (OLTP)View AnswerAnswer: D Explanation: Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

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 Tables are database objects that contain all the data in a database. In tables, data is logically organized in...

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Reference: https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?A . supports partitioningB . provides resiliency if art Azure region fadsC . provides a higher storage capacityD . supports a multi-master modelView AnswerAnswer: D Explanation: Multi-master support for Azure Cosmos DB is now...

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 Tables are database objects that contain all the data in a database. In tables, data is logically organized in...

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

DRAG DROP Match the Azure data factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one...

HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

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

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