<< Prev Question Next Question >>

Question 128/135

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 stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (135q)
Question 1: Select the answer that correctly completes the sentence. (Ex...
Question 2: To complete the sentence, select the appropriate option in t...
Question 3: To complete the sentence, select the appropriate option in t...
Question 4: Select the answer that correctly completes the sentence. (Ex...
Question 5: For each of the following statements, select Yes if the stat...
Question 6: Select the answer that correctly completes the sentence. (Ex...
Question 7: Which storage solution supports role-based access control (R...
Question 8: What is a difference between structured data and semi-struct...
Question 9: You have an inventory management database that contains the ...
Question 10: In a fully denormalized database, how is data read and writt...
Question 11: For each of the following statements, select Yes if the stat...
Question 12: Select the answer that correctly completes the sentence. (Ex...
Question 13: Match the terms to the appropriate descriptions. To answer, ...
Question 14: Match the types of workloads to the appropriate scenarios. T...
Question 15: To complete the sentence, select the appropriate option in t...
Question 16: To complete the sentence, select the appropriate option in t...
Question 17: For each of the following statements, select Yes if the stat...
Question 18: Select the answer that correctly completes the sentence. (Ex...
Question 19: When provisioning an Azure Cosmos DB account, which feature ...
Question 20: You need to recommend a data store service that meets the fo...
Question 21: Your company plans to load data from a customer relationship...
Question 22: Select the answer that correctly completes the sentence. (Ex...
Question 23: For each of the following statements, select yes if he state...
Question 24: correctly completes the sentence. (Exhibit)...
Question 25: Which Azure storage solution provides native support for POS...
Question 26: Select the answer that correctly completes the sentence. (Ex...
Question 27: What can be used with native notebook support to query and v...
Question 28: In Azure Table storage, each row in a table must be uniquely...
Question 29: Which statement is an example of Data Definition Language (D...
Question 30: For each of the following statements. select Yes if the stat...
Question 31: You need to store event log data that is semi-structured and...
Question 32: In an analytical data model, which type of table contains en...
Question 33: You have data saved in the following format. (Exhibit) \ Whi...
Question 34: Match the terms to the appropriate descriptions. To answer, ...
Question 35: Match the Azure Cosmos DB APIs to the appropriate data struc...
Question 36: Select the answer that correctly completes the sentence. (Ex...
Question 37: Match the terms to the appropriate descriptions. To answer, ...
Question 38: Match the job roles to the appropriate tasks. To answer, dra...
Question 39: You have a table named Sales that contains the following dat...
Question 40: Match the data processing languages to the appropriate real-...
Question 41: For each of the following statements, select Yes if the stat...
Question 42: Select the answer that correctly completes the sentence. (Ex...
Question 43: Which scenario is an example of a streaming workload?...
Question 44: You need to create an Azure Storage account. Data in the acc...
Question 45: Select the answer that correctly completes the sentence. (Ex...
Question 46: Select the answer that correctly completes the sentence. (Ex...
Question 47: Select the answer that correctly completes the sentence. (Ex...
Question 48: For each of the following statements, select Yes if the stat...
Question 49: For each of the following statements, select Yes if the stat...
Question 50: Select the answer that correctly completes the sentence. (Ex...
Question 51: Match the security components to the appropriate scenarios. ...
Question 52: To complete the sentence, select the appropriate option in t...
Question 53: Your company needs to implement a relational database in Azu...
Question 54: For each of the following statements, select Yes if the stat...
Question 55: To complete the sentence, select the appropriate option in t...
Question 56: Your company if designing an application that will write a h...
Question 57: Select the answer that correctly completes the sentence. (Ex...
Question 58: For each of the following statements, select Yes if the stat...
Question 59: For each of the following statements, select Yes if the stat...
Question 60: Select the answer that correctly completes the sentence. (Ex...
Question 61: Match the job roles to the appropriate tasks. To answer, dra...
Question 62: Select the answer that correctly completes the sentence. (Ex...
Question 63: To complete the sentence, select the appropriate option in t...
Question 64: Match the Azure services to the appropriate locations in the...
Question 65: To complete the sentence, select the appropriate option in t...
Question 66: You need to develop a solution to provide data to executives...
Question 67: Match the Azure services to the appropriate locations in the...
Question 68: Which type of non-relational data store supports a flexible ...
Question 69: What are two characteristics of real-time data processing? E...
Question 70: For each of the following statements, select Yes if the stat...
Question 71: Match the types of activities to the appropriate Azure Data ...
Question 72: Which two Azure services can be used to provision Spark clus...
Question 73: Select the answer that correctly completes the sentence. (Ex...
Question 74: To complete the sentence, select the appropriate option in t...
Question 75: Select the answer that correctly completes the sentence. (Ex...
Question 76: You have an Azure SQL database that you access directly from...
Question 77: You plan to deploy a PostgreSQL database to Azure. Which hos...
Question 78: Your company needs to ensure that in Azure virtual machine c...
Question 79: What are two uses of data visualization? Each correct answer...
Question 80: Which statement is an example of Data Manipulation Language ...
Question 81: What is the primary purpose of a data warehouse?...
Question 82: Select the answer that correctly completes the sentence.For ...
Question 83: To complete the sentence select the appropriate option in th...
Question 84: To complement the sentence, select the appropriate option in...
Question 85: Match the types of analytics that can be used to answer the ...
Question 86: For each of the following statements. select Yes if the stat...
Question 87: To complete the sentence, select the appropriate option in t...
Question 88: Select the answer that correctly completes the sentence. (Ex...
Question 89: To complete the sentence, select the appropriate option in t...
Question 90: Match the Azure SQL services to the appropriate use cases. T...
Question 91: You need to create an Azure resource to store data in Azure ...
Question 92: To complete the sentence, select the appropriate option in t...
Question 93: You are reviewing the data model shown in the following exhi...
Question 94: Which database transaction property ensures that transaction...
Question 95: Select the answer that correctly completes the sentence. (Ex...
Question 96: You need to design and model a database by using a graphical...
Question 97: Which file format has defined names and data types for each ...
Question 98: You have a SQL query that combines customer data and order d...
Question 99: A bank has a system that manages financial transactions. Whe...
Question 100: Select the answer that correctly completes the sentence. (Ex...
Question 101: Which Azure service provides the highest compatibility for d...
Question 102: Your company has a reporting solution that has paginated rep...
Question 103: To complete the sentence, select the appropriate option in t...
Question 104: Select the answer that correctly completes the sentence. (Ex...
Question 105: You are deploying a software as a service (SaaS) application...
Question 106: Select the answer that correctly completes the sentence. (Ex...
Question 107: Select the answer that correctly completes the sentence. (Ex...
Question 108: Select the answer that correctly completes the sentence. (Ex...
Question 109: You need to create a visualization of running sales totals p...
Question 110: For each of the following statements, select Yes if the stat...
Question 111: You need to recommend a non-relational data store that is op...
Question 112: Which storage solution supports access control lists (ACLs) ...
Question 113: You have a SQL pool in Azure Synapse Analytics that is only ...
Question 114: Select the answer that correctly completes the sentence. (Ex...
Question 115: At which two levels can you set the throughput for an Azure ...
Question 116: Match the tools to the appropriate descriptions. To answer, ...
Question 117: You plan to deploy an app. The app requires a nonrelational ...
Question 118: Select the answer that correctly completes the sentence. (Ex...
Question 119: Match the Azure services to the appropriate requirements. To...
Question 120: You have a quality assurance application that reads data fro...
Question 121: You need to use Transact-SQL to query files in Azure Data La...
Question 122: Select the answer that correctly completes the sentence. (Ex...
Question 123: You have the following JSON document. (Exhibit) Use the drop...
Question 124: Which Azure Cosmos DB API should you use for a graph databas...
Question 125: Which type of database is Azure Database for PostgreSQL?...
Question 126: For each of the following statements, select yes if the stat...
Question 127: Match the types of analytics that can be used to answer the ...
Question 128: Your company plans to load data from a customer relationship...
Question 129: Select the answer that correctly completes the sentence. (Ex...
Question 130: Which setting can only be configured during the creation of ...
Question 131: What is required to provision Azure Data Lake Storage in an ...
Question 132: To complete the sentence, select the appropriate option in t...
Question 133: To complete the sentence, select the appropriate option in t...
Question 134: Your company is designing a data store tor internet-connecte...
Question 135: You manage an application that stores data in a shared folde...