You are in browse mode. You must login to use MEMORY

level: Assessment-5

Questions and Answers List

level questions: Assessment-5

Question	Answer
You have a Power BI Desktop dataset that includes a table named Employees containing a row for each employee with the following columns:Employee IDEmployee NameManager IDManager NameYou need to flatten the parent-child hierarchy in the Employees table by adding an extra column that will contain a listing of employee IDs for all direct and indirect managers of each employee.Which two Data Analysis Expression (DAX) functions should you use? Each correct answer presents part of the solution. PATHITEM CROSSJOIN PATHCROSSJOIN EXCEPT PATHITEM EXCEPTPATH RELATED	EXCEPTPATH This answer is correct. PATHITEM CROSSJOIN This answer is correct.
You are creating a report in a Power BI Desktop by using a dataset that contains sales data. You need to create a measure that always provides the value of total sales for the year 2022, regardless of which year is selected in any visual in the same report. Which DAX function should you use in combination with the SUM function to override the context and provide the result? Select only one answer. CALCULATE FILTER IGNORE SUMX	CALCULATE
You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace.What should you do first?Select only one answer. Open See Related Content. Open the File menu. Select Add a tile. Select Ask a question about your data.	Select Ask a question about your data. This answer is correct.
You have a Power BI dataset.You need to set the dataset as discoverable.Which two configurations will allow the dataset to be marked as discoverable? Each correct answer presents a complete solution.Select all answers that apply. Certify the dataset. Enable RLS on the dataset. Promote the dataset. Publish dataset to a Premium workspace.	Certify the dataset. This answer is correct. Promote the dataset. This answer is correct.
You have several on-premises Microsoft SQL Server databases. You need to provide Power BI Service users access to the data sources without exposing the database servers directly to the internet. The solution must minimize the configurations that must be performed by each user. What should you deploy?Select only one answer. a virtual network data gateway an ExpressRoute connection an on-premises data gateway an on-premises data gateway (personal mode)	an on-premises data gateway This answer is correct.
You need to create a bookmark that toggles the visibility of a visual. This bookmark must only toggle the visibility state and perform no other action. Which three configurations should you make? Each correct answer presents part of the solution.Select all answers that apply. Disable the Current Page option. Disable the Display option. Enable the Current Page option. Enable the Data option. Enable the Display option. Disable the Data option.	Disable the Data option. This answer is correct. Disable the Current Page option. This answer is correct. Enable the Display option. This answer is correct.
You need to use DAX quick measures to generate results to use in a report.Which type of DAX quick measure calculations will NOT work against a DirectQuery table? Select only one answer. aggregate per category mathematical operations time intelligence X-functions	time intelligence This answer is correct.
You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields: Reading Time (datetime) DateKey (date) LocationKey (whole number) Temp C (decimal) You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships. You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location. What two actions should you perform? Each correct answer presents part of the solution.Select all answers that apply. Create a column that contains the time values for the start of the hour of the Reading Time value. Disable the query load on the Temperatures query in the Power Query Editor. Remove the rows that occur exactly at 0 minutes and 0 seconds on the hour. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row. Use the Group By functionality to aggregate the rows by DateKey, Reading Time, and LocationKey and then create a max Temp C value per row.	Create a column that contains the time values for the start of the hour of the Reading Time value. This answer is correct. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row. This answer is correct.
You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals. You plan to use Performance Analyzer to evaluate the performance of the visuals. You need to eliminate the impact of visual caching during the evaluation. What should you do first?Select only one answer. Add a blank page to the PBIX file. Connect DAX Studio to the data model. Reopen the PBIX file. Start recording.	Add a blank page to the PBIX file. This answer is correct.
From Power BI Desktop, you create a data source by importing an Excel file. You plan to identify data anomalies within the data source. Which interface should you use to display the column distribution and column quality graphs?	Power Query Editor This answer is correct.
You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month. You need to reshape the table to have all sales amount values in a single column. A new column should also be added and contain the relevant month year for each row of data. What should you do from the Power Query Editor?	Select the Country column and then select Unpivot Other Columns. This answer is correct.
You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into Power BI Desktop. You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort. What should you do?	Add a separate date dimension table. This answer is correct.
You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson’s Microsoft Entra ID account. You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name. Which two actions should you perform? Each correct answer presents part of the solution.	Add a DAX expression filter to the Salesperson table. This answer is correct. Create a role. This answer is correct.
You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report. In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.	as a filter in the “Filters on this page” well of the Filters pane This answer is correct. as an item in the Fields well of a slicer This answer is correct.
In Power BI Desktop, you need to create a measure. Which two interfaces can you use? Each correct answer presents a complete the solution.	Data view This answer is correct. Report view This answer is correct.
You need to enhance a data model by using Power BI Desktop. Data for which two model items can be created using the DAX language? Each correct answer presents a complete solution.	calculated table This answer is correct. numeric range parameter This answer is correct.
You need to use DAX quick measures to generate results to use in a report. Which type of DAX quick measure calculations will NOT work against a DirectQuery table?	time intelligence This answer is correct.
You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields: Reading Time (datetime) DateKey (date) LocationKey (whole number) Temp C (decimal) You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships. You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location. What two actions should you perform? Each correct answer presents part of the solution.	Create a column that contains the time values for the start of the hour of the Reading Time value. This answer is correct. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row. This answer is correct.
You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals. You plan to use Performance Analyzer to evaluate the performance of the visuals. You need to eliminate the impact of visual caching during the evaluation. What should you do first?	Add a blank page to the PBIX file. This answer is correct.
You need to create a bookmark that toggles the visibility of a visual. This bookmark must only toggle the visibility state and perform no other action. Which three configurations should you make? Each correct answer presents part of the solution.	Disable the Data option. This answer is correct. Disable the Current Page option. This answer is correct. Enable the Display option. This answer is correct.
You need to create a histogram that will display ranges of integers in groups. Which two resources do you need to create the histogram? Each correct answer presents part of the solution.	a Bin group type This answer is correct. a Numerical column This answer is correct.
You need to create a visual that will display information on a continuous axis. Which two data types can be used to display a continuous axis on a visual? Each correct answer presents a complete solution.	Date This answer is correct. Decimal Number This answer is correct.
You are creating a Power BI dashboard. You need to apply a custom theme to the dashboard from another Power BI dashboard theme. Which type of file should you use?	JSON This answer is correct.
You need to assign an app workspace role for users who consume reports. Users should only have permissions to examine the report. Which role should you assign to users?	Viewer role This answer is correct.
You have several on-premises Microsoft SQL Server databases. You need to provide Power BI Service users access to the data sources without exposing the database servers directly to the internet. The solution must minimize the configurations that must be performed by each user. What should you deploy?	an on-premises data gateway This answer is correct.
You are designing a data model for Power BI Desktop. You need to reduce the model size. Which technique should you use to reduce the model size? Select only one answer. Configure the Query reduction option Filters settings. Set the Storage Mode property of tables to Direct Query. Configure the Query reduction option Slicers settings. Set the Storage Mode property of tables to Import.	Set the Storage Mode property of tables to Direct Query. This answer is correct.
You decide to remove unnecessary columns from your data model. What are two potential performance benefits of doing this? Each correct answer presents a complete solution. increasing the refresh speed decreasing report page load times increasing DAX performance reducing the size of the data model	increasing the refresh speed This answer is correct. reducing the size of the data model This answer is correct.
You need to create a dashboard from a published report in Power BI. Which option in the report should you use? Select only one answer. Copy visual as image Export data Pin visual Spotlight	Pin visual This answer is correct.
You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety of reports.Which three objects from a report page can be pinned to the dashboard?Select all answers that apply. Custom visual Filter Image Ribbon chart Slicer	Custom visual This answer is correct. Image This answer is correct. Ribbon chart This answer is correct.
You manage a Power BI workspace. You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege. Which role should you use? Admin Contributor Member Viewer	Admin This answer is correct.
You need to create a visual that will display information on a continuous axis. Which two data types can be used to display a continuous axis on a visual? Each correct answer presents a complete solution. Select all answers that apply. Binary Date Decimal Number Text	Date Decimal Number
From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows. You plan to identify data anomalies within the data source. You need to ensure that column distribution considers all rows in the Excel file. What should you do?Select only one answer. In the Data Source Settings, modify the Advanced settings. In the Data Source Settings, modify the Edit Permissions settings. In the Power Query Editor window, enable the Column Profile view. In the Power Query Editor window, modify the Query Settings.	In the Power Query Editor window, enable the Column Profile view. This answer is correct.
From Power BI Desktop, you create a data source by importing an Excel file. You plan to identify data anomalies within the data source. Which interface should you use to display the column distribution and column quality graphs?Select only one answer. Advanced Editor in Power Query Editor Power Query Editor the Data view the Model view	Power Query Editor