Learn Power BI

Blog
Practice Questions
Nanodegree

Learn Power BI

Accelerate your Career and Get Certified

Optimize DirectQuery models with table level storage

Wednesday, April 7th, 2021

Welcome to your Optimize DirectQuery models with table level storage

Questions are based on this module

What are reasons to use DirectQuery [select all that apply]

need for near-real time reporting

desire to handle large data without pre-aggregating

best practice to use rather than Import

Which of the following are characteristic of DirectQuery [select all that apply]

Only the schema is loaded, the source tables aren't queried until you start building a visual.

performance depends on underlying data source server

The same modeling capabilities as with when Import is used.

eliminates Power BI security concern since data is kept on the data source server

Which of the following is not a query reduction option

Add an apply button to each slicer to apply changes when you're ready

Summarize data in source before sending to Power BI

Disable cross filtering/highlighting by detail

Add an apply button to all basic filters to apply changes when you're ready

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