PART 2-PL-300-Power BI Data Analyst Associate (Intermediate LV1)

81.1- HOTSPOT - You have a Power BI data model that contains a table named Stores. The table has the following columns: • Store Name • Open Date • Status • State • City You need to create a calculated column named Active Store Name that meets the following requirements: • When the value of the Status column is “A”, the value in the Store Name column must be returned. • When the value of the Status column is NOT “A”, the value in the Store Name column that is prefixed with "Inactive - " must be returned. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 1- BOX 1

• 1- IF
• 1- SWITCH
• 1- TRUE

81.2- HOTSPOT - You have a Power BI data model that contains a table named Stores. The table has the following columns: • Store Name • Open Date • Status • State • City You need to create a calculated column named Active Store Name that meets the following requirements: • When the value of the Status column is “A”, the value in the Store Name column must be returned. • When the value of the Status column is NOT “A”, the value in the Store Name column that is prefixed with "Inactive - " must be returned. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 2- BOX 2

• &
• &&
• +

82- You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

• A. Apply a transformation to extract the first 11 characters of the logged column.
• B. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
• C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
• D. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date

83- From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in the query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns. Does this meet the goal?

• A. Yes
• B. No

84- You have a Power BI model that contains a table named Employee. The table contains the following data Each employee has one manager as shown in the ParentEmployeeID column. All reporting paths lead to the CEO at the top of the organizational hierarchy. You need to create a calculated column that returns the count of levels from each employee to the CEO. Which DAX expression should you use?

• A. PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))
• B. PATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER)
• C. PATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1)
• D. PATH(Employee[EmployeeID],Employee[ParentEmployeeID])

85- You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?

• A. Replace the default visuals with AppSource visuals.
• B. Remove unused columns from tables in the data model
• C. Change the imported dataset to DirectQuery
• D. Increase the number of times that the dataset is refreshed

86- You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

• A. Change the data type of the Logged column to Date
• B. Split the Logged column by using at as the delimiter.
• C. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number
• D. Apply the Parse function from the Date transformations options to the Logged column.

87.1- HOTSPOT - You have the Power BI data model shown in the following exhibit. - You need to create a measure to count the number of product categories that had products sold during a selected period. - How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point 1- BOX 1

• Distinctcount('Product'[ProductCategory],
• COUNT('Product'[ProductCategory]),
• DISTINCTCOUNT('Sales'[ProductID]),
• SUM('Sales'[SalesQuantity]),

87.2- HOTSPOT - You have the Power BI data model shown in the following exhibit. - You need to create a measure to count the number of product categories that had products sold during a selected period. - How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point 2- BOX 2

• 'Sales'
• 'Product'
• 'Product'[ProductCatagogy]
• 'Date'

88- You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?

• A. Enable visual interactions.
• B. Change any DAX measures to use iterator functions.
• C. Implement row-level security (RLS).
• D. Remove unused columns from tables in the data model.