Uncategorized Power bi by mfh.officials@gmail.com Jan 9, 2025 0 Comment power bi 1 / 20 What is the purpose of a star schema in Power BI? To apply row-level security To simplify complex relationships for better performance To create detailed reports To integrate multiple cloud services 2 / 20 Which visualization is best for analyzing trends over time? Funnel Chart Line Chart Pie Chart Scatter Plot 3 / 20 What is the purpose of Power Query in Power BI? To visualize data To manage user permissions To transform and clean data To create dashboards 4 / 20 Which cloud service does Power BI primarily use? Azure AWS IBM Cloud Google Cloud 5 / 20 Which file extension does Power BI Desktop use to save reports? .pbi .Xlsx .csv .pbix 6 / 20 What is the role of Power BI Service? To perform data modeling To share and collaborate on reports and dashboards To clean and transform data To design custom visuals 7 / 20 Which function in DAX is used to calculate year-to-date values? AGGREGATE TOTALYTD RUNNINGTOTAL CUMULATIVE 8 / 20 What is Power BI primarily used for? Software testing Website development Database management Business analytics and data visualization 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 does the CALCULATE function do in DAX? Modifies the context in which data is evaluated Calculates the total size of a dataset Defines a new measure Creates a new column 11 / 20 What is the purpose of "Bookmarks" in Power BI? To save data sources To add page navigation To capture and restore specific views of a report To schedule refreshes 12 / 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 13 / 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 14 / 20 What is a measure in Power BI? A type of data source A static column in the dataset A calculated value used in visualizations A filter applied to visuals 15 / 20 Which of the following is used to schedule automatic data refresh in Power BI? Power BI Desktop Power BI Gateway Power Query Power Automate 16 / 20 Which relationship cardinality is NOT supported in Power BI? Many-to-Many One-to-One Many-to-One Many-to-Zero 17 / 20 What is the purpose of row-level security (RLS) in Power BI? To apply filters to dashboards To optimize report performance To schedule data refreshes To restrict data access based on user roles 18 / 20 Which component is used to develop reports in Power BI? Power BI Desktop Power BI Gateway Power BI Mobile Power BI Service 19 / 20 Which tool can be used to analyze and optimize DAX queries? Power Query Editor Excel DAX Studio SQL Profiler 20 / 20 Which data connectivity mode allows real-time interaction with the underlying data source? Import Composite Cached DirectQuery Your score isThe average score is 62% 0% Restart quiz
Leave a Reply Cancel replyYour email address will not be published. Required fields are marked *Comment Name* Email* Save my name, email, and website in this browser for the next time I comment.
Leave a Reply