You have a Fabric workspace that contains a Microsoft Power BI report. You need to modify the column names in the Power BI report without changing the original names in the underlying Delta table. Which warehouse object should you create?

Prepare for the DP-600 Fabric Analytics Engineer Exam. Study with flashcards and multiple choice questions, each offering hints and detailed explanations. Enhance your chances of success on the exam!

Multiple Choice

You have a Fabric workspace that contains a Microsoft Power BI report. You need to modify the column names in the Power BI report without changing the original names in the underlying Delta table. Which warehouse object should you create?

Explanation:
Using a view as the presentation layer is the right approach here. A view allows you to present data with new, user-friendly column names without changing the underlying Delta table. When Power BI queries the view, it sees the aliased column names while the actual data and column names in the source remain untouched. This preserves the original data and schema while giving you the renamed presentation in the report. Implementation idea: create a view that selects from the Delta table and aliases each column to the desired display name, for example, SELECT original_col1 AS ReportName1, original_col2 AS Revenue_USD FROM your_delta_table. The view acts as a virtual layer that transforms the presentation without data duplication. Creating a table would duplicate data and require maintenance, while a schema or catalog is just organizational and doesn’t provide column renaming functionality.

Using a view as the presentation layer is the right approach here. A view allows you to present data with new, user-friendly column names without changing the underlying Delta table. When Power BI queries the view, it sees the aliased column names while the actual data and column names in the source remain untouched. This preserves the original data and schema while giving you the renamed presentation in the report.

Implementation idea: create a view that selects from the Delta table and aliases each column to the desired display name, for example, SELECT original_col1 AS ReportName1, original_col2 AS Revenue_USD FROM your_delta_table. The view acts as a virtual layer that transforms the presentation without data duplication. Creating a table would duplicate data and require maintenance, while a schema or catalog is just organizational and doesn’t provide column renaming functionality.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy