Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with creating a Power BI Desktop project (.pbix) to analyze sales data from multiple sources, including SQL Server and Excel files. The project must ensure data consistency and accuracy for reliable analysis. Considering the need for data transformation, cleaning, and the establishment of relationships between data tables, which of the following steps is the MOST comprehensive approach to achieve this goal? (Choose one option from A to D)
A
Use the 'Get Data' feature in Power BI Desktop to connect to the SQL Server and Excel files, and import the required data tables without any further steps.
B
Create a new folder on your machine, copy the Excel files, and import them into Power BI Desktop as data sources, then manually adjust the data in Power BI.
C
Use Power Query in Power BI Desktop to transform and clean the data from both SQL Server and Excel files, ensuring consistency and accuracy, but do not establish any relationships between the data tables.
D
Use the 'Get Data' feature to connect to the data sources, transform and clean the data using Power Query, and combine the data using the 'Merge Queries' feature, then create relationships between the data tables.
E
All of the above