Power Query Editor

Question 1

You need to make changes to you data,
Which three changes are supported in the data source settings in the Power Query Interface

Answer 1

Modyfing the file path
Clearing permissions
Editing permissios

Question 2

You create a Power BI data source which uses a SQL select statemnet, it queries multiple table 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 verifiy that the source table does include data

Answer 2

Use the cast function in the sql statement

Question 3

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

Answer 3

Power query editor

Question 4

Column Quality

Answer 4

Valid
Error
Empty

Question 5

Column distribution

Answer 5

distinct
#Unique

Question 6

Column profile

Answer 6

Column Statistic
Value distribution

Question 7

You have a query that retrieves data from a table tat contains more than 8000 rows
In power query editor you notice that the column statistics for each column shows a count of exactly 1000
you need to ensure that the column statistics for each column show the statistics based on all rows that are returned by the query
what shoul you do

Answer 7

From the query window select column profiling on the entires data set

Question 8

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 do you use

Answer 8

Avanced editor in the power BI Query editor

Question 9

You have a table that contains a columns named Product ID
Ythe proudct ID column contains values that have a prefix PD followed by five numbers. For example pd15332
You plan to vonvert the product ID values to numbers
You need to remove the leading two letters form the current ID values
What do you use

Answer 9

Replace values

Question 10

You have an excel spreadsheet that contains two columns as follows
Category: name of categories
Subcategory: containe names of subctategories

The excel is imported to Power Bi Desktop

You need to transform the data to meet the followinf requierments

Have mulitple columns, where one column represents oone category
Have a single row that includes the total count of subcategories for each category

Answer 10

Pivot columns

Question 11

You connect Power query editor to a data base table
You need to remove the Row DI column. Your solution must ensure that new columns not display in the table model during a schedule refresh in the future

Answer 11

Use the select columns command and choose the columns to keep