DP-200 Exam Question 111

You need to process and query ingested Tier 9 data.
Which two options should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
  • DP-200 Exam Question 112

    You manage an enterprise data warehouse in Azure Synapse Analytics.
    Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.
    You need to monitor resource utilization to determine the source of the performance issues.
    Which metric should you monitor?
  • DP-200 Exam Question 113

    Note: This question is part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
    You develop data engineering solutions for a company.
    A project requires the deployment of resources to Microsoft Azure for batch data processing on Azure HDInsight. Batch processing will run daily and must:
    * Scale to minimize costs
    * Be monitored for cluster performance
    You need to recommend a tool that will monitor clusters and provide information to suggest how to scale.
    Solution: Monitor cluster load using the Ambari Web UI.
    Does the solution meet the goal?
  • DP-200 Exam Question 114

    Your company uses several Azure HDInsight clusters.
    The data engineering team reports several errors with some application using these clusters.
    You need to recommend a solution to review the health of the clusters.
    What should you include in you recommendation?
  • DP-200 Exam Question 115

    You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations.
    The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution must also minimize latency.
    You need to secure the transfer of data between on-premises databases and Microsoft Azure.
    What should you do?