Prepstellar
Get the app

PL-300 · Practice set 6 of 8

Data Source Settings and Privacy: 10 practice questions

10 questions · Untimed · Free

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

Set 6 · Data Source Settings and Privacy · 10 questions Read the lesson

  1. Question 1 of 10

    Which Power BI Desktop command opens the list of existing source connections for maintenance?

    1. AClose and Apply
    2. BData source settings
    3. CNavigator
    4. DChange Source for the selected connection
    Show the answer

    Data source settings exposes existing connections and their maintenance actions; Change Source is one action inside that window, Navigator selects source objects, and Close and Apply commits Power Query changes.

    Next → 1 / 10

  2. Question 2 of 10

    Which SQL Server sign-in choice fits credentials issued directly by the database administrator?

    1. ADatabase
    2. BMicrosoft account
    3. CWindows
    4. DConnect live
    Show the answer

    Database authentication accepts the database system's own credentials; Windows and Microsoft account use different identities, while Connect live is a connectivity choice rather than authentication.

    Next → 2 / 10

  3. Question 3 of 10

    Which action is used to change the saved privacy-level setting for a selected source?

    1. AEdit permissions
    2. BClear Permissions
    3. CTransform Data
    4. DChange Source
    Show the answer

    Privacy belongs to the selected source's saved permission configuration; source-location changes, permission removal, and data transformation serve different purposes.

    Next → 3 / 10

  4. Question 4 of 10

    What should you do in Data source settings after a connected file moves to another folder?

    1. AOpen Navigator and select a different table
    2. BChoose Change Source and update the file path
    3. CChoose Clear Permissions and retain the old path
    4. DChoose Edit permissions and replace the credential
    Show the answer

    A moved file changes connection location, so Change Source is the relevant maintenance action; credentials, saved permissions, and object selection do not replace the obsolete path.

    Next → 4 / 10

  5. Question 5 of 10

    Which Query Settings control provides an alternative route for updating relational connection details?

    1. AThe credential tab in SQL Server
    2. BThe Close and Apply button in the report view
    3. CThe settings icon next to Source
    4. DThe Navigator check box next to a table
    Show the answer

    The Source step's settings control reopens the connection details for the selected query; Navigator, authentication tabs, and Close and Apply address other stages.

    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 maintenance action removes saved permission information for an existing connection?

    1. AChange Source
    2. BEdit permissions
    3. CClear Permissions
    4. DClose and Apply
    Show the answer

    Clearing permissions removes the saved access information so the connection can request it again; editing, relocating, and applying changes have narrower purposes.

    Next → 6 / 10

  8. Question 7 of 10

    After updating server and database details from Power Query, what completes the settings change?

    1. AConfirm the dialog, then select Close and Apply
    2. BOpen Navigator, then select Transform Data
    3. CClear permissions, then retain the former server
    4. DChange the credential, then cancel the dialog
    Show the answer

    The connection details are confirmed in their dialog and then committed through Close and Apply; the other sequences discard or redirect the requested update.

    Next → 7 / 10

  9. Question 8 of 10

    A workbook is moved during development, and the replacement also renames two source columns. What risk should the report author address before changing the path?

    1. AThe renamed columns will change the Windows identity
    2. BThe path update will convert the workbook to SQL Server
    3. CThe new folder will clear every saved permission
    4. DThe structural changes can break the reporting model
    Show the answer

    A path replacement is expected to preserve the original file structure; renamed or deleted source columns can invalidate the reporting model that depends on them.

    Next → 8 / 10

  10. Question 9 of 10

    A security policy requires a new password for a SQL Server connection that uses a database-issued identity. Which update fits?

    1. AEdit permissions and switch the identity to Connect live
    2. BChange Source and replace the database with a workbook
    3. CClear Permissions and keep using the expired password
    4. DEdit permissions and keep Database as the credential type
    Show the answer

    A password rotation changes saved access information, while the database-issued identity still maps to Database authentication; source replacement and connectivity modes solve different problems.

    Next → 9 / 10

  11. Question 10 of 10

    An existing source still points to the correct server, but its saved privacy-level setting must change. Which procedure targets the requested configuration?

    1. ASelect the source, choose Edit permissions, and update the privacy setting
    2. BSelect the source, choose Change Source, and replace the server name
    3. CSelect the source in Navigator and load a different database table
    4. DSelect the source, choose Clear Permissions, and leave privacy unselected
    Show the answer

    The location remains valid, so the change belongs to the source's saved permission configuration; Edit permissions targets that configuration without replacing the server.

    Next → 10 / 10

  12. You’ve finished this set

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

    Back to the course Next lesson: Storage ModesGet 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