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 subscription that contains an Azure Storage account.You plan to implement changes to a data storage solution to meet regulatory and compliance standards.Every day, Azure needs to identify and delete blobs that were NOT modified during the last 100 days.Solution: You apply an Azure Blob storage lifecycle policy.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 SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22).You need to implement masking for the Customer_ID field to meet the following requirements:✑ The first two prefix characters must be exposed.✑ The last four suffix characters must be exposed.✑ All other characters must be masked.Solution: You implement data masking and use a custom string function mask.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 subscription that contains an Azure Storage account.You plan to implement changes to a data storage solution to meet regulatory and compliance standards.Every day, Azure needs to identify and delete blobs that were NOT modified during the last 100 days.Solution: You schedule an Azure Data Factory pipeline.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 convert the files to compressed delimited text files.Does this meet the goal?
You are designing an enterprise data warehouse in Azure Synapse Analytics. You plan to load millions of rows of data into the data warehouse each day.You must ensure that staging tables are optimized for data loading.You need to design the staging tables.What type of tables should you recommend?
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?
