Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.You plan to copy the data from the storage account to an Azure SQL data warehouse.You need to prepare the files to ensure that the data copies quickly.Solution: You modify the files to ensure that each row is more than 1 MB.Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics.You need to prepare the files to ensure that the data copies quickly.Solution: You copy the files to a table that has a columnstore index.Does this meet the goal?
You plan to deploy an Azure Cosmos DB database that supports multi-master replication.You need to select a consistency level for the database to meet the following requirements:✑ Provide a recovery point objective (RPO) of less than 15 minutes.✑ Provide a recovery time objective (RTO) of zero minutes.What are three possible consistency levels that you can select? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
SIMULATION -Use the following login credentials as needed:Azure Username: xxxxx -Azure Password: xxxxx -The following information is for technical support purposes only:Lab Instance: 10277521 -You need to ensure that you can recover any blob data from an Azure Storage account named storage 10277521 up to 30 days after the data is deleted.To complete this task, sign in to the Azure portal.
SIMULATION -Use the following login credentials as needed:Azure Username: xxxxx -Azure Password: xxxxx -The following information is for technical support purposes only:Lab Instance: 10277521 -You need to replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region.To complete this task, sign in to the Azure portal.NOTE: This task might take several minutes to complete. You can perform other tasks while the task completes or ends this section of the exam.To complete this task, sign in to the Azure portal.
You are a data engineer implementing a lambda architecture on Microsoft Azure. You use an open-source big data solution to collect, process, and maintain data.The analytical data store performs poorly.You must implement a solution that meets the following requirements:✑ Provide data warehousing✑ Reduce ongoing management activities✑ Deliver SQL query responses in less than one secondYou need to create an HDInsight cluster to meet the requirements.Which type of cluster should you create?
