1What is the primary purpose of Microsoft Power BI?
A.Business Intelligence and Data Visualization
B.Word processing
C.Operating System Management
D.Video Editing
Correct Answer: Business Intelligence and Data Visualization
Explanation:
Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights.
Incorrect! Try again.
2Which of the following is NOT a core element of the Power BI ecosystem?
A.Power BI Desktop
B.Power BI Service
C.Power BI Text Editor
D.Power BI Mobile
Correct Answer: Power BI Text Editor
Explanation:
The three main elements are Power BI Desktop (Windows application), Power BI Service (SaaS), and Power BI Mobile (apps for devices). There is no specific tool called Power BI Text Editor.
Incorrect! Try again.
3Which file extension is used for a Power BI Desktop report?
A..pbix
B..docx
C..pbit
D..xlsx
Correct Answer: .pbix
Explanation:
The standard file extension for a Power BI report file that contains data, queries, and visualizations is .pbix.
Incorrect! Try again.
4In the general Power BI workflow, which step typically comes first?
A.Create Visualizations
B.Share Dashboard
C.Get Data
D.Publish to Service
Correct Answer: Get Data
Explanation:
The workflow usually begins by connecting to data sources using the 'Get Data' feature before transformation or visualization occurs.
Incorrect! Try again.
5Which tool within Power BI is primarily used for Data Transformation and Cleaning (ETL)?
A.Power Query Editor
B.Power Q&A
C.Power Map
D.Power View
Correct Answer: Power Query Editor
Explanation:
Power Query Editor is the dedicated tool within Power BI for connecting to data, reshaping it, and cleaning it (Extract, Transform, Load).
Incorrect! Try again.
6Power BI Desktop is available on which operating system?
A.MacOS
B.Android (Desktop Mode)
C.Linux
D.Windows
Correct Answer: Windows
Explanation:
Power BI Desktop is currently only natively available for Windows operating systems.
Incorrect! Try again.
7What is the benefit of installing Power BI Desktop from the Microsoft Store rather than downloading the .exe file?
A.It has more features
B.It allows offline access
C.It is faster
D.It updates automatically
Correct Answer: It updates automatically
Explanation:
Installing from the Microsoft Store ensures that Power BI Desktop is automatically updated in the background as soon as a new version is released.
Incorrect! Try again.
8Which pane in Power BI Desktop allows you to select different chart types like Bar Charts or Pie Charts?
A.Fields Pane
B.Visualizations Pane
C.Selection Pane
D.Filter Pane
Correct Answer: Visualizations Pane
Explanation:
The Visualizations pane contains the icons for different chart types and allows you to configure specific visual settings.
Incorrect! Try again.
9What are the three main views available in the left-hand sidebar of Power BI Desktop?
A.Desktop, Mobile, Web
B.Query, Design, Layout
C.Home, Insert, View
D.Report, Table (Data), Model
Correct Answer: Report, Table (Data), Model
Explanation:
The left sidebar allows navigation between the Report View (canvas), Table/Data View (row-level data), and Model View (relationships).
Incorrect! Try again.
10Which language is primarily used for creating calculations and measures in Power BI?
A.DAX
B.Java
C.SQL
D.Python
Correct Answer: DAX
Explanation:
DAX (Data Analysis Expressions) is the formula language used in Power BI for creating custom calculations, measures, and calculated columns.
Incorrect! Try again.
11Where can you modify the 'Regional Settings' to change how dates and numbers are interpreted?
A.Format Pane
B.Insert Tab
C.Help Menu
D.File > Options and settings > Options
Correct Answer: File > Options and settings > Options
Explanation:
Global and current file settings, including Regional Settings (locale), are accessed via the File menu under Options and settings.
Incorrect! Try again.
12What is the purpose of the 'Model View' in Power BI Desktop?
A.To write SQL queries
B.To enter data manually
C.To create relationships between tables
D.To design the dashboard background
Correct Answer: To create relationships between tables
Explanation:
The Model View shows the tables in the dataset and allows users to define and manage relationships (joins) between them.
Incorrect! Try again.
13What does the 'Transform Data' button on the Home ribbon do?
A.Changes the chart type
B.Opens the Power Query Editor
C.Refreshes the visuals
D.Publishes the report
Correct Answer: Opens the Power Query Editor
Explanation:
Clicking 'Transform Data' launches the Power Query Editor window where data cleaning operations take place.
Incorrect! Try again.
14Which of the following is NOT a valid data source type in Power BI?
A.Physical Paper Documents
B.SQL Server Database
C.Web Page
D.Excel Workbook
Correct Answer: Physical Paper Documents
Explanation:
Power BI connects to digital data sources. It cannot connect directly to physical paper without an intermediary digitization step (like OCR or manual entry).
Incorrect! Try again.
15In the Power BI interface, what is the 'Canvas'?
A.The formula bar
B.The data connection screen
C.The sign-in window
D.The central area where visuals are arranged
Correct Answer: The central area where visuals are arranged
Explanation:
The Canvas (or Report Canvas) is the main workspace in Report View where you drag and drop visuals to build your report.
Incorrect! Try again.
16What is a 'Slicer' in Power BI?
A.A function to divide numbers
B.A type of pie chart
C.A visual used to filter other visuals on the page
D.A tool to cut data connection
Correct Answer: A visual used to filter other visuals on the page
Explanation:
A Slicer is an on-canvas visual that allows users to filter the data displayed in other visuals on the report page.
Incorrect! Try again.
17Which feature allows you to see the data underlying a specific visual point?
A.Focus Mode
B.Zoom
C.Show Data / See Records
D.Drill through
Correct Answer: Show Data / See Records
Explanation:
Right-clicking a visual and selecting 'Show as a table' or 'Show data point' allows you to inspect the specific data behind that visual element.
Incorrect! Try again.
18How often does Microsoft typically release updates for Power BI Desktop?
A.Daily
B.Monthly
C.Weekly
D.Annually
Correct Answer: Monthly
Explanation:
Microsoft generally releases feature updates for Power BI Desktop on a monthly cycle.
Incorrect! Try again.
19What is the purpose of 'Focus Mode' on a visual?
A.It filters the data to top 10
B.It blurs the background
C.It expands the visual to fill the entire canvas
D.It highlights the visual in red
Correct Answer: It expands the visual to fill the entire canvas
Explanation:
Focus mode allows a user to expand a single visual to fill the workspace for better visibility and analysis.
Incorrect! Try again.
20Which pane allows you to hide or show specific visuals and arrange their layering order?
A.Selection Pane
B.Bookmarks Pane
C.Sync Slicers Pane
D.Filter Pane
Correct Answer: Selection Pane
Explanation:
The Selection Pane lists all objects on the canvas, allowing you to hide/unhide them and change their z-order (stacking order).
Incorrect! Try again.
21What represents the relationship between Power BI Desktop and Power BI Service?
A.They are the same thing
B.Desktop is for authoring/creation, Service is for sharing/collaboration
C.Service is for authoring, Desktop is for viewing
D.Desktop is paid, Service is free
Correct Answer: Desktop is for authoring/creation, Service is for sharing/collaboration
Explanation:
Reports are typically built and modeled in the Desktop application and then published to the Service for broader distribution.
Incorrect! Try again.
22To use Power BI Service, what is required?
A.A personal email address (e.g., @gmail.com)
B.Windows 11
C.A work or school email address
D.A credit card
Correct Answer: A work or school email address
Explanation:
Power BI Service generally requires an organizational email address (Work or School) for sign-up, rather than a generic public email provider.
Incorrect! Try again.
23In the Filters pane, which scope applies a filter to every page in the report?
A.Filters on all pages
B.Drillthrough filters
C.Filters on this visual
D.Filters on this page
Correct Answer: Filters on all pages
Explanation:
The 'Filters on all pages' section allows a filter to be applied globally across the entire report file.
Incorrect! Try again.
24What is the function of the 'Data' (or 'Fields') pane?
A.It shows available tables and columns
B.It shows the report settings
C.It shows the color palette
D.It shows the SQL code
Correct Answer: It shows available tables and columns
Explanation:
The Data/Fields pane displays the loaded tables and their corresponding columns/fields that can be dragged onto the canvas.
Incorrect! Try again.
25Which setting allows you to turn off 'Auto Date/Time' to prevent automatic hierarchy creation?
A.Security options
B.Privacy options
C.Regional options
D.Data Load options
Correct Answer: Data Load options
Explanation:
Under File > Options > Current File > Data Load, you can disable 'Auto Date/Time' to stop Power BI from automatically creating hidden date tables.
Incorrect! Try again.
26What is a 'Dashboard' in the context of Power BI?
A.The loading screen
B.A multi-page report in Desktop
C.The data modeling view
D.A single-page canvas in Power BI Service utilizing pinned tiles
Correct Answer: A single-page canvas in Power BI Service utilizing pinned tiles
Explanation:
Strictly speaking, in Power BI terminology, a Dashboard is a feature of the Power BI Service where visuals (tiles) from different reports are pinned to a single page.
Incorrect! Try again.
27Which interface element allows you to enter natural language questions to generate visuals?
A.Decomposition Tree
B.Smart Narrative
C.Key Influencers
D.Q&A
Correct Answer: Q&A
Explanation:
The Q&A feature allows users to type questions in natural language (e.g., 'Total sales by year') and Power BI automatically generates the visual.
Incorrect! Try again.
28What happens when you click 'Publish' in Power BI Desktop?
A.The report is printed
B.The report is emailed to your boss
C.The report is uploaded to your workspace in Power BI Service
D.The file is saved to your hard drive
Correct Answer: The report is uploaded to your workspace in Power BI Service
Explanation:
Publishing moves the local .pbix report to the cloud-based Power BI Service so it can be shared online.
Incorrect! Try again.
29Which ribbon tab contains the options to insert text boxes, buttons, and shapes?
A.Home
B.Insert
C.View
D.Modeling
Correct Answer: Insert
Explanation:
The Insert tab is designed for adding static elements like text boxes, shapes, images, and buttons to the report.
Incorrect! Try again.
30What is the 'Format Painter' used for?
A.Changing data types
B.Painting the background color
C.Copying formatting from one visual to another
D.Drawing freehand shapes
Correct Answer: Copying formatting from one visual to another
Explanation:
Similar to Excel or Word, the Format Painter copies the design/style settings of a selected visual and applies them to another.
Incorrect! Try again.
31If you want to change the overall color scheme (theme) of your report, which tab should you visit?
A.View
B.Help
C.External Tools
D.Home
Correct Answer: View
Explanation:
The View tab contains the Themes gallery where you can select or customize the color palette and text styles for the whole report.
Incorrect! Try again.
32What is the purpose of 'Preview Features' in the Options menu?
A.To enable new features that are still in development
B.To preview the mobile layout
C.To view the data source
D.To see the report before printing
Correct Answer: To enable new features that are still in development
Explanation:
Preview Features allows users to opt-in to test new functionality that Microsoft has released but not yet finalized as standard features.
Incorrect! Try again.
33Which component manages the refresh of on-premises data in the Power BI Service?
A.Power BI Gateway
B.Power Automate
C.Power BI Report Server
D.Azure Analysis Services
Correct Answer: Power BI Gateway
Explanation:
The On-premises Data Gateway acts as a bridge to provide quick and secure data transfer between on-premises data and the Power BI Service.
Incorrect! Try again.
34In the Table View (Data View), what can you do?
A.Publish reports
B.Create visuals
C.Build charts
D.Inspect and filter raw data rows
Correct Answer: Inspect and filter raw data rows
Explanation:
Table View allows you to see the actual data loaded into the model, helping to verify data accuracy and calculations.
Incorrect! Try again.
35Which of the following describes the 'Import' connectivity mode?
A.Data is strictly read-only and cannot be transformed
B.Data remains in the source and is queried live
C.Data is copied into the Power BI file and stored in memory
D.Data is only available when online
Correct Answer: Data is copied into the Power BI file and stored in memory
Explanation:
Import mode loads a copy of the data into the Power BI internal engine (VertiPaq), offering high performance but requiring scheduled refreshes.
Incorrect! Try again.
36What is the default interaction when clicking a bar in a bar chart?
A.It deletes the bar
B.It does nothing
C.It cross-highlights related data in other visuals
D.It opens a new webpage
Correct Answer: It cross-highlights related data in other visuals
Explanation:
By default, selecting a data point in one visual cross-filters or cross-highlights the other visuals on the same page to show related data.
Incorrect! Try again.
37Where can you adjust the page size (e.g., from 16:9 to Letter)?
A.Home Tab
B.View Tab
C.File > Print
D.Canvas Settings in the Format Pane
Correct Answer: Canvas Settings in the Format Pane
Explanation:
When no visual is selected, the Format Pane displays Page Information and Canvas Settings, where page size can be adjusted.
Incorrect! Try again.
38What is a 'Tooltip'?
A.A tip on how to use the tool
B.Information that appears when you hover over a data point
C.A button to save the file
D.A type of drill down
Correct Answer: Information that appears when you hover over a data point
Explanation:
Tooltips provide additional data context in a small pop-up box when the mouse cursor hovers over a specific visual element.
Incorrect! Try again.
39Which data privacy level should be used for data that is sensitive and should not be shared with other sources?
A.Private
B.General
C.Organizational
D.Public
Correct Answer: Private
Explanation:
The Private privacy level isolates the data source and prevents it from being combined with other data sources in ways that might leak information.
Incorrect! Try again.
40How do you rename a page in Power BI Desktop?
A.Double-click the page tab at the bottom
B.File > Rename
C.Right-click the canvas
D.View > Page Name
Correct Answer: Double-click the page tab at the bottom
Explanation:
Like Excel, you can rename a report page by double-clicking the tab name at the bottom of the window.
Incorrect! Try again.
41What is the purpose of the 'Mobile Layout' view?
A.To design a vertical view specifically for phone screens
B.To reduce file size
C.To install the mobile app
D.To text the report to phones
Correct Answer: To design a vertical view specifically for phone screens
Explanation:
Mobile Layout allows authors to create a specific arrangement of visuals optimized for portrait viewing on mobile devices.
Incorrect! Try again.
42Which visual is best suited for showing a progress toward a specific goal (KPI)?
A.Scatter Plot
B.Pie Chart
C.Tree Map
D.Gauge Chart
Correct Answer: Gauge Chart
Explanation:
A Gauge chart (or KPI visual) is specifically designed to display a single value within the context of a goal or target.
Incorrect! Try again.
43In the Get Data window, which category would you find 'Folder'?
A.Database
B.Online Services
C.Azure
D.File
Correct Answer: File
Explanation:
The 'Folder' connector, which allows importing multiple files from a directory, is located under the 'File' category.
Incorrect! Try again.
44What does the 'Lock Objects' feature in the View tab do?
A.Stops data refresh
B.Locks the file with a password
C.Encrypts the data
D.Prevents visuals from being moved or resized
Correct Answer: Prevents visuals from being moved or resized
Explanation:
Lock Objects prevents the accidental movement or resizing of visuals on the canvas while still allowing interaction with the data.
Incorrect! Try again.
45What is the maximum recommended RAM for running Power BI Desktop efficiently?
A.4 GB or more
B.1 GB
C.2 GB
D.512 MB
Correct Answer: 4 GB or more
Explanation:
While minimum requirements are lower, Microsoft recommends at least 4 GB of RAM (and often more for large models) for a smooth experience.
Incorrect! Try again.
46Where do you manage 'Row-Level Security' (RLS) roles in Desktop?
A.File > Options
B.Insert > Roles
C.Modeling Tab > Manage Roles
D.Home Tab > Security
Correct Answer: Modeling Tab > Manage Roles
Explanation:
RLS is configured in the Modeling tab using 'Manage Roles' to define DAX filters that restrict data based on user roles.
Incorrect! Try again.
47What is a .pbit file?
A.A Power BI Theme file
B.A temporary file
C.A corrupted file
D.A Power BI Template file
Correct Answer: A Power BI Template file
Explanation:
A .pbit file is a Power BI Template which contains the report structure and queries but does not contain the actual data.
Incorrect! Try again.
48Which button allows you to manually trigger a data update in Power BI Desktop?
A.Update
B.Requery
C.Refresh
D.Reload
Correct Answer: Refresh
Explanation:
The 'Refresh' button on the Home ribbon executes the queries again to pull the latest data from the connected sources.
Incorrect! Try again.
49Can Power BI import data from a PDF file?
A.Only images from PDF
B.Only if converted to Excel first
C.Yes, using the PDF connector
D.No, PDF is not supported
Correct Answer: Yes, using the PDF connector
Explanation:
Power BI includes a dedicated PDF connector that can scrape tables and data structures directly from PDF documents.
Incorrect! Try again.
50If the Fields pane is missing, how can you get it back?
A.Press Ctrl+Alt+Delete
B.Reinstall Power BI
C.Right click the canvas
D.View Tab > Show panes > Select Data/Fields
Correct Answer: View Tab > Show panes > Select Data/Fields
Explanation:
The View tab contains toggles to show or hide the various panes (Format, Data/Fields, Selection, etc.) in the interface.