Question 46

You have two Azure Storage accounts named Storage1 and Storage2. Each account holds one container and has the hierarchical namespace enabled. The system has files that contain data stored in the Apache Parquet format.
You need to copy folders and files from Storage1 to Storage2 by using a Data Factory copy activity. The solution must meet the following requirements:
* No transformations must be performed.
* The original folder structure must be retained.
* Minimize time required to perform the copy activity.
How should you configure the copy activity? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 47

You are building an Azure Analytics query that will receive input data from Azure IoT Hub and write the results to Azure Blob storage.
You need to calculate the difference in readings per sensor per hour.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 48

What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?
  • Question 49

    You have an Azure Synapse Analytics dedicated SQL pool that contains a large fact table. The table contains 50 columns and 5 billion rows and is a heap.
    Most queries against the table aggregate values from approximately 100 million rows and return only two columns.
    You discover that the queries against the fact table are very slow.
    Which type of index should you add to provide the fastest query times?
  • Question 50

    You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool.
    How should you complete the Transact-SQL statement? 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.