Describe Data Visualization in Microsoft Power BI DP-900 Practice Questions (Page 6)

Questions 26–30

1. 26application · medium

   A data analyst imports a CSV file that contains a 'Date' column stored as text in the format 'DD-MM-YYYY'. The analyst wants to create a line chart that shows monthly trends. What should the analyst do in Power Query before loading the data?

   • AChange the data type of the Date column to Date using the correct locale format
   • BKeep the column as text and use it directly in the line chart
   • CSplit the Date column into three separate columns for day, month, and year
   • DCreate a calculated column in the report that parses the date
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A data analyst has a Power BI model with a 'Sales' table and a 'Date' table. The analyst wants to create a measure that calculates the total sales for the previous month. Which DAX function should the analyst use?

   • ACALCULATE with PREVIOUSMONTH
   • BDATEADD with -1 month
   • CSUM with FILTER
   • DTOTALYTD
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A retail company has a Power BI report showing monthly sales by product category. The sales manager wants to see the same report filtered to a specific region without changing the report for other users. What should the sales manager do?

   • AEdit the data model to remove other regions
   • BApply a page-level filter for the manager's region
   • CAdd a slicer for region to the report page
   • DCreate a new dashboard with a region filter
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   Which of the following is a data source that Power BI can connect to?

   • AA JPEG image
   • BA PDF document
   • CA text file in .docx format
   • DMicrosoft Excel workbook
   Reveal Solution Discussion Select an answer first
6. 30expert · hard

   A data modeler has a fact table 'Sales' and a dimension table 'Product'. The Product table has a column 'Category'. The modeler creates a measure 'Total Sales' = SUM(Sales[Amount]). When the modeler places 'Category' on a visual, the measure returns correct values. Later, the modeler adds a second fact table 'Returns' that also has a 'ProductID' column. The modeler creates a relationship between Returns and Product. Now, when the modeler places 'Category' on a visual with 'Total Sales', the numbers are still correct, but when placing 'Category' with a new measure 'Total Returns' = SUM(Returns[ReturnAmount]), the numbers are incorrect. What is the most likely cause?

   • AThe relationship between Returns and Product is inactive
   • BThe Product table has duplicate Category values
   • CThe Returns table uses a different data type for ProductID
   • DThe Returns table has no relationship to the Date table
   Reveal Solution Discussion Select an answer first