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

level: Level 1

Questions and Answers List

level questions: Level 1

Question	Answer
You need to make changes to your data sources. Which three changes are supported by the Data Source Settings in the Power Query interface? Each correct answer presents a complete solution. Select all answers that apply. adding a column clearing permissions editing permissions renaming a column modifying the file path	clearing permissions This answer is correct. editing permissions This answer is correct. modifying the file path 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? Data view Model view Page view Report view	Model view
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 Import instead of DirectQuery? Each correct answer presents a complete solution.Select all answers that apply. full support for the Q&A Power BI service minimized local disk space usage minimized need for data refresh support for per table configuration full support for the Quick Insights Power BI service	full support for the Q&A Power BI serviceThis answer is correct. full support for the Quick Insights Power BI serviceThis answer is correct.
You have multiple Excel files stored in a folder synced with OneDrive for Business. You need to import data from the files. The solution must NOT use a data gateway. Which type of connector should you use? Select only one answer. Excel workbook Folder SharePoint folder SharePoint list	SharePoint folder This answer is correct.
You plan to publish a dataset from Power BI Desktop. You need to ensure that a server name can be changed after the dataset has been published to the Power BI Service. Which two actions should you perform? Each correct answer presents part of the solution.Select all answers that apply. Create a parameter. Create a query for the server name. From the Data source settings in Power BI Desktop, update the permissions. From the Data source settings, update the server source to use a parameter. Update the Source applied step of all related queries to reference the server name query.	Create a parameter.This answer is correct.From the Data source settings, update the server source to use a parameter.This answer is correct.
You have a query that retrieves data from a table that contains more than 8,000 rows of data. In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000. You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query. What should you do?Select only one answer. Add a Table.Buffer applied step to the query. Change the query load type from Import to DirectQuery. Create a Top N row count parameter for the query. From the query window, select Column profiling on the entire dataset.	From the query window, select Column profiling on the entire dataset.
You are analyzing query data by using Power Query Editor. You need to ensure that the Column statistics are based on an analysis of the entire dataset. What should you do? Select only one answer. Change the query connection type from Import to DirectQuery. From the status bar, change profiling status to entire dataset. In Power Query Editor, enable column profiling from the View ribbon. Load the data into the data model.	From the status bar, change profiling status to entire dataset.
You use Power BI Desktop to transform a query that retrieves data from an Excel spreadsheet. You need to view and modify multiple steps in all the M code. Which interface should you use? Select only one answer. Advanced Editor in the Power Query Editor Data view Formula Bar in the Power Query Editor Model view	Advanced Editor in the Power Query Editor
You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year. You import data from the Excel spreadsheet into Power BI Desktop. You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year. Which transformation should you use first?Select only one answer. Pivot Remove Columns Transpose Table Unpivot	Unpivot This answer is correct.
From the Power Query Editor, you import data from a .csv file. The data includes a column named ZIP that contains postal codes from the United States.You notice that Power Query Editor automatically applies the Whole Number data type to the ZIP column.You need to ensure that the ZIP column uses the Text data type and that all values remain 5 characters long.What should you do? From the data view in Power BI Desktop, change the column data type from number to text. From Power Query Editor, add a new applied step at the end of the query to convert the ZIP column from number back to text. From Power Query Editor, delete the changed type step. From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.	From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.This answer is correct.
You have a table that contains a column named ProductID. The ProductID column contains values that have a prefix of PD followed by five numbers. For example: pd15332. You plan to convert the ProductID values to numbers (integer). You need to remove the leading two letters from the current ProductID values. Which command should you use? Remove rows Replace errors Replace values Trim	Replace ValuesThis 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 connect Power Query Editor to a database table. You need to remove the Row ID column. Your solution must ensure that new columns do NOT display in the table model during a scheduled refresh in the future. What transformation should you use? Select only one answer. Select Row ID, then use the Remove Other Columns command. Use the Remove Column command on the Row ID column. Use the Select Columns command and chose the columns to keep. Use the Transpose command, then filter the rows to remove Row ID.	Use the Select Columns command and chose the columns to keep. 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. Data view Model view Power Query Editor Report view	Model view This answer is correct. Report view 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	Table Matrix
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
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1. You need to implement an incremental refresh of DS1. What should you do first?Select only one answer. In Power BI Desktop, define filter parameters. In Power BI Desktop, define the incremental refresh policy. Publish the dataset to the Power BI service. Upgrade the Power BI workspace to the Premium SKU.	In Power BI Desktop, define filter parameters.