Microsoft Power BI Practice Test 1 — Questions and Answers

Question 1: Microsoft released Power BI Embedded in which year?

2016 (Correct answer)
2013
2018
2012

Correct answer: 2016

Microsoft Power BI Embedded was officially released in June 2016. This service allows developers to integrate Power BI reports and dashboards directly into their own applications, providing interactive data visualization capabilities without requiring end-users to have a Power BI account.

Question 2: Power BI was released to the general public for the first time on

2012
2011
2017
2015 (Correct answer)

Correct answer: 2015

Power BI was first released to the general public in July 2015. This marked the official launch of the comprehensive suite of business intelligence tools, offering self-service analytics and data visualization capabilities to a broad audience.

Question 3: The initial release of Power BI was dependent on the

Microsoft PowerPoint
Microsoft Excel (Correct answer)
Microsoft Outlook
Microsoft Word

Correct answer: Microsoft Excel

The initial development and release of Power BI were heavily dependent on Microsoft Excel. It originated as a set of powerful add-ins for Excel, including Power Query, Power Pivot, Power View, and Power Map, which extended Excel's capabilities for data analysis and visualization.

Question 4: The data limit point of confinement in the free Power BI adaption is...

2GB/client
512MB/client
3GB/client
1GB/client (Correct answer)

Correct answer: 1GB/client

The free version of Power BI, known as Power BI Desktop, has a data limit of 1 GB per user for models published to the Power BI service. This limit applies to the size of the dataset that can be stored and refreshed in the cloud.

Question 5: BI is still in use for...

Business Initiation
Business Information
Business Intelligence (Correct answer)
Business Insider

Correct answer: Business Intelligence

BI is an acronym that stands for Business Intelligence. This term encompasses the technologies, applications, and practices used for the collection, integration, analysis, and presentation of business information. Its primary goal is to support better business decision-making.

Question 6: Power BI Plus is available for a month-to-month membership fee of less than how much US$ per license?

$5.00
$30.00
$35.00
$10.00 (Correct answer)

Correct answer: $10.00

Power BI Pro is available for a monthly subscription fee of $10.00 per user per month. This paid tier offers enhanced features compared to the free version, including increased data capacity, collaboration tools, and the ability to share content with other Power BI Pro users.

Question 7: Power Bl portable application is accessible for all these with the exception of—

Windows Phone
IOS
Android
BlackBerry (Correct answer)

Correct answer: BlackBerry

The Power BI mobile application is widely available for major mobile operating systems, including iOS (Apple), Android, and Windows Phone. However, it is not available for BlackBerry devices, reflecting BlackBerry's significantly smaller market share and app ecosystem compared to the other platforms.

Question 8: What is the number of GB/client in Power BI Pro?

4GB/client
10GB/client (Correct answer)
2GB/client
6GB/client

Correct answer: 10GB/client

Power BI Pro offers a significantly higher data limit compared to the free version, allowing for larger and more complex datasets. Specifically, Power BI Pro provides a data limit of 10 GB per user for models published to the Power BI service.

Question 9: Ron George composed it in the middle of the year...

2010 (Correct answer)
2008
2013
2014

Correct answer: 2010

Ron George is widely recognized for his foundational work on what would become Power Pivot, a crucial component of Power BI, around the year 2010. His contributions laid the groundwork for the self-service business intelligence capabilities that Power BI later offered.

Question 10: Project Crescent was formerly available for open download on before it was renamed Power BI.

July 11, 2011 (Correct answer)
July 15, 2012
July 11, 2012
July 18, 2011

Correct answer: July 11, 2011

Project Crescent, an early codename for what later evolved into Power View (a key visualization component of Power BI), was made available for public download on July 11, 2011. It was initially released as part of SQL Server 2012 CTP3, demonstrating Microsoft's early commitment to interactive data reporting.

Question 11: In Power BI, where do you go to edit and reshape data?

Question Editor
Data Transformation
Data Modeling
Data Editing (Correct answer)

Correct answer: Data Editing

In Power BI, the primary tool for editing and reshaping data is the Power Query Editor. This environment allows users to perform various data transformations, clean data, merge queries, and define data types before loading the data into the Power BI data model for analysis and visualization.

Question 12: In Power BI, what isn't a data compose?

Date (Correct answer)
General
Double
Decimal Number

Correct answer: Date

In Power BI, 'Date' is a specific data type used to store temporal values representing a date without a time component. While 'General' (Any), 'Double' (a numeric type), and 'Decimal Number' (another numeric type) are also valid data types, 'Date' specifically categorizes temporal information, distinguishing it from numerical or flexible data representations.

Question 13: When characterizing a parameter, what isn't an option for suggested esteems?

Any Value (Correct answer)
Table
Rundown of Values

Correct answer: Any Value

In Power Query Editor, when defining a parameter, you can specify "Suggested Values" to guide users on what input to provide. These suggested values can come from a "List of Values" (a predefined static list) or be loaded dynamically from a "Table". "Any Value" is not a *suggested value* option; instead, it's a "Type" setting for the parameter itself, indicating that the user can enter any value without predefined suggestions.

Question 14: What do you use in Power BI to group your queries?

Union Queries
There is no alternative
Join Queries (Correct answer)

Correct answer: Join Queries

In Power BI, when you need to combine data from multiple tables or queries based on common columns, you use "Join Queries" (specifically, merge queries in Power Query Editor). This operation links rows from two tables, effectively grouping their data together into a single, more comprehensive query result. This is distinct from appending queries, which stacks rows from tables with identical column structures.

Question 15: What is the relationship between the Countries table and the Fact table in the accompanying illustration?

One to numerous
Numerous to one (Correct answer)
Balanced
Numerous to numerous

Correct answer: Numerous to one

In a typical data model, a 'Countries' table serves as a dimension table, containing unique country entries. A 'Fact' table, which records transactions or events, will often have many rows corresponding to a single country. Therefore, the relationship from the Fact table to the Countries table is 'Many to One' (Numerous to one), meaning many records in the Fact table relate to one unique record in the Countries table.

Question 16: What kind of computation should Total Cost be according to best practice in the recipe Total Cost = Sum('Fact'[Cost])?

Measure
Variable (Correct answer)
Ascertained section
None of the above

Correct answer: Variable

While `Total Cost = Sum('Fact'[Cost])` directly defines a measure in Power BI, best practices for complex DAX calculations often involve using `VAR` (variable) statements. Defining intermediate calculations like `Total Cost` as a variable within a larger measure improves readability, simplifies debugging, and can optimize performance by ensuring the calculation is executed only once. This approach makes the overall DAX expression more modular and maintainable.

Question 17: In inquiry supervisor, what is the M dialect's capacity to sort a segment?

Sort.Table (Correct answer)
Table Sort
Sort Column
Table.Sort

Correct answer: Sort.Table

In Power Query Editor, the M language function used to sort a table by one or more columns is `Table.Sort`. This function takes a table and a list of columns to sort by, along with their respective sort orders (e.g., `Order.Ascending`). Although the option is presented as `Sort.Table`, it refers to the core functionality of sorting data within a table structure in M, which is precisely achieved using the `Table.Sort` function.

Question 18: In the question proofreader, what is the option to unpivot data?

Unpivot different lines
Unpivot lines (Correct answer)
Unpivot lines and sections
Unpivot segments

Correct answer: Unpivot lines

The 'Unpivot' feature in Power Query Editor is used to transform data from a wide format into a tall format, which is often necessary for proper data modeling in Power BI. This process effectively takes multiple columns and converts them into two new columns: one for the attribute name and one for its corresponding value. The option 'Unpivot lines' refers to this operation, where data previously spread across columns is consolidated into fewer, longer 'lines' or rows.

Question 19: Which of the following is not a self-service business intelligence tool?

Tableau
SAP 80 (Correct answer)
MS Power BI
QIikSense

Correct answer: SAP 80

Self-service Business Intelligence (BI) tools empower business users to analyze data and create reports without extensive IT involvement. Tableau, MS Power BI, and QlikSense are all prominent examples of such tools, designed for user-friendly data exploration and visualization. SAP 80, likely referring to older, more traditional SAP BI platforms like SAP BW or earlier versions of BusinessObjects, typically requires significant IT expertise for setup, data modeling, and report development, thus not fitting the self-service paradigm.

Question 20: What image would you choose to convey a sense of self-esteem in a solitary situation?

Framework
Table
Disseminate Plot (Correct answer)
Card

Correct answer: Disseminate Plot

This question appears to be poorly translated, but assuming 'convey a sense of self-esteem in a solitary situation' refers to visualizing individual data points and their distribution, a 'Disseminate Plot' (likely a mistranslation of Scatter Plot) would be the most appropriate. A Scatter Plot displays individual data points as markers, showing the relationship between two numerical variables and revealing patterns, clusters, or outliers among distinct observations. This allows for the examination of each 'solitary' data point's position relative to others.

Question 21: What isn't a Power BI visual that's built-in?

ArcGIS map
Funnel chart
Waterfall char
Power KPI (Correct answer)

Correct answer: Power KPI

Power BI Desktop comes with a rich set of built-in visuals, including common charts like Funnel charts, Waterfall charts, and specialized visuals like ArcGIS maps. 'Power KPI' is not a standard built-in visual; it is typically a custom visual that users can import from the AppSource marketplace to extend Power BI's capabilities. Built-in visuals are available by default in the visualization pane.

Question 22: How should you prepare your data for Power BI?

Include multiple objects
User a star schema (Correct answer)
Load all tables
None of the above

Correct answer: User a star schema

For optimal performance, flexibility, and ease of use in Power BI, it is best practice to prepare your data using a star schema. A star schema organizes data into fact tables (containing measures) and dimension tables (containing descriptive attributes), connected by relationships. This structure simplifies data modeling, improves query performance, and makes it easier for users to create meaningful reports and analyses.

Question 23: Power BI is used by companies such as Facebook, Twilio, GitHub, and MaiIChimp.

Online services (Correct answer)
File data sources
Database data sources
Wiki data sources

Correct answer: Online services

Power BI offers a vast array of data connectors, including those for various online services. Companies like Facebook, Twilio, GitHub, and MailChimp are all examples of online platforms that provide APIs or data exports, allowing Power BI to connect directly to their data as 'Online services' data sources. This enables users to pull data from these platforms for analysis and reporting.

Question 24: Which Power BI Desktop views are available?

Dashboard
Data
Report
Both B and C (Correct answer)

Correct answer: Both B and C

Power BI Desktop provides three primary views for working with your data: Report view, Data view, and Model view. The Report view is where you design your visualizations and dashboards, while the Data view allows you to inspect and transform your raw data. Therefore, both Data and Report views are available in Power BI Desktop.

Question 25: The Feature of Natural Language Queries is Available

Power BI Service (Correct answer)
SSRS
Power BI desktop
Tableau

Correct answer: Power BI Service

The Natural Language Queries feature, known as Q&A, allows users to ask questions about their data using everyday language and receive instant visualizations as answers. This powerful capability is primarily available in the Power BI Service (the online version of Power BI) and embedded Power BI reports, enabling intuitive data exploration for a wider audience. While some limited Q&A functionality might exist elsewhere, its full power resides in the service.

Microsoft Power BI Practice Test 1

Microsoft released Power BI Embedded in which year?