PL-300 Question 21

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 2

  - Create: Two parameters (One for the server name, one for the database name.) - Parameter type: Text (Both server and database names are text values.)

• 2

  * Answers: - Create: Two parameters (One for the server name, one for the database name.) - Parameter type: Text (Both server and database names are text values.) * Why not the others: - One parameter → Not enough because you need to control both server and database names. - Three parameters → Unnecessary; only two are needed. - True/False or Decimal number → Not applicable for server/database names.

• 1

  Instead of creating two separate parameters (ServerName and DatabaseName), you only need one parameter Environment, and use logic like this in Power Query: let envMap = [ Development = [Server = "dev.database.windows.net", DB = "db-powerbi-dev"], Test = [Server = "uat.database.windows.net", DB = "db-powerbi-uat"], Production = [Server = "prod.database.windows.net", DB = "db-powerbi-prod"] ], selectedEnv = envMap[Environment], Source = Sql.Database(selectedEnv[Server], selectedEnv[DB]) in Source