Prepstellar
Get the app

PL-300 · Practice set 8 of 8

Power Query Parameters: 10 practice questions

10 questions · Untimed · Free

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

Set 8 · Power Query Parameters · 10 questions Read the lesson

  1. Question 1 of 10

    Which Power Query command creates a new parameter?

    1. AClose and Apply, then Apply changes
    2. BEdit parameters
    3. CManage parameters, then New parameter
    4. DAdvanced options, then SQL statement
    Show the answer

    New parameter under Manage parameters creates the parameter; Edit parameters changes an existing value, while the other paths configure or apply a query.

    Next → 1 / 10

  2. Question 2 of 10

    Which type is assigned to the SalesPerson parameter in the documented example?

    1. AThe Date/Time data type
    2. BThe True/False data type
    3. CThe Text data type
    4. DThe Decimal Number data type
    Show the answer

    SalesPerson is created as Text with Any value as the suggested-value setting, matching the textual values passed to the query.

    Next → 2 / 10

  3. Question 3 of 10

    Which command opens the dialog for changing an existing parameter value?

    1. ACurrent Value
    2. BSelect Apply changes after editing the value
    3. CNew parameter
    4. DSelect Edit parameters
    Show the answer

    Edit parameters is used after creation to replace the active value; the other choices create a parameter, commit an edited value, or expose Current Value for testing.

    Next → 3 / 10

  4. Question 4 of 10

    How does the documented native query reference the SalesPerson parameter?

    1. ARename the source query to SalesPerson and remove its execute statement
    2. BReplace the fixed value with an ampersand followed by SalesPerson
    3. CUse Current Value
    4. DAppend SalesPerson to the query by using a comma and a wildcard
    Show the answer

    The Advanced Editor expression substitutes the fixed execute-statement value with an ampersand and the parameter name so the query evaluates that value.

    Next → 4 / 10

  5. Question 5 of 10

    What should you do when Power Query warns that permission is required to run the native database query?

    1. ASelect Current Value and then Refresh Preview
    2. BSelect New parameter
    3. CSelect Edit Permission and then Run
    4. DSelect Enable load and then Close and Apply
    Show the answer

    The native-query warning is resolved through Edit Permission followed by Run; parameter settings and query-loading controls address different parts of the workflow.

    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

    After changing a parameter through Edit parameters, which sequence applies the new value?

    1. ACreate a new parameter, disable load, and delete the original source query
    2. BConfirm the value, select Apply changes, and rerun the native query if required
    3. CEnter a Current Value, skip Apply changes, and close the editor
    4. DOpen Navigator, select Load, and convert the parameter into a model table
    Show the answer

    A modified parameter takes effect after the replacement value is confirmed and changes are applied; native-query execution may then need to be approved again.

    Next → 6 / 10

  8. Question 7 of 10

    What must happen before changing Current Value can alter the data returned by the source query?

    1. AThe SQL statement must be removed from the connection
    2. BThe parameter must be renamed after every test
    3. CThe source query must reference the parameter
    4. DThe parameter type must be changed before every test
    Show the answer

    A parameter value affects results only when the source query expression references that parameter; creating or renaming a detached parameter leaves the fixed query unchanged.

    Next → 7 / 10

  9. Question 8 of 10

    A report currently returns sales for one salesperson. The developer needs to test another salesperson without redesigning the query. What should the developer do?

    1. ALoad the parameter into the model as a table and delete its Current Value
    2. BChange the existing parameter value, apply changes, and rerun the native query
    3. CReplace the parameter with a new SQL Server connection and remove the original query
    4. DKeep the old Text value
    Show the answer

    The parameter separates the selected salesperson value from the query design, so editing and applying that value returns data for the new person.

    Next → 8 / 10

  10. Question 9 of 10

    A developer created SalesPerson and changed Current Value, but the query still returns the original salesperson. What should the developer inspect?

    1. AWhether Edit parameters replaced the SQL statement with a credential
    2. BWhether Close and Apply renamed the parameter to the original value
    3. CWhether the native query still contains a fixed value instead of SalesPerson
    4. DWhether Suggested Values was changed from Any value to Text before every query run
    Show the answer

    Changing Current Value cannot affect a query that still uses its original fixed filter; the Advanced Editor expression must reference SalesPerson.

    Next → 9 / 10

  11. Question 10 of 10

    A developer has a fixed salesperson value in a native SQL query and wants to make it adjustable. Which implementation is complete?

    1. ACreate a Text parameter and replace the fixed value with its query reference
    2. BSelect Apply changes and remove the native SQL statement
    3. CChange Current Value without creating or referencing a parameter
    4. DCreate a Text parameter but leave the fixed SQL value unchanged
    Show the answer

    The adjustable pattern requires both a defined parameter and a source-query reference to it; either step alone leaves the native query fixed or unbound.

    Next → 10 / 10

  12. You’ve finished this set

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

    Back to the course Get 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