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 plan to query db3 to retrieve a list of sales customers. The query will retrieve several columns that include the email address of each sales customer.You need to modify db3 to ensure that a portion of the email addresses is hidden in the query results.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 increase the size of db2 to store up to 250 GB of data.To complete this task, sign in to the Azure portal.
HOTSPOT -You have an enterprise data warehouse in Azure Synapse Analytics that contains a table named FactOnlineSales. The table contains data from the start of 2009 to the end of 2012.You need to improve the performance of queries against FactOnlineSales by using table partitions. The solution must meet the following requirements:✑ Create four partitions based on the order date.✑ Ensure that each partition contains all the orders placed during a given calendar year.How should you complete the T-SQL command? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
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 need to create an elastic pool that contains an Azure SQL database named db2 and a new SQL database named db3.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: 10543936 -You need to create an Azure Storage account named account10543936. The solution must meet the following requirements:✑ Minimize storage costs.✑ Ensure that account10543936 can store many image files.Ensure that account10543936 can quickly retrieve stored image files.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?
