Microsoft Power BI Practice Test
Microsoft released Power BI Embedded in which year?
Explanation:
In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform. One
main differentiator of the product is the ability to load custom visualizations.
Power BI was released to the general public for the first time on
Explanation:
Power BI was first discharged to the overall population on July 31, 2025July 31, 2025administrator Power BI was
first discharged to the overall population on 2015
The initial release of Power BI was dependent on the
Explanation:
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation,
graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very
widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the
industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.
The data limit point of confinement in the free Power BI adaption is...
Explanation:
Power BI has a limit of 1GB/client data in free Version.
BI is still in use for...
Explanation:
Microsoft Power BI is a business intelligence platform that provides tools for aggregating, analyzing, displaying, and
sharing data to nontechnical business users. For Excel users, Power BI's user interface is pretty intuitive, and its strong
connectivity with other Microsoft applications makes it an extremely adaptable self-service tool with minimal upfront training.
Power BI Plus is available for a month-to-month membership fee of less than how much US$ per license?
Explanation:
Power BI (free) and Power BI Pro. As of this writing, the cost for Power BI Pro is $9.99 / user / month.
Power Bl portable application is accessible for all these with the exception of—
Explanation:
The answer is the Blackberry.
What is the number of GB/client in Power BI Pro?
Explanation:
Power BI Pro allows you up to 10 GB per Power BI Pro License. The free version caps you at 1GB per user. In Power
BI Pro, you can better schedule data refreshes so that your team always has the latest version of your data.
Ron George composed it in the middle of the year...
Explanation:
It was initially composed by Ron George in the mid-year of 2010.
Project Crescent was formerly available for open download on before it was renamed Power BI.
Explanation:
It was originally designed by Ron George in the summer of 2010 and named Project Crescent. Project Crescent was
initially available for public download on July 11, 2011 bundled with SQL Server Codename Denali. Later renamed to
Power BI it was then unveiled by Microsoft in September 2013 as Power BI for Office 365.
In Power BI, where do you go to edit and reshape data?
Explanation:
Data editing is defined as the process involving the review and adjustment of collected survey data. Data editing helps
define guidelines that will reduce potential bias and ensure consistent estimates leading to a clear analysis of the data
set by correct inconsistent data using the methods later in this article. The purpose is to control the quality of the
collected data. Data editing can be performed manually, with the assistance of a computer or a combination of both.
In Power BI, what isn't a data compose?
Explanation:
Date – Represents just a Date (no time portion). When converted into the model, a Date is the same as a Date/Time
value with zero for the fractional value.
When characterizing a parameter, what isn't an option for suggested esteems?
Explanation:
The correct answer is Any Value
What do you use in Power BI to group your queries?
Explanation:
When you include multiple data sources in an Access query, you use joins to limit the records that you want to see,
based on how the data sources are related to each other. You also use joins to combine records from both data sources,
so that each pair of records from the sources becomes one record in the query results.
What is the relationship between the Countries table and the Fact table in the accompanying illustration?
Explanation:
The correct answer is Numerous to one
What kind of computation should Total Cost be according to best practice in the recipe Total Cost = Sum('Fact'[Cost])?
Explanation:
Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex
formulas in steps makes setting them out much more intuitive.
In inquiry supervisor, what is the M dialect's capacity to sort a segment?
Explanation:
A sort order table is a table that has a row per each value in the column that we want to be sorted (let’s call it; label column),
and the sort order of that value (a numeric column most preferably, we can call it sort order column).
In the question proofreader, what is the option to unpivot data?
Explanation:
The UNPIVOT clause is opposite to the PIVOT clause except that it does not de-aggregate data during the
transposing process.
Which of the following is not a self-service business intelligence tool?
Explanation:
The correct answer is SAP 80
What image would you choose to convey a sense of self-esteem in a solitary situation?
Explanation:
The correct answer is Disseminate Plot
What isn't a Power BI visual that's built-in?
Explanation:
A Power KPI is a simple multi-lined chart that represents base values in the form of lines of different colors. The target
values are highlighted separately in the visual. The Power KPI represents information in both graphic and textual way
making it very informative for the users.
How should you prepare your data for Power BI?
Explanation:
The star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses
and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables.
The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.
Power BI is used by companies such as Facebook, Twilio, GitHub, and MaiIChimp.
Explanation:
The correct answer is Online services
Which Power BI Desktop views are available?
Explanation:
Reports connect to one dataset, or data model, only. Power BI can combine multiple data sources into a single
report. Unlike an Excel spreadsheet, Power BI reports are interactive, with options to filter, slice, and drill down.
The Feature of Natural Language Queries is Available
Explanation:
The correct answer is Power BI Service