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