DP-700 Question #97: Real Exam Question with Answer & Explanation

Question

You plan to process the following three datasets by using Fabric: Dataset1: This dataset will be added to Fabric and will have a unique primary key between the source and the destination. The unique primary key will be an integer and will start from 1 and have an increment of 1. Dataset2: This dataset contains semi-structured data that uses bulk data transfer. The dataset must be loaded in one process between the source and the destination. The data transformation process will include the use of custom visuals to understand and work with the dataset in development mode. Dataset3: This dataset is in a lakehouse. The data will be bulk loaded. The data transformation process will include row-based windowing functions during the loading process. You need to identify which type of item to use for the datasets. The solution must minimize development effort and use built-in functionality, when possible. What should you identify for each dataset? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.