1What is the primary purpose of Microsoft Power BI?
A.Word processing
B.Video Editing
C.Business Intelligence and Data Visualization
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 Text Editor
B.Power BI Mobile
C.Power BI Service
D.Power BI Desktop
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 Map
B.Power Query Editor
C.Power Q&A
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.Linux
B.Android (Desktop Mode)
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 updates automatically
B.It allows offline access
C.It is faster
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.Selection Pane
B.Visualizations Pane
C.Filter Pane
D.Fields 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.SQL
C.Java
D.DAX
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.Help Menu
B.Format Pane
C.File > Options and settings > Options
D.Insert Tab
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 create relationships between tables
B.To enter data manually
C.To write SQL queries
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.Changes the chart type
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.Web Page
B.Physical Paper Documents
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 formula bar
B.The central area where visuals are arranged
C.The sign-in window
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 function to divide numbers
B.A tool to cut data connection
C.A visual used to filter other visuals on the page
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.Focus Mode
D.Zoom
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.Annually
C.Daily
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 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.Sync Slicers Pane
B.Filter Pane
C.Selection 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.Service is for authoring, Desktop is for viewing
B.Desktop is paid, Service is free
C.They are the same thing
D.Desktop is for authoring/creation, Service is for sharing/collaboration
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 work or school email address
B.A credit card
C.A personal email address (e.g., @gmail.com)
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 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 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.Security options
B.Data Load options
C.Regional 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.The loading screen
B.The data modeling view
C.A single-page canvas in Power BI Service utilizing pinned tiles
D.A multi-page report in Desktop
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.Decomposition Tree
D.Key Influencers
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.Modeling
C.Insert
D.Home
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.Drawing freehand shapes
D.Copying formatting from one visual to another
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.External Tools
C.View
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 preview the mobile layout
B.To view the data source
C.To enable new features that are still in development
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 BI Report Server
C.Power BI Gateway
D.Power Automate
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 remains in the source and is queried live
B.Data is only available when online
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 opens a new webpage
B.It cross-highlights related data in other visuals
C.It does nothing
D.It deletes the bar
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.File > Print
C.Canvas Settings in the Format Pane
D.View 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 button to save the file
B.A type of drill down
C.Information that appears when you hover over a data point
D.A tip on how to use the tool
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.Private
C.Organizational
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.File > Rename
B.Double-click the page tab at the bottom
C.View > Page Name
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 design a vertical view specifically for phone screens
C.To install the mobile app
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.Scatter Plot
B.Tree Map
C.Pie Chart
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.Azure
C.File
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.Stops data refresh
B.Encrypts the data
C.Locks the file with a password
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.512 MB
B.1 GB
C.2 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.Modeling Tab > Manage Roles
B.Home Tab > Security
C.Insert > Roles
D.File > Options
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 temporary file
B.A corrupted file
C.A Power BI Template 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.Reload
B.Update
C.Refresh
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.No, PDF is not supported
C.Yes, using the PDF connector
D.Only if converted to Excel first
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.View Tab > Show panes > Select Data/Fields
B.Press Ctrl+Alt+Delete
C.Right click the canvas
D.Reinstall Power BI
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.