Data Source Settings and Privacy: 10 practice questions

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

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

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

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

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

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

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

Question 8 of 10

A connected workbook moved to a new folder, and the replacement file also renamed two columns that report visuals use. Which plan repairs the report?

1. AEdit permissions and enter the credential again, because the workbook now sits in another folder
2. BChange Source for the new path, because a refresh maps the renamed columns back automatically
3. CChange Source for the new path, then repair the steps and fields built on the old column names
4. DClear Permissions so the connection asks for the file again and rebuilds its column names

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

Question 10 of 10

A workbook of confidential employee reviews must be merged with an organizational SQL Server table. Privacy levels are enforced, and the review data must never reach that database. Which privacy level fits the workbook?

1. APrivate, which keeps the workbook data from folding into the other source
2. BNone, which leaves the workbook unclassified so the merge can proceed
3. CPublic, which lets the workbook data fold into any other data source
4. DOrganizational, which lets the workbook data fold into that SQL Server source