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: 10543936 -You plan to enable Azure Multi-Factor Authentication (MFA).You need to ensure that[email protected]can manage any databases hosted on an Azure SQL server named SQL10543936 by signing in using his Azure Active Directory (Azure AD) user account.To complete this task, sign in to the Azure portal.
HOTSPOT -You have the following Azure Stream Analytics query.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
DRAG DROP -You have an Azure SQL database named DB1 in the East US 2 region.You need to build a secondary geo-replicated copy of DB1 in the West US region on a new server.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:
HOTSPOT -You have an Azure SQL database that contains a table named Employee. Employee contains sensitive data in a decimal (10,2) column named Salary.You need to ensure that nonprivileged users can view the table data, but Salary must display a number from 0 to 100.What should you configure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
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 policy that tags the storage account.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?