Power BI Certification Exam Review | With Questions & Answers (Rated 100%)

Power BI Certification Exam Review | With Questions & Answers (Rated 100%) Power BI Certification Exam Review | With Questions & Answers (Rated 100%) 1. A data model has a fact table that has over 15 million rows. There is a date/time column called DateTime, which contains both date and time. You need to reduce the size of the data model. Your solution must preserve as much of the original data as possible. Which solution should you implement? A. Change the data type of the DateTime column to Text. B. Clean the DateTime column. C. Split the DateTime column into two separate columns: one column that contains dates, and one column that contains the time portion. D. Change the data type of the DateTime column to Date - ANSWER - C. Split the DateTime column into two separate columns: one column that contains dates, and one column that contains the time portion You create a visual that is supposed to show revenue by year. You use the Year column from the Calendar table and the Revenue measure from the Sale table. The formula of the Revenue measure is as follows: Revenue = SUM(Sale[Total Including Tax]) The result is shown in Figure 2-31. After checking data, you can see that in 2021, revenue was million. +ow can you fix the visual" 7he solution must use the minimum amount of DAX and ensure that the Calendar table can be used with other fact tables. The solution must also take into account that you may be interested in analyzing other measures based on the Sale table. FIGURE 2-31 Revenue by Year A. Use the TREATAS function in DAX. B. Create an active relationship between the Calendar and the Sale tables. C. Merge the Sale and Calendar tables. D. Create a calculated table that calculates revenue for each year. - ANSWER - B. Create an active relationship between the Calendar and the Sale tables. 7here are two roles in a data model: &entral5egion, which filters the 5egion table to only show the &entral region, and $ppliances'epartment, which filters the 'epartment table to only show the Appliances department. A user is a member of both roles. What will they see in a sales report? A. Sales from the Central region or the Appliances department; they will see all departments in the Central region and all regions in the Appliances department. B. Sales from the Central region and the Appliances department; they will only see the Appliances department within the Central region. C. Only one role will be applied, whichever was configured first. D. The user will see an error message. - ANSWER - A. Sales from the Central region or the Appliances department; they will see all departments in the Central region and all regions in the Appliances department. 4. Your Date table currently consists only of one column called Date, which contains dates. You need to add a column to the Date table that shows month and year in the MMMM YYYY format, e.g., May 2022. What should you do? Your solution must require the minimum amount of effort and storage, and the solution must ensure that the values are sorted chronologically. A. Create a calculated column that uses the FORMAT function. B. Create a calculated column that uses the EOMONTH function format as MMMM YYYY. C. Duplicate the Date column and apply a custom format string. D. Create a new calculated table called Date - MMMM YYYY and format as MMMM YYYY. - ANSWER - B. Create a calculated column that uses the EOMONTH function format as MMMM YYYY.