PL-300 Microsoft Power BI Data Analyst Practice Exam

Answer all the questions. There is only correct answer. The correct answer will be given upon choosing a response.

 

#1. In Power BI, what is a paginated report?

#2. In DirectQuery mode, where is the data stored?

#3. What is the purpose of the ‘Drillthrough’ feature in Power BI?

#4. In Power BI, which action allows users to navigate from a summary report to a detailed report?

#5. Which storage mode should you use to enable real-time data updates in Power BI?

#6. You need to compare actual vs. target values in Power BI. Which visual should you use?

#7. What is the purpose of the ‘Synonyms’ feature in Power BI?

#8. What happens when you set a visual interaction to ‘Highlight’ instead of ‘Filter’?

#9. Which of the following functions is used to remove filters from a column in DAX?

#10. In Power BI, which of the following features allows users to ask questions about their data in natural language?

#11. You need to display a multi-row card with multiple values in Power BI. Which visual should you use?

#12. What is the function of the ‘LOOKUPVALUE’ DAX function in Power BI?

#13. What is the main purpose of the Power Query editor in Power BI?

#14. Which function in DAX returns a single value based on a condition?

#15. In Power BI, what does the ‘Transform Data’ button do?

#16. Which feature allows you to create reusable datasets in Power BI Service?

#17. What is the benefit of using the ‘Performance Analyzer’ in Power BI?

#18. Which language is used to create calculated columns and measures in Power BI?

#19. You need to dynamically change a visual based on user selection. What feature should you use?

#20. Which Power BI feature allows users to explore data interactively by clicking on different visual elements?

#21. Which of the following storage modes provides the fastest query performance in Power BI?

#22. Which of the following is a valid method to create a relationship between tables?

#23. You need to restrict access to data based on user roles. Which feature should you use?

#24. Which Power BI component is best for creating and managing dashboards?

#25. Which Power BI component is responsible for scheduled data refresh?

#26. Which type of Power BI visualization is best suited for showing the composition of data over time?

#27. Which data connection mode in Power BI allows real-time data access?

#28. What is the main purpose of the ‘Relationships’ view in Power BI?

#29. You want to allow users to filter data dynamically by selecting specific criteria in Power BI. Which feature should you use?

#30. In Power BI, what does the ‘Key Influencers’ visual help you determine?

#31. In Power BI, which visual is best suited for displaying key performance indicators (KPIs)?

#32. In Power BI, what is the purpose of the ‘Group By’ operation in Power Query?

#33. In Power BI, what is the purpose of a tooltip?

#34. What is the primary use of calculated tables in Power BI?

#35. You need to create a calculated column in Power BI that extracts the year from a date column named ‘OrderDate’. Which DAX function should you use?

#36. In Power BI, what does the ‘Append Queries’ feature do?

#37. You want to remove duplicate records in Power Query. What should you do?

#38. You need to calculate the running total of sales per year. Which DAX function should you use?

#39. In Power BI, what is the default storage mode when importing data?

#40. What is the purpose of the ‘Drilldown’ feature in Power BI?

#41. You need to create a report that updates automatically every 5 minutes. Which connection type should you use?

#42. Which of the following is NOT a valid Power BI data source?

#43. Which chart is most suitable for showing the contribution of each category to a whole?

#44. You want to combine two tables in Power Query that have similar column structures. Which operation should you use?

#45. Which Power BI component allows users to build paginated reports?

#46. What is the main advantage of using a star schema in Power BI?

#47. You need to ensure that only authorized users can see sensitive data in a Power BI report. What feature should you use?

#48. Which feature allows Power BI users to schedule automatic data refreshes?

#49. In Power BI, what is the purpose of the ‘Publish’ button?

#50. What is the primary use of the KPI visual in Power BI?

#51. Which visual in Power BI is best for displaying a trend over time?

#52. You want to allow users to switch between different measures in a single visual. Which feature should you use?

#53. What is the purpose of a ‘What-If Parameter’ in Power BI?

#54. Which formula correctly creates a new measure in Power BI?

#55. You need to visualize hierarchical data. Which visual should you use?

#56. Which file format is used to import a Power BI desktop report?

#57. What is the default summarization for a numeric column in Power BI?

#58. Which function in DAX is used to calculate cumulative totals?

#59. What is the primary purpose of the ‘Data Gateway’ in Power BI?

#60. What is the primary purpose of the ‘Measure’ in Power BI?

Previous
Finish

Results