Power BI Quiz

Which of the following data sources is NOT supported by Power BI?

• Excel workbook.

• SQL Server database.

• MongoDB.

• Adobe Photoshop.

In Power BI, what is the primary purpose of data profiling?

• To visualize the relationships between different datasets

• To identify and correct inconsistencies and data quality issues

• To automatically generate reports and dashboards for data visualization

• To define and create appropriate keys for joining different tables

In Power BI, what feature allows users to control the layout and appearance of the report pages, including adding background images and adjusting page size?

• Report Access

• Scheduled Reports

• Report themes

• Page settings

When connecting to a large dataset stored in an SQL Server, which storage mode in Power BI would be most suitable to optimize performance?

• Import

• DirectQuery

• Dual

• all the above has similar impact

In Power BI, what is the primary function of the "Get Data" option?

• To analyze data within the software

• To format and visualize existing datasets

• To share reports with team members

• To establish communication and acquire information from external source

A user has sales data for two months in separate tables. However, does he need to consolidate queries in Power BI to create a single unified dataset?

• By using the "Append Queries" feature to stack one dataset on top of another

• By creating a new calculated column in each dataset and then merging them based on a common identifier

• By importing both datasets into Excel and then merging them using VLOOKUP function

• By exporting both datasets to a CSV file and then importing them back into Power BI as a single dataset

What is the primary purpose of applying slicers and filters in Power BI reports?

• To adjust the font size and style of visualization titles

• To control which data is displayed in the report visuals based on user selections

• To resize and rearrange visualizations within the report canvas

• To change the color palette used in the visualizations

Which Power BI storage mode is recommended for datasets with minimal latency requirements?

• Import

• DirectQuery

• Composite

• Live Connection

Which visualization type in Power BI is best suited for displaying hierarchical data structures, such as organizational charts or family trees?

• Pie chart

• Treemap

• Scatter plot

• Funnel chart

What is the first step in creating a new workspace in Power BI?

• Assigning workspace roles to users

• Configuring sensitivity labels for workspace content

• Publishing or importing assets into the workspace

• Clicking on the "Create workspace" button and providing necessary details