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