Question 26

You need to output files from Azure Data Factory.
Which file format should you use for each type of output? To answer, select the appropriate options in the answer are a.
NOTE: Each correct selection is worth one point.

Question 27

You have an Azure Factory instance named DF1 that contains a pipeline named PL1.PL1 includes a tumbling window trigger.
You create five clones of PL1. You configure each clone pipeline to use a different data source.
You need to ensure that the execution schedules of the clone pipeline match the execution schedule of PL1.
What should you do?
  • Question 28

    You need to create an Azure Data Factory pipeline to process data for the following three departments at your company: Ecommerce, retail, and wholesale. The solution must ensure that data can also be processed for the entire company.
    How should you complete the Data Factory data flow script? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
    NOTE: Each correct selection is worth one point.

    Question 29

    You are designing a partition strategy for a fact table in an Azure Synapse Analytics dedicated SQL pool. The table has the following specifications:
    * Contain sales data for 20,000 products.
    * Use hash distribution on a column named ProduclID,
    * Contain 2.4 billion records for the years 20l9 and 2020.
    Which number of partition ranges provides optimal compression and performance of the clustered columnstore index?
  • Question 30

    You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns:
    * EventDate: 1 million per day
    * EventTypelD: 10 million per event type
    * WarehouselD: 100 million per warehouse
    * ProductCategoryTypeiD: 25 million per product category type
    You identify the following usage patterns:
    Analyst will most commonly analyze transactions for a warehouse.
    Queries will summarize by product category type, date, and/or inventory event type.
    You need to recommend a partition strategy for the table to minimize query times.
    On which column should you recommend partitioning the table?