Which of the following sources contains sites, document libraries, and folders?
SharePoint Online
Microsoft Dataverse
Power BI Libraries
Filing Cabinets
Answer is SharePoint Online
SharePoint Online organizes information into sites, document libraries, folders, and files within folders.
Question 32
The primary data preparation tool in Power BI is called what?
Report editor
Power Query editor
Data editor
Answer is Power Query editor
Question 33
The process of shaping data by converting your flat data into a table that contains an aggregation value for each unique value in a column is called what?
Group by columns
Pivot (pivoting a column)
Manage aggregations
Answer is Pivot (pivoting a column)
Question 34
What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.
Deleting unnecessary rows and columns can damage the structure of the data model.
Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.
Answer is Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.
Question 35
How many rows does Power Query scan to detect the type of data in the columns?
10,000
1,000
100
Answer is 1,000
Question 36
Data profiling is defined as what?
Aggregating columns containing numeric data
Studying the nuances of the data
Data modeling
Answer is Studying the nuances of the data
Question 37
What is the risk of having null values in a numeric column?
DAX expressions that MAX data will be incorrect
DAX expressions that SUM data will be incorrect
DAX expressions that AVERAGE data will be incorrect
Answer is DAX expressions that AVERAGE data will be incorrect
Question 38
What is not a best practice for naming conventions in Power BI?
Rename columns to have spaces in them
Replace values that have integers with human readable results
Abbreviated column names
Answer is Abbreviated column names
Question 39
What functionality lets you see the code that is generated as part of each transformation step?
Advanced editor
Data profiling
Queries pane
Answer is Advanced editor
Question 40
If you have two queries that contain different data with the same structure, and you want to combine them into one query, which operation should you perform?