1What is the primary purpose of Microsoft Power BI?
A.Business Intelligence and Data Visualization
B.Video Editing
C.Word processing
D.Operating System Management
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 Text Editor
C.Power BI Service
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..xlsx
C..pbit
D..docx
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.Publish to Service
C.Share Dashboard
D.Get Data
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 View
B.Power Query Editor
C.Power Q&A
D.Power Map
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.Windows
B.MacOS
C.Linux
D.Android (Desktop Mode)
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 allows offline access
B.It is faster
C.It updates automatically
D.It has more features
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.Selection Pane
C.Filter Pane
D.Visualizations 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.Report, Table (Data), Model
B.Query, Design, Layout
C.Home, Insert, View
D.Desktop, Mobile, Web
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.Python
B.DAX
C.SQL
D.Java
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.Insert Tab
B.File > Options and settings > Options
C.Help Menu
D.Format Pane
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 enter data manually
B.To design the dashboard background
C.To create relationships between tables
D.To write SQL queries
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.Publishes the report
B.Refreshes the visuals
C.Changes the chart type
D.Opens the Power Query Editor
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.Web Page
C.Excel Workbook
D.SQL Server Database
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 sign-in window
B.The central area where visuals are arranged
C.The formula bar
D.The data connection screen
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 visual used to filter other visuals on the page
B.A tool to cut data connection
C.A type of pie chart
D.A function to divide numbers
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.Drill through
B.Focus Mode
C.Zoom
D.Show Data / See Records
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.Weekly
C.Annually
D.Monthly
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 expands the visual to fill the entire canvas
B.It blurs the background
C.It filters the data to top 10
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.Filter Pane
C.Sync Slicers Pane
D.Bookmarks 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.Desktop is paid, Service is free
B.Desktop is for authoring/creation, Service is for sharing/collaboration
C.Service is for authoring, Desktop is for viewing
D.They are the same thing
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 credit card
B.Windows 11
C.A personal email address (e.g., @gmail.com)
D.A work or school email address
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.Drillthrough filters
B.Filters on this page
C.Filters on this visual
D.Filters on all pages
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 the report settings
B.It shows available tables and columns
C.It shows the SQL code
D.It shows the color palette
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.Data Load options
B.Regional options
C.Privacy options
D.Security 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.A single-page canvas in Power BI Service utilizing pinned tiles
D.The data modeling view
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.Key Influencers
B.Smart Narrative
C.Q&A
D.Decomposition Tree
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 uploaded to your workspace in Power BI Service
B.The report is emailed to your boss
C.The file is saved to your hard drive
D.The report is printed
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.View
B.Insert
C.Home
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.Copying formatting from one visual to another
B.Painting the background color
C.Changing data types
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.Home
B.View
C.External Tools
D.Help
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 see the report before printing
B.To view the data source
C.To enable new features that are still in development
D.To preview the mobile layout
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 Automate
B.Azure Analysis Services
C.Power BI Gateway
D.Power BI Report Server
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.Build charts
B.Create visuals
C.Publish reports
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 only available when online
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 strictly read-only and cannot be transformed
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 cross-highlights related data in other visuals
B.It deletes the bar
C.It opens a new webpage
D.It does nothing
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.Canvas Settings in the Format Pane
C.View Tab
D.File > Print
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.A button to save the file
C.A type of drill down
D.Information that appears when you hover over a data point
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.Public
D.Organizational
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.Right-click the canvas
B.File > Rename
C.Double-click the page tab at the bottom
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 install the mobile app
B.To text the report to phones
C.To reduce file size
D.To design a vertical view specifically for phone screens
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.Tree Map
B.Gauge Chart
C.Pie Chart
D.Scatter Plot
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.File
C.Online Services
D.Azure
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.Prevents visuals from being moved or resized
D.Encrypts the data
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.2 GB
B.512 MB
C.4 GB or more
D.1 GB
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.Modeling Tab > Manage Roles
B.File > Options
C.Home Tab > Security
D.Insert > Roles
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 Template file
B.A temporary file
C.A Power BI Theme file
D.A corrupted 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.Refresh
B.Reload
C.Update
D.Requery
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.No, PDF is not supported
D.Yes, using the PDF connector
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.Right click the canvas
B.Reinstall Power BI
C.View Tab > Show panes > Select Data/Fields
D.Press Ctrl+Alt+Delete
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.
Incorrect! Try again.
Did this save you a night before the exam?
LPU Notes is free, and it stays free. Ads cover part of the server bill.
The rest comes out of a student's own pocket: the domain, the storage,
and keeping the site up through the weeks everyone needs it at once.
The payment button didn't load. An ad blocker or a filtered network is the usual reason.
to try again.
Nothing here is ever locked, and nothing unlocks. Chip in only if it was worth it.
What it pays for →