- All Exams Instant Download
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy
DRAG DROP Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct...
Which type of processing does the application use?
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
When should you implement a read-only database replica?
You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?A . You need to generate reports without affecting the transactional workload.B . You need to audit the transactional application.C . You need to implement high availability in the...
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
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 type of processing does the reporting solution use?
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 processingB . Online Transaction Processing (OLTP)C . batch processingD . Online Analytical Processing (OLAP)View AnswerAnswer: B Explanation: Reference: https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/
To complete the sentence, select the appropriate option in the answer area
HOTSPOT To complete the sentence, select the appropriate option in the answer area. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
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:
What should you use?
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?A . Microsoft SQL Server Management Studio (SSMS)B . Azure Data StudioC . Azure CLID . Azure...
You have the following JSON document
HOTSPOT You have the following JSON document. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Reference: https://www.w3schools.com/js/js_json_arrays.asp https://www.w3schools.com/js/js_json_objects.asp
To complete the sentence, select the appropriate option in the answer area
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
