Overview of Power BI Data Analyst Associate
The PL-300 certification is an essential milestone in your Azure journey. Our practice tests simulate the real exam format, helping you build confidence and identify knowledge gaps. Review the detailed explanations provided after each question to deeply understand the underlying cloud concepts.
Sample PL-300 Practice Questions
Question 1
A business analyst needs to connect to an external SQL Server database to retrieve sales data for analysis in Power BI. The data is updated frequently and should be refreshed automatically without impacting the performance of the existing reports. Which mode should the analyst use for this scenario, and why?
- Import mode
- DirectQuery mode
- Dual mode
- Power Query mode
DirectQuery mode is the best choice for this scenario because it allows the data to be queried directly from the source, ensuring that the latest data is always available. This mode also offloads the querying process to the source database, which helps maintain the performance of existing reports. Import mode would store the data locally, which could lead to performance issues due to the need to refresh the data, and Dual mode combines both modes but is not necessary for this specific requirement.
Question 2
An organization wants to integrate data from multiple sources into a single Power BI report, including a local Excel file and a live connection to an Azure SQL Database. To ensure that the Excel data is refreshed manually while the SQL data is refreshed automatically, what approach should be taken using Power Query in Power BI Desktop?
- Use Import mode for both data sources
- Use DirectQuery mode for both data sources
- Use Import mode for the Excel file and DirectQuery for the SQL Database
- Use Power Query mode for both data sources
The analyst should use the 'Get Data' feature in Power BI Desktop to import the Excel file in Import mode and then use DirectQuery for the Azure SQL Database. This way, the Excel data can be refreshed manually, and the SQL data can be refreshed automatically without affecting the performance of the existing reports. Using Import mode for both would not allow automatic refreshing for the SQL data, and using DirectQuery for both would not allow manual refreshing for the Excel data.
Question 3
You are working on a data transformation project using Azure Data Factory and need to clean, transform, and load data from an Excel file into a SQL Server database. The Excel file contains a column with mixed data types (numeric and string values). You want to ensure that all numeric values are converted to integers before loading them into the database. Which M language script should you use to achieve this transformation?
- type(text)
- type(int)
- type(number)
- type(float)
The correct answer is B because the `type` function in M can be used to convert the data type of a column. In this case, `type(int)` will convert the column to integer type, ensuring that only numeric values are kept and non-numeric values are removed or handled as per the requirement. Option A uses `type(text)` which does not perform any conversion. Option C uses `type(number)` which might not remove non-numeric values. Option D uses `type(float)` which also does not guarantee integer conversion.
Use the interactive quiz engine above to answer these questions and hundreds more.