Power biBy mfh.officials@gmail.com / January 9, 2025 power bi 1 / 20 What is DAX in Power BI? A type of visualization A cloud-based service A data cleaning tool A language for calculations and queries 2 / 20 Which component is used to develop reports in Power BI? Power BI Gateway Power BI Service Power BI Mobile Power BI Desktop 3 / 20 What is a measure in Power BI? A static column in the dataset A calculated value used in visualizations A filter applied to visuals A type of data source 4 / 20 What are "Dataflows" in Power BI? A type of visualization A live connection to a SQL database A set of reports in Power BI Desktop A way to define reusable ETL logic 5 / 20 Which data connectivity mode allows real-time interaction with the underlying data source? Cached Composite Import DirectQuery 6 / 20 Which tool can be used to analyze and optimize DAX queries? SQL Profiler Excel DAX Studio Power Query Editor 7 / 20 Which relationship cardinality is NOT supported in Power BI? One-to-One Many-to-Many Many-to-One Many-to-Zero 8 / 20 What is the purpose of Power Query in Power BI? To visualize data To manage user permissions To create dashboards To transform and clean data 9 / 20 What is a workspace in Power BI? A database connection string A cloud environment to collaborate on reports A DAX formula editor A set of pre-built dashboards 10 / 20 Which visualization is best for analyzing trends over time? Funnel Chart Pie Chart Scatter Plot Line Chart 11 / 20 What is the purpose of a star schema in Power BI? To create detailed reports To apply row-level security To integrate multiple cloud services To simplify complex relationships for better performance 12 / 20 Which file extension does Power BI Desktop use to save reports? .pbi .Xlsx .csv .pbix 13 / 20 Which function in DAX is used to calculate year-to-date values? RUNNINGTOTAL TOTALYTD CUMULATIVE AGGREGATE 14 / 20 What is the purpose of "Bookmarks" in Power BI? To add page navigation To capture and restore specific views of a report To save data sources To schedule refreshes 15 / 20 What is the purpose of row-level security (RLS) in Power BI? To restrict data access based on user roles To optimize report performance To apply filters to dashboards To schedule data refreshes 16 / 20 What does the CALCULATE function do in DAX? Calculates the total size of a dataset Defines a new measure Modifies the context in which data is evaluated Creates a new column 17 / 20 What is Power BI primarily used for? Software testing Database management Website development Business analytics and data visualization 18 / 20 Which cloud service does Power BI primarily use? AWS IBM Cloud Azure Google Cloud 19 / 20 Which of the following is used to schedule automatic data refresh in Power BI? Power BI Desktop Power Automate Power Query Power BI Gateway 20 / 20 What is the role of Power BI Service? To share and collaborate on reports and dashboards To perform data modeling To design custom visuals To clean and transform data Your score isThe average score is 62% 0% Restart quiz
By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025 By
/ January 9, 2025