1What is the primary purpose of Microsoft Power BI?
A.Video Editing
B.Operating System Management
C.Business Intelligence and Data Visualization
D.Word processing
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 Mobile
D.Power BI Service
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..docx
C..pbit
D..pbix
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.Get Data
B.Share Dashboard
C.Create Visualizations
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 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.Android (Desktop Mode)
B.Linux
C.Windows
D.MacOS
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 updates automatically
D.It is faster
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.Visualizations Pane
B.Fields 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.Query, Design, Layout
B.Report, Table (Data), Model
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.Java
B.DAX
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.File > Options and settings > Options
B.Help Menu
C.Insert Tab
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 write SQL queries
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.Publishes the report
B.Opens the Power Query Editor
C.Changes the chart type
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.Physical Paper Documents
B.SQL Server Database
C.Excel Workbook
D.Web Page
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 function to divide numbers
C.A type of pie chart
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.Weekly
B.Daily
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 filters the data to top 10
B.It expands the visual to fill the entire canvas
C.It blurs the background
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.Bookmarks Pane
B.Sync Slicers Pane
C.Selection 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.Desktop is paid, Service is free
B.Service is for authoring, Desktop is for viewing
C.Desktop is for authoring/creation, Service is for sharing/collaboration
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 personal email address (e.g., @gmail.com)
B.Windows 11
C.A credit card
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.Filters on this page
B.Filters on all pages
C.Filters on this visual
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 the SQL code
B.It shows available tables and columns
C.It shows the color palette
D.It shows the report settings
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.Regional options
B.Data Load options
C.Security options
D.Privacy 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.The data modeling view
C.The loading screen
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.Key Influencers
B.Q&A
C.Smart Narrative
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 printed
C.The report is emailed to your boss
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.Insert
B.View
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.Painting the background color
B.Drawing freehand shapes
C.Copying formatting from one visual to another
D.Changing data types
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.Help
B.View
C.Home
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 view the data source
B.To enable new features that are still in development
C.To preview the mobile layout
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.Azure Analysis Services
B.Power Automate
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.Publish reports
C.Create visuals
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 remains in the source and is queried live
B.Data is only available when online
C.Data is strictly read-only and cannot be transformed
D.Data is copied into the Power BI file and stored in memory
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 does nothing
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.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 type of drill down
C.A button to save the file
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.General
B.Private
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.View > Page Name
B.Double-click the page tab at the bottom
C.File > Rename
D.Right-click the canvas
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 text the report to phones
B.To install the mobile app
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.Pie Chart
B.Gauge Chart
C.Tree Map
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.Online Services
C.File
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.Prevents visuals from being moved or resized
B.Encrypts the data
C.Locks the file with a password
D.Stops data refresh
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.1 GB
D.4 GB or more
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.Home Tab > Security
B.File > Options
C.Modeling Tab > Manage Roles
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 Power BI Theme file
D.A temporary 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.Update
C.Requery
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.Reinstall Power BI
B.Right click the canvas
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.