Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

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]

desire to handle large data without pre-aggregating

need for near-real time reporting

best practice to use rather than Import

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

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

performance depends on underlying data source server

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

The same modeling capabilities as with when Import is used.

Which of the following is not a query reduction option

Disable cross filtering/highlighting by detail

Summarize data in source before sending to Power BI

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

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

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Δ

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

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC