Prepstellar
Get the app

PL-300 · Practice set 7 of 8

Storage Modes: 10 practice questions

10 questions · Untimed · Free

10 free PL-300 practice questions on Storage Modes, with an explanation for every answer. Untimed. The full mock exam and the timed version are in the app.

Set 7 · Storage Modes · 10 questions Read the lesson

  1. Question 1 of 10

    How does Direct Lake access data for a Microsoft Fabric semantic model?

    1. AIt copies spreadsheet rows into a composite model
    2. BIt reads Delta tables directly from OneLake
    3. CIt imports data into a local model
    4. DIt sends each report query to an external SQL source
    Show the answer

    Direct Lake reads lake-native Delta tables in OneLake and avoids both a separate import and an external DirectQuery round trip; the alternatives describe other data-access patterns.

    Next → 1 / 10

  2. Question 2 of 10

    Where does a DirectQuery table obtain data when a report query runs?

    1. AFrom the underlying source through a pass-through query
    2. BFrom a complete copy cached in the Power BI model
    3. CFrom a calculated table stored without a source
    4. DFrom Delta tables read directly through Direct Lake
    Show the answer

    DirectQuery forwards report queries to the underlying source instead of answering from imported cache or using Direct Lake access to OneLake Delta tables.

    Next → 2 / 10

  3. Question 3 of 10

    What is the defining data-access behavior of Import mode?

    1. AQueries pass through to the operational source
    2. BQueries read OneLake Delta tables without import
    3. CQueries use data cached in the Power BI model
    4. DQueries require a different storage mode per visual
    Show the answer

    Import stores a local model copy optimized for analytic queries; pass-through source queries describe DirectQuery and direct OneLake Delta access describes Direct Lake.

    Next → 3 / 10

  4. Question 4 of 10

    Which freshness statement applies to an Import model?

    1. AIt reads changed Delta files directly without a refresh
    2. BIts data is current through the last successful refresh
    3. CIt sends every analytic query to the source database
    4. DIt obtains current rows through every report interaction
    Show the answer

    Imported data is a cached copy and therefore reflects the last completed refresh; interaction-time source queries and direct Delta reads belong to other modes.

    Next → 4 / 10

  5. Question 5 of 10

    What constraint applies to Power Query transformations in a DirectQuery model?

    1. AThey must convert every table into a calculated table
    2. BThey must read Delta files directly from OneLake storage
    3. CThey must translate into native queries understood by the source
    4. DThey must first copy every source table into local Power BI model memory
    Show the answer

    DirectQuery relies on source execution, so its transformations must be translatable to the source's native query language; importing, Direct Lake access, and calculated-table conversion are different patterns.

    Next → 5 / 10

  6. Keep the ones you got wrong

    In the app, every question you miss comes back exactly when you’re about to forget it.

    Get the app

  7. Question 6 of 10

    Which pair of operations does Direct Lake avoid when it reads OneLake Delta tables?

    1. AA source refresh and an in-model analytic query
    2. BA Delta table and a OneLake storage location
    3. CA separate import and an external DirectQuery round trip
    4. DA semantic model and a report visualization
    Show the answer

    Direct Lake reads the lake files directly, avoiding an imported copy and the external-source round trip associated with DirectQuery while still using OneLake Delta tables and a semantic model.

    Next → 6 / 10

  8. Question 7 of 10

    Which requirement most directly favors DirectQuery over Import?

    1. ADirect access to Delta tables already stored in OneLake
    2. BFast queries from an in-memory analytical cache
    3. CLarge fast-changing source data that should remain at the source
    4. DBroad modeling flexibility over a manageable cached copy
    Show the answer

    DirectQuery is intended for large or rapidly changing data that should not be copied locally; the other requirements align with Import or Direct Lake.

    Next → 7 / 10

  9. Question 8 of 10

    A team has a manageable source, accepts scheduled refresh, and needs the broadest modeling flexibility with fast interactive queries. Which mode fits?

    1. AUse DirectQuery and send each interaction to the source
    2. BImport the data into a cached Power BI model
    3. CUse DirectQuery to create a complete local data copy
    4. DUse Direct Lake against external relational SQL tables
    Show the answer

    Import matches an acceptable cached copy and refresh schedule while providing broad modeling capabilities and strong interactive query performance.

    Next → 8 / 10

  10. Question 9 of 10

    A large on-premises source changes rapidly, users need near-real-time results, and policy forbids copying its data. Which mode fits?

    1. ADirectQuery to the supported on-premises source
    2. BDirect Lake over Delta tables in a different OneLake store
    3. CImport with a local cached copy of the source
    4. DImport followed by deletion of the source connection
    Show the answer

    DirectQuery keeps supported source data in place and can provide near-real-time query results, matching both the volume and data-sovereignty constraints.

    Next → 9 / 10

  11. Question 10 of 10

    A Fabric team already stores its analytical data as Delta tables in OneLake and wants direct access without an imported copy or external query round trips. Which mode fits?

    1. AImport into a file and schedule periodic refresh
    2. BDirectQuery to an unrelated external SQL database
    3. CDirect Lake over the OneLake Delta tables
    4. DImport from OneLake into a separate cached copy
    Show the answer

    Direct Lake is the mode designed to read the existing OneLake Delta tables directly while avoiding both a separate import and external DirectQuery execution.

    Next → 10 / 10

  12. You’ve finished this set

    That’s 10 questions on Storage Modes. In the app the ones you miss come back exactly when you’re about to forget them.

    Back to the course Next lesson: Power Query ParametersGet the app
Keep your progress · Get the app

The whole course, on your phone

Lessons you can read, audio you can listen to on the way to work, and practice that remembers what you got wrong.

Get the app