2. Prepare data for analysis in power BI

Question 1

Native query relies on query folding?

Yes
No

Answer 1

Yes

Question 2

By default data preview analyzes 5000 in the data state

1. True
2. False

Answer 2

2. flase its 1000

Question 3

1. Merge -Combine two tables with a similar column
2. Append / Combine two tables with the same schema
3. 1 true true
4. 1. false 2 false

Answer 3

1. true 2. true

Question 4

What is data profiling (in power Query M function) that gives you a table and gives all of those columns and date profiling info of those columns

1.new query
2. table.profile
3. columm quality
4. column distribution

Answer 4

2. table profile

Question 5

You should use grouping with the list type to combine distinct categories of data or list of categories into larger categories

True or False

Answer 5

True

Question 6

Bining is similar to grouping, but it is used to grouping to continous fields such numbers and dates

True or false

Answer 6

True