1What is the primary purpose of Microsoft Power BI?
A.Word processing
B.Business Intelligence and Data Visualization
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 Mobile
D.Power BI Text Editor
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..xlsx
B..pbix
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.Get Data
D.Share Dashboard
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 Map
D.Power Q&A
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.Linux
C.Windows
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 has more features
B.It updates automatically
C.It is faster
D.It allows offline access
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.Filter Pane
D.Selection 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.Home, Insert, View
C.Query, Design, Layout
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.SQL
C.DAX
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.Format Pane
B.File > Options and settings > Options
C.Insert Tab
D.Help Menu
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 create relationships between tables
C.To design the dashboard background
D.To enter data manually
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.Publishes the report
C.Opens the Power Query Editor
D.Refreshes the visuals
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.Excel Workbook
B.SQL Server Database
C.Web Page
D.Physical Paper Documents
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 central area where visuals are arranged
C.The data connection screen
D.The sign-in window
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 tool to cut data connection
B.A visual used to filter other visuals on the page
C.A function to divide numbers
D.A type of pie chart
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.Show Data / See Records
C.Zoom
D.Focus Mode
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.Monthly
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 blurs the background
B.It expands the visual to fill the entire canvas
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.Bookmarks Pane
D.Sync Slicers 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.A work or school email address
C.A credit card
D.Windows 11
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 this visual
B.Filters on this page
C.Filters on all pages
D.Drillthrough filters
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 SQL code
C.It shows the report settings
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.Security options
C.Privacy options
D.Regional 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.A multi-page report in Desktop
B.A single-page canvas in Power BI Service utilizing pinned tiles
C.The loading screen
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.Q&A
B.Smart Narrative
C.Key Influencers
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 file is saved to your hard drive
B.The report is uploaded to your workspace in Power BI Service
C.The report is emailed to your boss
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.Home
B.Modeling
C.Insert
D.View
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.Drawing freehand shapes
B.Copying formatting from one visual to another
C.Changing data types
D.Painting the background color
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.Home
C.Help
D.External Tools
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 enable new features that are still in development
C.To view the data source
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 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.Build charts
B.Inspect and filter raw data rows
C.Create visuals
D.Publish reports
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 remains in the source and is queried live
B.Data is copied into the Power BI file and stored in memory
C.Data is only available when online
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 deletes the bar
B.It cross-highlights related data in other visuals
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.Canvas Settings in the Format Pane
B.File > Print
C.View Tab
D.Home Tab
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 type of drill down
D.A button to save the file
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.Public
B.Organizational
C.Private
D.General
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.Right-click the canvas
C.File > Rename
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 design a vertical view specifically for phone screens
C.To text the report to phones
D.To reduce file size
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.Pie Chart
B.Gauge Chart
C.Scatter Plot
D.Tree Map
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.Azure
D.Online Services
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.Encrypts the data
B.Prevents visuals from being moved or resized
C.Stops data refresh
D.Locks the file with a password
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.1 GB
B.2 GB
C.4 GB or more
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.Modeling Tab > Manage Roles
B.Home Tab > Security
C.File > Options
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 corrupted file
C.A temporary file
D.A Power BI Theme 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.Refresh
C.Reload
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.No, PDF is not supported
B.Yes, using the PDF connector
C.Only if converted to Excel first
D.Only images from PDF
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.Reinstall Power BI
B.View Tab > Show panes > Select Data/Fields
C.Right click the canvas
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.
Give Feedback
Help us improve by sharing your thoughts or reporting issues.