Parameters Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Get or Connect to Data

What you'll be asked

  1. What is the primary purpose of using a parameter when connecting to a data source?
  2. When defining a parameter to switch between a 'Development' and 'Production' server, which part of the connection string is typically replaced by the parameter?
  3. You are using a parameter to filter a large SQL table at the source. Where should this parameter be implemented to ensure the best performance?
  4. Which of the following is a common limitation of standard parameters in most BI tools during data preparation?
  5. In Power BI / Power Query, what is the 'Privacy Level' implication when using a parameter to construct a dynamic data source path?

Answers and explanations come after you submit.