AZ-305 Exam Question 121

You have 12 on-premises data sources that contain customer information and consist of Microsoft SQL Server, MySQL, and Oracle databases.
You have an Azure subscription.
You plan to create an Azure Data Lake Storage account that will consolidate the customer information for analysis and reporting.
You need to recommend a solution to automatically copy new information from the data sources to the Data Lake Storage account by using extract, transform and load (ETL). The solution must minimize administrative effort.
What should you include in the recommendation?
  • AZ-305 Exam Question 122

    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.
    Your company has deployed several virtual machines (VMs) on-premises and to Azure. Azure ExpressRoute has been deployed and configured for on-premises to Azure connectivity.
    Several VMs are exhibiting network connectivity issues.
    You need to analyze the network traffic to determine whether packets are being allowed or denied to the VMs.
    Solution: Install and configure the Microsoft Monitoring Agent and the Dependency Agent on all VMs. Use the Wire Data solution in Azure Monitor to analyze the network traffic.
    Does the solution meet the goal?
  • AZ-305 Exam Question 123

    You migrate App1 to Azure. You need to ensure that the data storage for App1 meets the security and compliance requirement What should you do?
  • AZ-305 Exam Question 124

    You ate designing an Azure governance solution.
    All Azure resources must be easily identifiable based on the following operational information environment, owner, department and cost center You need 10 ensure that you can use the operational information when you generate reports for the Azure resources.
    What should you include in the solution?
  • AZ-305 Exam Question 125

    You store web access logs data in Azure Blob storage.
    You plan to generate monthly reports from the access logs.
    You need to recommend an automated process to upload the data to Azure SQL Database every month.
    What should you include in the recommendation?