This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What data source connection method loads all of the data into the Power BI cache, and runs queries against the ingested data?
DirectQuery.
Import Connection.
Hybrid Connection
What can be considered a benefit of materialized views?
A different data distribution compared to the base tables.
Decreased query performance for complex queries with JOINs and aggregate functions, but increased performance for simple queries.
Instant query response times for repetitive query patterns.
What is a limitation of result-set caching?
The maximum size of the result set cache is 1 TB per database.
Users cant manually empty the result set cache.
Pausing the database will clean the cache.
You must answer all questions before checking your work.
Continue
Was this page helpful?