Power Query Parameters: 10 practice questions

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

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

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

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

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

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

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

Question 8 of 10

A native SQL query already references the Text parameter SalesPerson, and the report currently returns one salesperson. How should the developer return another salesperson's data without editing the query expression?

1. AOpen Edit parameters, enter the other name, and select Apply changes
2. BCreate a second parameter and rebuild the query against the same database
3. CApply a visual-level filter for the other name and refresh the report
4. DType the other name over the parameter reference in the execute statement

Question 9 of 10

A developer created the Text parameter SalesPerson, changed Current Value, selected Apply changes, and approved the native query permission prompt. The report still returns the original salesperson. What should the developer examine?

1. AWhether the replacement value was ever committed to the report
2. BWhether the parameter type should be changed before each test
3. CWhether the native query is still waiting for permission to run
4. DWhether the execute statement still holds the old fixed value

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