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

level: Assessment-3

Questions and Answers List

level questions: Assessment-3

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 This answer is correct. SharePoint – Team Sites This answer is correct.
You have a Power BI dataset that gets data from a table in a SQL Server database. From which view in Power BI Desktop can you modify the storage mode of the table? Select only one answer. Data view Model view Page view Report view	Model view This answer is correct.
You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using DirectQuery instead of Import? Each correct answer presents a complete solution. Select all answers that apply. minimized local disk space usage full support for the Q&A Power BI service full support for the Quick Insights Power BI service minimized need for data refresh	minimized local disk space usage This answer is correct. minimized need for data refresh This answer is correct.
When importing data from an Excel workbook into Power BI, you receive the error message: “We couldn't find any data formatted as a table.” What should you do to resolve the error? Select only one answer. In the Excel workbook, select the data you want to import, select the Data Validation button, and save the change. In the Excel workbook, select the data you want to import, create a table, and save the change. In Power BI, add a template app. In Power BI, add an organizational app.	In the Excel workbook, select the data you want to import, create a table, and save the change. This answer is correct.
You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. After you import data from the data source into Power BI, you notice that one of the columns in the resulting dataset appears blank. You verify that the source table does include data. What should you do to resolve the issue? Select only one answer. Clear permissions on the data source in Power BI. Use the CAST function in the SQL statement. Use the DATALENGTH function in the SQL statement. Set the privacy levels on the data source.	Use the CAST function in the SQL statement. This answer is correct.
You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query Editor. You need to identify outliers in a text column within the data source. Which information should you use from Power Query Editor? Select only one answer. the min and max values in Column profile the top and bottom entries in Value distribution the value of the Distinct entry in Column statistics the value of the Unique entry in Column statistics	the top and bottom entries in Value distribution 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 only one answer. Select the Country column and then select Pivot Column. Select the Country column and then select Unpivot Other Columns. Select the first sales data column and then select Unpivot Columns. Select Transpose.	Select the Country column and then select Unpivot Other Columns. This answer is correct.
From Power BI Desktop, you create a data source by importing a Cosmos DB for NoSQL item collection. You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record. You need to select individual fields from items in the collection that you want to load into Power BI Desktop. What should you do first? Open Power Query Editor. Retrieve the Cosmos DB account key. Retrieve the Cosmos DB connection string. Switch to the model view.	Open Power Query Editor. This answer is correct.
You have an Excel spreadsheet that contains two columns as follows: Category: Contain names of categories Subcategory: Contain names of subcategories for each category You import the Excel spreadsheet into Power BI Desktop. You need to transform the data to meet the following requirements: Have multiple columns, where one column represents one category Have a single row that includes the total count of subcategories for each category Which transformation should you use? Pivot Columns Unpivot Columns Rename Columns Transpose Columns	Pivot 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. Add a year, month, and week columns to the fact table. Enable the Auto date/time current file option. Enable the Auto date/time global option.	Add a separate date dimension table. This answer is correct.
You have an Azure SQL database that contains two tables named SalesOrders and SalesOrderDetails. You load the SalesOrders and SalesOrderDetails tables into Power BI Desktop. The tables have a relationship based upon the SalesOrderID column. You need to combine the two tables into one table. The solution must meet the following requirements: There is a row for every SalesOrderDetails row in the resulting table, even if there is no corresponding SalesOrders row. For every SalesOrderDetails row, the row in the resulting table includes the corresponding SalesOrders row data if the SalesOrder row exists. Any SalesOrder row data that does not have corresponding SalesOrderDetails rows is not included in the resulting table. What should you do to combine the two tables? Append the tables. Merge the tables using the left outer join kind based on the sales order id. Merge the tables using the full outer join kind based on the sales order id. Merge the tables using the inner join kind based on the sales order id.	Merge the tables using the left outer join kind based on the sales order id. This answer is correct.
You need to create a Power BI dashboard. Which tool should you use? Select only one answer. Power BI Desktop Power Query Editor the Power BI mobile app the Power BI service	the Power BI service This answer is correct.
You are evaluating whether you need to create a dashboard in Power BI. In which scenario do you need a dashboard instead of a report in Power BI? Select only one answer. You need to add filters. You need to add slicers. You need to display visuals on multiple pages. You need to display visuals that use different datasets.	You need to display visuals that use different datasets. This answer is correct.
You plan to build a Power BI dashboard and set up alerts that will notify you when data presented in the visuals on the dashboard reach specific thresholds. Which three types of visuals support the alert functionality? Each correct answer presents a complete solution. Select all answers that apply. card gauge KPI treemap waterfall	card This answer is correct. gauge This answer is correct. KPI This answer is correct.
You upload reports to the Power BI service and pin several visuals to a dashboard. You plan to create alerts rules for several visuals. What are two locations you can view the alerts? Each correct answer presents a complete solution. Select all answers that apply. a report an email Microsoft Teams the Notification Center	an email This answer is correct. the Notification Center This answer is correct.
You plan to create a Power BI workspace. You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created. Which setting should you configure when creating the workspace? Select only one answer. Allow contributors to update the app Develop a template app License mode Workspace OneDrive	Workspace OneDrive 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 manage a Power BI workspace. You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege. Which role should you use? Select only one answer. Admin Contributor Member Viewer	Contributor This answer is correct.
You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day? Select only one answer. 1 8 16 48	48 This answer is correct.
You plan to use Power BI Desktop to create a report with multiple visualizations. You need to create a visual that supports the following: filters other visuals on the same report page allows users to search for values by which to filter the other visuals Which type of visualization should you use? Funnel Matrix Scatter chart Slicer	Slicer This answer is correct.
You plan to create a report in Power BI Desktop. You need to create a visualization that displays data in two or more dimensions and cross-highlights with other visuals on the same report page. Which type of visualization should you use? Select only one answer. Card matrix scatter table	matrix This answer is correct.
You plan to create a report in Power BI Desktop. You need to identify the type of visualization that displays data as a set of nested rectangles. Which visualization should you use? Select only one answer. bar chart column chart slicer treemap	treemap This answer is correct.
You need to create a custom R visual by using Power BI Desktop. What do you need to do first? Select only one answer. Configure global R scripting options in Power BI Desktop. Enable preview features in Power BI Desktop. Enable the script visuals option in the Visualization pane of Power BI Desktop. Install R on your computer.	Install R on your computer. This answer is correct.
You need to create a custom Python visual by using Power BI Desktop. What do you need to do first? Select only one answer. Configure global Python scripting options in Power BI Desktop. Enable preview features in Power BI Desktop. Enable the script visuals option in the Visualization pane of Power BI Desktop. Install Python on your computer.	Enable the script visuals option in the Visualization pane of Power BI Desktop. This answer is correct.
You are editing a report in Power BI Desktop. You need to adjust the behavior of the report by editing interactions. Which two types of interaction behavior can you change between visuals? Each correct answer presents a complete solution. Select all answers that apply. drillthrough expand filter highlight	filter This answer is correct. highlight This answer is correct.
You need to create a visual that displays sales by employees, trending over months. The visual must clearly show how employees are performing against each other and have a ranking for each period. Which visual should you use? Select only one answer. clustered bar chart ribbon chart scatterplot treemap	ribbon chart 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. 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. 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]. This answer is correct. 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.
You plan to build a Power BI report and set up conditional formatting of data fields. You need to identify two visuals that support the conditional formatting functionality. Which two types of visuals should you identify? Each correct answer presents a complete solution.Select all answers that apply. gauge matrix scatter chart table treemap	matrix This answer is correct. table This answer is correct.
You have a bar chart and column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value. Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data? Select only one answer. expand drillthrough filter highlight	filter 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 filtered (cross-highlighted) data the un-filtered (non-cross-highlighted) total data	the filtered (cross-highlighted) data This answer is correct.
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 This answer is correct. Numeric 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. Select all answers that apply. a Bin group type a Date/time column a List group type a Numerical column	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. Select all answers that apply. Binary Date Decimal Number Text	Date This answer is correct. Decimal Number This answer is correct.
You create a Power BI Desktop dataset by importing and transforming a data source based on multiple tables in a SQL Server database. You need to modify the relationship between the tables. Which interface should you use in the Power BI Desktop? Select only one answer. Data view Model view Page view Report view	Model view 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. Disable Make this relationship active for both relationships. Enable Apply security filter in both directions for both relationships. Enable 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.
You need to create a new hierarchy in Power BI Desktop. What should you do first? Select only one answer. From the Model view, drag-and-drop one column onto another column in the Fields pane. From the Model view, right-click and select Create hierarchy. From the Report view, drag-and-drop one column onto another column in the Fields pane.	From the Model view, right-click and select Create hierarchy. 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. Select all answers that apply. as a filter in the “Filters on this page” well of the Filters pane as a filter in the “Filters on this visual” well of the Filters pane as an item in the “Add drill-through fields here” well of the Visualizations pane as an item in the Fields well of a slicer	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.
You need to create a row level security (RLS) role for a dataset. What should you do first? Select only one answer. Assign workspace members to the security group in the Power BI service. In Power BI Desktop, open Manage roles. In Power BI Desktop, open the Advanced Editor in the Power Query Editor. In the Power BI service, open the security settings for the dataset.	In Power BI Desktop, open Manage roles. 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. Select all answers that apply. Report view Model view Page view Power Query Editor Data view	Data view Report view
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 have a Power BI Desktop model. You need to determine when to use implicit and explicit measures. What is a feature of an implicit measure that explicit measure does NOT have? Select only one answer. End-users can change the aggregation type of implicit measure from the Values well of a visual. Implicit measures can be used as a Drillthrough field. Implicit measures can be used to create Quick measures. Implicit measures can be used with Field Parameters.	End-users can change the aggregation type of implicit measure from the Values well of a visual. 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.
You plan to optimize the performance of Power BI Desktop queries against a remote data source. You need to disable the default behavior that automatically applies cross highlighting and filtering of visuals within the same report. Which option should you configure in Power BI Desktop? Select only one answer. the Filters Query reduction settings the Persistent filters of Report settings the Reduce number of queries sent by Query reduction setting the Slicers Query reduction settings	the Reduce number of queries sent by Query reduction setting 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. Configure the Query reduction option Slicers settings. Set the Storage Mode property of tables to Direct Query. Set the Storage Mode property of tables to Import.	Set the Storage Mode property of tables to Direct Query. This answer is correct.
You have Power BI Desktop. You need to determine query timings for a report page visual. Which method should you use? Select only one answer. Refresh the data model. Run the Best Practices analyzer in Tabular Editor. Use Session Diagnostics from the Power Query Editor. Use the Performance analyzer.	Use the Performance analyzer. This answer is correct.