Exam PL-300 topic 1 question 21 discussion

Given answer is correct To meet the requirements specified, we can use a single parameter in the PBIX file that controls which database is used for data consumption based on the stage of the development lifecycle. We can use a Text parameter type in Power BI to achieve this. The parameter can be used to switch between the different database connections when a user interacts with the report. The text parameter could include values such as "Development", "Staging", and "Production", which correspond to the different databases shown in the table. The parameter can then be used in the queries to dynamically filter the data based on the selected stage of the development lifecycle. By using a single parameter, we can minimize administrative effort and ensure that the report works with each stage of the development lifecycle. No confusion, and no need to discuss further

Create: 2 parameters Parameter type: text

the answer is correct 1 parameter if Environment = "Dev" then "dev-server.database.windows.net" else if Environment = "Test" then "test-server.database.windows.net" else "prod-server.database.windows.net" If you're switching server or database names: Use Text as the parameter type. Example values: "dev-server.database.windows.net" "test-server.database.windows.net" This type works well for building dynamic connection strings in Power Query using conditional logic.

The given database names are different from each environment as well as the server name. So it needs two parameters, if the given database names are same then we only need one parameter for the server name.

We need one-text parameter in order to switch the various environments (dev, test, prod)

Correct , create Parameter for 2 Environment

To meet the requirements specified, we can use a single parameter in the PBIX file that controls which database is used for data consumption based on the stage of the development lifecycle. We can use a Text parameter type in Power BI to achieve this. The parameter can be used to switch between the different database connections when a user interacts with the report. The text parameter could include values such as "Development", "Staging", and "Production", which correspond to the different databases shown in the table. The parameter can then be used in the queries to dynamically filter the data based on the selected stage of the development lifecycle. By using a single parameter, we can minimize administrative effort and ensure that the report works with each stage of the development lifecycle

one param approach will work only if , each full connection string can be prepared like <database>. <other part of URL>. in that case, 3 env.s can be switched as per need. if both cannot be combined ina single entity, then 2 params are needed. ( I dont have exact idea abot how the connection gets created in textuual form internally ). kindly confirm if i am wrong and upvote if correct.

I think coz db name is an optional param, one would do for the server name alone

Connection is done with two different fields "Server" and "Database", so you will need also two parameters for that. Answer should be 2 parameters, both text.

Correct Answers: One Parameter / Text In Power Query, in Advance Editor you can use 1 parameter to update the stage of the server and the database by modifying the M Code as follows: '=Sql.Database(parameter&"ServerUrl", "DatabaseName"&parameter)'

The correct answers are Two Parameters and Text. ** Two Parameters: it is because we have three stages; Development, Test, and Production, which means we need parameters to dynamically switch between these stages. We have two columns in the table that are relevant for the scenario, "Stage" (to determine the stage) and "Server URL" (to specify the database server URL). ** Text: Text parameter is suitable for the scenario because we want to use them to switch between different server URLs based on the selected stage.

I think we just need 1 parameter because all the databases have different names and url to represent each of the stages. Using 2 parameters is waste of resources as just 1 parameter can serve the purpose. In this case we can chose to use either the database name or url. The stage column is only an additional information to clarify each database name or url. I hope this is clear.

1 Parameter with "List of Values"

SanaCanada is correct here only one parameter is needed. With one parameter with the parameter type of "Text" and Suggested Values to be "List of values" you can set three values as dev, uat, and prod. In the Azure they contain the same structure for the Name and Server URL. "db-powerbi-" & ".database.windows.net" The only thing that changes between the stages is dev, uat, and prod and for each of the stages the Name and Server URL is the same value for that stage. E.g, "db-powerbi-dev" & "dev.database.windows.net"

Please share resources from where this is referenced.

Given answer is correct