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

level: Assessment-4

Questions and Answers List

level questions: Assessment-4

Question	Answer
You plan to get data for a Power BI dataset from flat files. You need to select a location for the files. The location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365 credentials. Which two location types should you recommend? Each correct answer presents a complete solution. Select all answers that apply. local file OneDrive for Business Personal OneDrive account SharePoint – Team Sites	OneDrive for Business SharePoint – Team Sites
You have a query named FactSales that retrieves data from a SQL Server table. You need to update the query to prevent new columns that may be added to the table in the future from getting imported during dataset refreshes. You select the existing columns in the query. Which two applied steps can you use in Power Query Editor to achieve the goal? Each correct answer presents a complete solution. Select all answers that apply. Choose Columns Remove Columns Transpose Remove Other Columns	Choose Columns This answer is correct. Remove Other Columns This answer is correct.
You implement the Q&A feature in a report, so users can get answers to their questions on their own. You need to improve your Q&A search capabilities for end-users. Which two configurations can you add? Each correct answer presents a complete solution. Select all answers that apply. Add synonyms to model fields. Configure the dataset as a composite model. Organize the dataset columns and measures into logical folders in the Fields pane. Add a linguistic schema to the dataset.	Add a linguistic schema to the dataset. This answer is correct. Add synonyms to model fields. This answer is correct.
From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate. You add a button to the Main page for navigation. You need to implement a solution that meets the following requirements: The navigation destination must change based on the output of a DAX measure named [Error Rate]. If [Error Rate] is greater than 5%, the button must display the text “Error Rate” and navigate to the Error Rate page. Otherwise, the button must display the text “On-time Rate” and navigate to the On-Time Rate page. What three actions should you perform? Each correct answer presents part of the solution.Select all answers that apply. Set the button type to Page Navigation and then use conditional formatting to specify the destination. Set the button type to Bookmark and then use conditional formatting to specify the destination. Set the navigation destination to the Error Rate page. Use conditional formatting to set the button text. Create a DAX measure that outputs the correct page name based on the value of [Error Rate].	Set the button type to Page Navigation and then use conditional formatting to specify the destination. This answer is correct. Use conditional formatting to set the button text. This answer is correct. Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. This answer is correct.
You are using Power BI Desktop to edit a stacked column chart that displays gross sales data with a date hierarchy that contains year, quarter, month, and day. You need to prevent users from viewing the hierarchy based on the year. What should you do? Select only one answer. In the Filters pane, add a filter based on the quarter, month, and day. In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis. In the Filters pane, add a filter based on the year. In the Format pane, modify the Maximum Range setting.	In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis. This answer is correct.
You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip? Select only one answer. a report page tooltip with cross-highlighted data both the un-filtered and filtered (cross-highlighted) data the un-filtered (non-cross-highlighted) total data the filtered (cross-highlighted) data	the filtered (cross-highlighted) data This answer is correct.
You have a Power BI report that uses a dataset that is imported from a database.You add a slicer to a report.You need to sync the slicer to use it on other report pages.What is required to sync slicers between report pages? Each slicer must be the same slicer type. Each slicer must be visible. Each slicer must use the same column. Each slicer must have the same title.	Each slicer must use the same column.
You plan to use Power BI Desktop to analyze sales data of your company. You need to identify two types of data you will be able to use for creating bins that group the sales data. Which two data types should you identify? Each correct answer presents a complete solution. Select all answers that apply. Binary Date/time Numeric Text True/false	Date/time Numeric
You need to create a report in Power BI Desktop that will display the sales data of your company such that customers of a similar age will be grouped into clusters. Which visual should you add to the report? Select only one answer. card gauge scatter treemap	scatter
Which native AI visual helps explain correlations for a metric within the dataset?	Key influencers visual 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?	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 plan to certify a Power BI dataset. You need to identify at which level within your organization the permissions to certify a dataset are assigned. Which level should you identify? Select only one answer. Dataset Tenant Workbook Workspace	Tenant This answer is correct.
Your company has a SharePoint server located in a datacentre in Montreal. You plan to create a report in the Power BI service that will use Microsoft Excel files stored on the SharePoint server. You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily. What should you include in the recommendation?Select only one answer. a Point to Site virtual private network (VPN) a Site-to-Site virtual private network (VPN) an on-premises data gateway Azure Data Box	an on-premises data gateway This answer is correct.
You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule a refresh of DS1. What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule? Select only one answer. 2 4 16 64	4 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.Select all answers that apply. Add a calculated column to the Salesperson table. Create a role. Add a conditional column to the Salesperson table. Add a DAX expression filter to the Salesperson table. Create a what-if parameter.	Add a DAX expression filter to the Salesperson table. This answer is correct. Create a role. This answer is correct.
You have a fact table that contains sales data and the following two date columns: OrderDate ShipDate Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates. You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships. What should you do?Select only one answer. Enable Apply security filter in both directions for both relationships. Enable Make this relationship active for both relationships. Disable Make this relationship active for both relationships. Set the cross-filter direction to both for each relationship.	Disable Make this relationship active for both relationships. This answer is correct.
In Power BI Desktop, you need to create a role. Which two interfaces can you use? Each correct answer presents a complete solution. Select all answers that apply. Data view Model view Page view Power Query Editor Report view	Model view This answer is correct. Report view This answer is correct.
You need to create a row level security (RLS) role for a dataset. What should you do first?	In Power BI Desktop, open Manage roles.
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 plan to run Power BI Desktop Performance Analyzer. You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop. What should you do first? Select only one answer. Add a blank page to the .pbix file and select it. Connect DAX Studio to the data model. Invoke the Clear Cache function. Invoke the Refresh Metadata function.	Connect DAX Studio to the data model. This answer is correct.