Get or Connect to Data PL-300 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What happens to queries that reference a parameter when the parameter value is modified?

   • AThe queries are deleted
   • BThe queries must be manually edited to use the new value
   • CThe queries automatically use the new value on the next refresh
   • DThe queries are converted to DirectQuery mode
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A company is planning to migrate a Power BI semantic model from Import mode to DirectLake mode to reduce refresh times and ensure data is always current. The semantic model is used by several reports that perform complex calculations and have strict performance requirements. What should the analyst evaluate before making the change?

   • AThe requirement to duplicate the data in the lakehouse.
   • BThe impact on query performance, because DirectLake may be slower for complex calculations than Import mode.
   • CThe need to use a gateway for the lakehouse connection.
   • DThe need to increase the refresh frequency to keep data current.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which data source is best suited for storing semi-structured data such as JSON documents that may have varying fields?

   • ASharePoint list
   • BExcel workbook
   • CAzure SQL Database
   • DAzure Blob Storage
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   You have a Power BI report that combines data from an on-premises SQL Server and a public OData feed. You need to ensure that the report refresh does not fail due to privacy level settings, but you also want to minimize the risk of sending on-premises data to the public feed. What should you configure?

   • ASet both sources to Private.
   • BSet both sources to Public.
   • CDisable query folding for the entire query.
   • DSet the SQL Server privacy level to Private and the OData feed to Public.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   You have a Power BI report that connects to an Azure SQL database. The database name changes between development and production environments. You want to be able to switch the database name without editing the query each time. What should you create?

   • AA calculated column that stores the database name
   • BA parameter for the database name and reference it in the query
   • CA new query for each environment and toggle visibility
   • DA row-level security role for each environment
   Reveal Solution Discussion Select an answer first