Prepstellar
Get the app

PL-300 · Practice set 5 of 8

Data Source and Semantic Model Connections: 10 practice questions

10 questions · Untimed · Free

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

Set 5 · Data Source and Semantic Model Connections · 10 questions Read the lesson

  1. Question 1 of 10

    Which source is documented as a NoSQL store containing JSON documents?

    1. ASQL Server
    2. BAzure Cosmos DB
    3. CAzure Analysis Services
    4. DAn Excel workbook file
    Show the answer

    Azure Cosmos DB stores the scenario data as JSON documents that may need expansion and normalization; SQL Server is relational, Analysis Services hosts tabular semantic models, and Excel is a file source.

    Next → 1 / 10

  2. Question 2 of 10

    Which Power BI Desktop command begins a connection to a new source?

    1. ATransform Data
    2. BClose and Apply
    3. CGet data
    4. DNavigator
    Show the answer

    Get data opens the connector choices for files, databases, services, and models; the other commands act after a query or connection already exists.

    Next → 2 / 10

  3. Question 3 of 10

    What can a published Power BI semantic model provide to another report author?

    1. AA credential type for a SQL Server connection
    2. BA SQL Server password
    3. CA JSON normalization step for Cosmos DB
    4. DA reusable source for report visualizations
    Show the answer

    A model published to a workspace supplies modeled data to reports and dashboards, allowing another author to build a report from the existing semantic model.

    Next → 3 / 10

  4. Question 4 of 10

    After connecting to a file, what is the purpose of the Navigator window?

    1. APreview and select the tables or entities to bring into Power BI
    2. BChange the source path and validate the replacement file structure
    3. CCreate a live connection and move DAX calculations into Power BI
    4. DChoose a credential provider and reset the connection permissions
    Show the answer

    Navigator exposes the available source objects so the author can inspect and select the intended data before choosing Load or Transform Data.

    Next → 4 / 10

  5. Question 5 of 10

    When should you choose Transform Data instead of Load in Navigator?

    1. AWhen the selected data needs review or preparation in Power Query
    2. BWhen the selected data must load immediately in its current state
    3. CWhen an Analysis Services model must retain a live connection
    4. DWhen the source requires a server address before authentication
    Show the answer

    Transform Data opens Power Query for cleaning and reshaping before loading; Load places the selected data into the model as it currently stands.

    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 set contains the documented SQL Server sign-in choices?

    1. ANavigator window
    2. BWindows, Connect live, and Microsoft account
    3. CWindows, Database, and Microsoft account
    4. DDatabase, Import, and Transform Data
    Show the answer

    The SQL Server connection offers Windows, Database, and Microsoft account authentication; connectivity modes and interface actions are separate decisions.

    Next → 6 / 10

  8. Question 7 of 10

    What does Connect live preserve when Power BI connects to Azure Analysis Services?

    1. AThe DAX calculations are copied while the data remains in SQL Server
    2. BThe data and DAX calculations remain in Azure Analysis Services
    3. CAn Excel copy of the model
    4. DThe data is copied locally while DAX remains in Azure Analysis Services
    Show the answer

    Connect live leaves both data and model calculations in Azure Analysis Services, unlike Import, which brings data into Power BI.

    Next → 7 / 10

  9. Question 8 of 10

    A local Excel source was moved during development, but its columns are unchanged. What should the report author do?

    1. AUse Data source settings, choose Change Source, and update the file path
    2. BUse Get data, choose Analysis Services, and enter the workbook database name
    3. CUse Connect live, choose the Excel connector, and retain the old path
    4. DUse Navigator, choose Transform Data, and rename the existing model columns
    Show the answer

    A location change is handled through Change Source in Data source settings; preserving the file structure prevents the existing reporting model from breaking.

    Next → 8 / 10

  10. Question 9 of 10

    A team wants Power BI reports to use an Azure Analysis Services model and reflect its refreshes without scheduling a separate Power BI refresh. Which connection fits?

    1. ATransform the model into JSON records before loading it
    2. BImport into Power BI
    3. CLoad the model through Navigator as a local Excel source
    4. DConnect live to the Analysis Services model
    Show the answer

    A live connection leaves data and calculations in Azure Analysis Services, so model refreshes are reflected in the report without a Power BI refresh schedule.

    Next → 9 / 10

  11. Question 10 of 10

    A report author needs calculations already maintained in a model created by another team. What should the author identify as the reusable source?

    1. AThe team's published semantic model
    2. BThe team's SQL Server credential type
    3. CA local file path
    4. DThe team's Navigator preview selection
    Show the answer

    A published semantic model is the reusable analytical asset that can expose existing tables and calculations to another report author.

    Next → 10 / 10

  12. You’ve finished this set

    That’s 10 questions on Data Source and Semantic Model Connections. In the app the ones you miss come back exactly when you’re about to forget them.

    Back to the course Next lesson: Data Source Settings and PrivacyGet 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