DP-300 Exam Question 76

You have the following Azure Data Factory pipelines:
* Ingest Data from System1
* Ingest Data from System2
* Populate Dimensions
* Populate Facts
Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.
What should you do to schedule the pipelines for execution?
  • DP-300 Exam Question 77

    You have an Azure SQL database named DB1.
    You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled.
    During a database audit, you discover that none of the fields contain more than 150 characters.
    You need to ensure that you can apply page compression to Table1.
    What should you do?
  • DP-300 Exam Question 78

    You have an Azure SQL Database managed instance.
    The instance starts experiencing performance issues.
    You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.
    What should you use?
  • DP-300 Exam Question 79

    You have an Azure SQL managed instance.
    You need to restore a database named DB1 by using Transact-SQL.
    Which command should you run? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 80

    You have a Microsoft SQL Server 2017 server that hosts five databases.
    You Plan to migrate the databases to Azure.
    You need to recommend a solution that meets the following requirements:
    Automatically scales compute based on the workload demand
    Provides per-second billing
    What should you include in the recommendation? To answer, select the appropriate options in the answer area.