DRAG DROP -Your company has an on-premises Microsoft SQL Server instance.The data engineering team plans to implement a process that copies data from the SQL Server instance to Azure Blob storage once a day. The process must orchestrate and manage the data lifecycle.You need to create Azure Data Factory to connect to the SQL Server instance.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
A company runs Microsoft SQL Server in an on-premises virtual machine (VM).You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD).You need to configure Azure SQL Database to use an Azure AD user as administrator.What should you configure?
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 credit card 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 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 an email 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 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 random number function mask.Does this meet the goal?
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?
