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