Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

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 on the original data server rather than within Power BI

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

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

Direct Connect

Multidimensional Expressions (MDX)

Direct Query

Query Folding

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

aggregation

adding an index

filtering

changing the data type of a column

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 Power BI.

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

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

DirectConnect

Extract

Live Connection

View native query

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

Import Data

Direct Query

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