- All Exams Instant Download
Where does data processing occur for each stage of the ELT process?
DRAG DROP Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each...
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 processing B. batch processing C. 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
What is a characteristic of batch processing?
What is a characteristic of batch processing?A . The data ingested during batch processing must be processed as soon as the data is received. B. Large datasets must be split into batches of less than 1 GB before the data can be processed. C. There is a noticeable time delay...
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: A screenshot of a computer Description automatically generated with medium confidence
A bar chart showing year-to date sales by region is an example of which type of analytics?
A bar chart showing year-to date sales by region is an example of which type of analytics?A . descriptive B. diagnostic C. predictive D. prescriptiveView AnswerAnswer: B
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: Table Description automatically generated A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows...
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: YES, NO, YES Normalizing decreases throughput for reading (need to make joins), but increases for writing (Less to write, since there are...
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?A . INSERT B. MERGE C. UPDATE D. CREATEView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15
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:
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)A . report and dashboard creation B. report sharing and distribution C. data modeling D. data acquisition and preparationView AnswerAnswer:...
