Step2Study

Microsoft Certified: Power BI Data Analyst Associate practice questions

204 free questions with answers and explanations.

Practice test
  1. 201.A data modeler is optimizing a Power BI model for an e-commerce platform. The 'Sales' fact table has millions of rows and includes 'ProductID', 'CustomerID', and 'OrderDate'. The 'Product' dimension table contains 'ProductID', 'ProductName', 'Category', and 'SubCategory'. The 'Customer' dimension table contains 'CustomerID', 'CustomerName', 'Region', and 'Country'. The model currently uses a standard star schema with direct relationships. The modeler observes slow performance when filtering sales data by 'Category' and 'SubCategory' combined. To improve performance, the modeler decides to denormalize the 'Sales' fact table. Which columns should the modeler consider adding to the 'Sales' fact table during denormalization to directly address the observed performance issue?Model the data
  2. 202.A data analyst has developed a Power BI report that sources data from an on-premises SQL Server database. The report is published to a Power BI workspace. To ensure that users can view the latest data in the report, which component must be installed and configured in the on-premises network?Deploy and maintain assets
  3. 203.A data analyst is developing a Power BI model for a retail company. The model includes a 'Sales' table with 'SaleAmount' and 'OrderDate', and a 'Date' table marked as a date table. The analyst needs to create a measure that calculates the 'Sales Growth Percentage' compared to the previous month. The calculation should be `(Current Month Sales - Previous Month Sales) / Previous Month Sales`. Which DAX expression correctly calculates the 'Sales Growth Percentage'?Model the data
  4. 204.A data modeler is optimizing a Power BI model for a large enterprise. The model contains a 'Sales' fact table and several dimension tables, including 'Product', 'Customer', and 'Date'. The 'Sales' table has millions of rows and includes both 'OrderQuantity' and 'UnitPrice' columns. The modeler needs to calculate 'LineTotal' for each row in the 'Sales' table, which is the product of 'OrderQuantity' and 'UnitPrice'. This calculation will be used frequently in various reports and needs to be highly performant. Which of the following DAX approaches is the most efficient and recommended for calculating 'LineTotal' directly within the 'Sales' table?Model the data