Power BI Review

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.

• full support for the Q&A Power BI service

• full support for the Quick Insights Power BI service

• minimized local disk space usage

• minimized need for data refresh

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

• full support for the Quick Insights Power BI service

•  

  minimized local disk space usage

• minimized need for data refresh

• support for per table configuration

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?

• Excel workbook

• Folder

• SharePoint folder

• SharePoint list

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

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.

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

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

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

You have a Power BI data source that contains the following tables:

• ProductCategory: Lists the product category ID and category name

• ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID

• ProductList: Lists the product ID, name, and subcategory ID

You need to optimize the data to create a dimension for use in a star schema data model.

How should the tables be transformed before loading into the model?

Select only one answer.

• Import all three tables into the data model and connect them using relationships

• Import only the ProductName table into the model

• Merge the queries to create a single loaded table for Product

• Use the append command to create a single loaded table for product

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