Learn Power BI

Blog
Practice Questions

Learn Power BI

Accelerate your Career and Get Certified

Fix performance issues

Thursday, April 1st, 2021

Welcome to your Fix performance issues

Questions are based on this module

1. Query folding allows queries

to run within Power BI rather than on the original data server

to run on the original data server rather than within Power BI

2. Process by which transformations in the Power Query editor are tracked as native queries

Direct Connect

Direct Query

Multidimensional Expressions (MDX)

Query Folding

3. Which is an example of a transformation which is supported by query folding? [select all that apply]

aggregation

changing the data type of a column

filtering

adding an index

4. Which results in better performance?

Separate date-time fields into a date field and a time field

Combining date field and a time field into a date-time field

5. Which results in better performance?

Process as much data as possible in the original data source.

Process as much data as possible in the Power BI.

6. If this option is greyed out, it indicates that query folding could not be performed

Live Connection

Extract

DirectConnect

View native query

7. If you prefer to see updates to data as soon as they happen at the cost of interactivity performance

Direct Query

Import Data

Time is Up!

Time's up

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

Leave a Reply Cancel reply