1. What is Power BI?

a. A business analytics tool

b. A database management system
c. A project management software
d. A graphic design tool

Answer: a. A business analytics tool

Explanation: Power BI is a business analytics tool developed by Microsoft. It

allows users to connect, visualize, and analyze data from various sources,
including cloud services and on-premises databases.

2. Which of the following is a data visualization feature in Power BI?

a. Charts
b. Word processing
c. Video editing
d. Animation

Answer: a. Charts

Explanation: Power BI provides a variety of charts and graphs, including bar

charts, line charts, pie charts, and scatter plots, to help users visualize their
data.

3. Which programming language is used to create custom visuals in

Power BI?
a. Python
b. C#
c. Java
d. R

Answer: d. R

Explanation: R is a programming language used for statistical computing

and graphics. It is one of the supported languages for creating custom
visuals in Power BI.

4. Which of the following is NOT a data source that can be used in Power
BI?

a. Excel spreadsheets
b. JSON files
c. Oracle databases
d. Adobe Photoshop files

Answer: d. Adobe Photoshop files

Explanation: Power BI can connect to various data sources, including Excel

spreadsheets, JSON files, and Oracle databases, but it cannot connect to
Adobe Photoshop files.

5. Which of the following is a data transformation feature in Power BI?

a. Data modeling
b. Data visualization
c. Data exploration
d. Data cleansing

Answer: d. Data cleansing

Explanation: Data cleansing is a data transformation feature in Power BI

that allows users to clean, transform, and reshape data to prepare it for
analysis.

6. Which of the following is a visualization option in Power BI?

a. Pivot table
b. Histogram
c. Bubble chart
d. All of the above

Answer: d. All of the above

Explanation: Power BI offers various visualization options, including pivot

tables, histograms, and bubble charts, to help users analyze and interpret
their data.

7. What is a dashboard in Power BI?

a. A visual representation of data that provides an at-a-glance view of key

metrics
b. A report that contains detailed information about a specific topic or area
c. A data source that provides access to raw data for analysis
d. A collaboration tool that allows users to share and work on data together
Answer: a. A visual representation of data that provides an at-a-glance view
of key metrics

Explanation: A dashboard in Power BI is a visual representation of data that

provides an at-a-glance view of key metrics and performance indicators for a
business or organization.

8. What is a measure in Power BI?

a. A calculation based on data in a dataset

b. A visualization option for displaying data
c. A filter that restricts the amount of data displayed in a report
d. A connection to a data source

Answer: a. A calculation based on data in a dataset

Explanation: A measure in Power BI is a calculation based on data in a

dataset. Measures can be used to perform calculations such as sums,
averages, and percentages.

9. Which of the following is a way to filter data in Power BI?

a. Slicer
b. Histogram
c. Scatter plot
d. Line chart

Answer: a. Slicer
Explanation: A slicer is a way to filter data in Power BI. Slicers allow users to
interactively filter data by selecting one or more values from a list.

10. What is the purpose of Power Query in Power BI?

a. To import, transform, and combine data from various sources

b. To create custom visuals for data visualization
c. To analyze and visualize data
d. To create and manage data models

Answer: a. To import, transform, and combine data from various sources

Explanation: Power Query is a data transformation and cleaning tool in

Power BI that allows users to import, transform, and combine data from
various sources.

11. What is the purpose of Power Pivot in Power BI?

a. To import and transform data from various sources

b. To create and manage data models
c. To analyze and visualize data
d. To share reports and dashboards with other users

Answer: b. To create and manage data models

Explanation: Power Pivot is a data modeling tool in Power BI that allows

users to create and manage data models. It allows users to define
relationships between tables and create calculated columns and measures.
12. Which of the following is a way to create a new measure in Power
BI?

a. Using DAX formula language

b. Using SQL query language
c. Using Python programming language
d. Using JavaScript programming language

Answer: a. Using DAX formula language

Explanation: DAX (Data Analysis Expressions) is a formula language used to

create measures and calculated columns in Power BI.

13. What is the purpose of Power View in Power BI?

a. To create and share reports and dashboards

b. To import and transform data from various sources
c. To analyze and visualize data
d. To create and manage data models

Answer: c. To analyze and visualize data

Explanation: Power View is a data visualization tool in Power BI that allows

users to create interactive, visual reports and dashboards to analyze and
visualize data.

14. Which of the following is a way to share a report or dashboard in

Power BI?
a. Publish to the Power BI service
b. Export to a PDF file
c. Share via email
d. All of the above

Answer: a. Publish to the Power BI service

Explanation: The recommended way to share a report or dashboard in

Power BI is to publish it to the Power BI service. This allows other users to
view and interact with the report or dashboard in a web browser.

15. What is the purpose of the Power BI service?

a. To create and manage data models

b. To import and transform data from various sources
c. To analyze and visualize data
d. To share reports and dashboards with other users

Answer: d. To share reports and dashboards with other users

Explanation: The Power BI service is a cloud-based platform that allows

users to share reports and dashboards with other users. It also provides
additional features such as collaboration, data exploration, and
administration.

16. Which of the following is a way to connect to a data source in Power

BI?

a. Using a web browser

b. Using a command-line interface
c. Using an API
d. All of the above

Answer: a. Using a web browser

Explanation: The most common way to connect to a data source in Power BI

is to use a web browser. Power BI also provides other methods such as
command-line interfaces and APIs for connecting to data sources.

17. What is the purpose of the Query Editor in Power BI?

a. To create and manage data models

b. To import and transform data from various sources
c. To analyze and visualize data
d. To share reports and dashboards with other users

Answer: b. To import and transform data from various sources

Explanation: The Query Editor in Power BI is a data transformation and

cleaning tool that allows users to import, transform, and combine data from
various sources.

18. Which of the following is a way to filter data in Power BI?

a. Using a slicer
b. Using a chart
c. Using a table
d. All of the above

Answer: a. Using a slicer

Explanation: Slicers are visual controls in Power BI that allow users to filter
data in a report or dashboard. They can be used with charts, tables, and
other visualizations.

19. Which of the following is a way to create a hierarchy in Power BI?

a. Using the Fields pane

b. Using the Filters pane
c. Using the Visualizations pane
d. Using the Pages pane

Answer: a. Using the Fields pane

Explanation: The Fields pane in Power BI allows users to create hierarchies

by dragging and dropping fields onto each other. Hierarchies can be used to
drill down into data and explore relationships between data points.

20. Which of the following is a way to create a calculated column in

Power BI?

a. Using DAX formula language

b. Using SQL query language
c. Using Python programming language
d. Using JavaScript programming language

Answer: a. Using DAX formula language

Explanation: DAX (Data Analysis Expressions) is a formula language used to

create calculated columns and measures in Power BI. Calculated columns
can be used to add new columns to a table based on a DAX expression.
21. What is the purpose of the Q&A feature in Power BI?

a. To allow users to ask natural language questions and get answers from
data
b. To create and share reports and dashboards
c. To analyze and visualize data
d. To create and manage data models

Answer: a. To allow users to ask natural language questions and get answers
from data

Explanation: The Q&A feature in Power BI allows users to ask natural

language questions about data and get answers in the form of visualizations
and reports. It uses natural language processing and machine learning
algorithms to understand user queries and generate results.

22. Which of the following is a way to create a report in Power BI?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using a mobile app
d. All of the above

Answer: a. Using the Power BI desktop application

Explanation: The Power BI desktop application is a Windows application that

allows users to create and edit reports and dashboards. It provides advanced
features for data modeling, data transformation, and data visualization.

23. What is the purpose of the Power BI mobile app?

a. To create and share reports and dashboards
b. To analyze and visualize data
c. To view and interact with reports and dashboards on mobile devices
d. To create and manage data models

Answer: c. To view and interact with reports and dashboards on mobile

devices

Explanation: The Power BI mobile app allows users to view and interact with
reports and dashboards on mobile devices such as smartphones and tablets.
It provides features such as touch-based navigation, drill-down, and offline
access.

24. Which of the following is a way to create a dashboard in Power BI?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using a mobile app
d. All of the above

Answer: b. Using the Power BI service

Explanation: Dashboards in Power BI can be created using the Power BI

service. They allow users to view key metrics and performance indicators in a
single, interactive view.

25. What is the purpose of the Power BI API?

a. To allow integration with other applications and services

b. To analyze and visualize data
c. To create and share reports and dashboards
d. To create and manage data models

Answer: a. To allow integration with other applications and services

Explanation: The Power BI API allows developers to programmatically

interact with Power BI to perform tasks such as embedding Power BI reports
and dashboards in other applications, automating report generation and
distribution, and managing Power BI content and resources.

26. Which of the following is a way to share a report in Power BI?

a. Publishing to the Power BI service

b. Exporting to a PDF file
c. Sharing a link to the report
d. All of the above

Answer: d. All of the above

Explanation: Reports in Power BI can be shared in multiple ways, including

publishing to the Power BI service, exporting to a PDF file, and sharing a link
to the report.

27. Which of the following is a way to create a custom visual in Power

BI?

a. Using the Visualizations pane

b. Using the Fields pane
c. Using the Format pane
d. Using the Developer tools
Answer: d. Using the Developer tools

Explanation: Power BI provides developer tools for creating custom visuals

using HTML, CSS, and JavaScript. Custom visuals can be used to create
unique data visualizations and add additional functionality to Power BI
reports and dashboards.

28. Which of the following is a way to perform data modeling in Power

BI?

a. Using the Data view

b. Using the Visualizations pane
c. Using the Format pane
d. Using the Developer tools

Answer: a. Using the Data view

Explanation: The Data view in Power BI allows users to perform data

modeling tasks such as creating relationships between tables, creating
calculated columns, and applying filters to data.

29. Which of the following is a way to format a visual in Power BI?

a. Using the Visualizations pane

b. Using the Fields pane
c. Using the Format pane
d. Using the Developer tools

Answer: c. Using the Format pane

Explanation: The Format pane in Power BI allows users to format visuals in a
report or dashboard. It provides options for changing colors, fonts, and other
visual properties.

30. Which of the following is a way to create a measure in Power BI?

a. Using the Data view

b. Using the Visualizations pane
c. Using the Format pane
d. Using the Developer tools

Answer: a. Using the Data view

Explanation: Measures in Power BI are created using the Data view. They
are used to perform calculations on data, such as sums, averages, and
percentages.

31. What is the purpose of the Power BI paginated report?

a. To create interactive and visually appealing reports and dashboards

b. To create static and printable reports
c. To create ad-hoc reports and analysis
d. To create reports that can be embedded in other applications

Answer: b. To create static and printable reports

Explanation: Power BI paginated reports are designed to create static,

printable reports that are optimized for printing or generating PDF
documents. They are ideal for creating forms, invoices, and other types of
structured documents.
32. Which of the following is a way to create a Power BI paginated
report?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using SQL Server Reporting Services (SSRS)
d. All of the above

Answer: c. Using SQL Server Reporting Services (SSRS)

Explanation: Power BI paginated reports are created using SQL Server

Reporting Services (SSRS), a reporting platform that is integrated with Power
BI. Paginated reports can be published to the Power BI service and shared
with users.

33. Which of the following is a way to embed a Power BI report in a

website or application?

a. Using the Power BI web part in SharePoint

b. Using the Power BI JavaScript API
c. Using the Power BI mobile app
d. Using the Power BI Report Server

Answer: b. Using the Power BI JavaScript API

Explanation: The Power BI JavaScript API allows developers to embed Power

BI reports and dashboards in other applications and web pages. It provides a
set of JavaScript functions that can be used to interact with Power BI content.

34. Which of the following is a way to create a Power BI dashboard?

a. Using the Power BI desktop application
b. Using the Power BI service
c. Using the Power BI mobile app
d. All of the above

Answer: b. Using the Power BI service

Explanation: Power BI dashboards are created using the Power BI service.

They allow users to create visualizations that provide a high-level overview of
data from multiple sources.

35. Which of the following is a way to access Power BI content offline?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. None of the above

Answer: c. Using the Power BI mobile app

Explanation: The Power BI mobile app allows users to access Power BI

content offline by downloading reports and dashboards to their mobile
devices.

36. What is the purpose of the Power BI data gateway?

a. To connect to on-premises data sources from the Power BI service

b. To create and manage data models in Power BI
c. To create custom visuals for Power BI reports and dashboards
d. To manage user access to Power BI content
Answer: a. To connect to on-premises data sources from the Power BI
service

Explanation: The Power BI data gateway is used to connect to on-premises

data sources from the Power BI service. It allows users to securely access
data that is located behind a firewall or on a private network.

37. Which of the following is a way to create a Power BI data gateway?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. Using the Power BI gateway installer

Answer: d. Using the Power BI gateway installer

Explanation: The Power BI gateway installer is used to create a Power BI

data gateway. It can be downloaded from the Power BI service and installed
on a computer or server that is connected to the on-premises data source.

38. What is the purpose of the Power BI premium capacity?

a. To increase the performance and scalability of Power BI reports and

dashboards
b. To provide additional data modeling capabilities in Power BI
c. To create custom visuals for Power BI reports and dashboards
d. To manage user access to Power BI content

Answer: a. To increase the performance and scalability of Power BI reports

and dashboards
Explanation: The Power BI premium capacity is used to increase the
performance and scalability of Power BI reports and dashboards. It provides
additional processing power and memory, allowing users to work with larger
datasets and more complex reports.

39. Which of the following is a way to create a Power BI premium

capacity?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. None of the above

Answer: b. Using the Power BI service

Explanation: The Power BI service allows users to create a Power BI

premium capacity. This can be done by purchasing a Power BI Premium
license and then assigning the capacity to a workspace in the Power BI
service.

40. What is the purpose of Power BI Embedded?

a. To embed Power BI content in other applications

b. To provide additional data modeling capabilities in Power BI
c. To manage user access to Power BI content
d. To increase the performance and scalability of Power BI reports and
dashboards

Answer: a. To embed Power BI content in other applications

Explanation: Power BI Embedded allows developers to embed Power BI
reports and dashboards in other applications and web pages. It provides a
set of APIs that can be used to interact with Power BI content.

41. Which of the following is a way to create a Power BI Embedded

solution?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. Using the Power BI Embedded SDK

Answer: d. Using the Power BI Embedded SDK

Explanation: The Power BI Embedded SDK is used to create a Power BI

Embedded solution. It provides a set of APIs that can be used to embed
Power BI content in other applications and web pages.

42. Which of the following is a way to customize the appearance of a

Power BI report?

a. Using custom themes

b. Using custom visuals
c. Using custom tooltips
d. All of the above

Answer: d. All of the above

Explanation: Power BI reports can be customized using custom themes,
custom visuals, and custom tooltips. This allows users to create reports that
match the branding and style of their organization.

43. What is the purpose of Power BI paginated reports?

a. To provide a high-level overview of data from multiple sources

b. To create interactive data visualizations
c. To create pixel-perfect, paginated reports for printing and PDF generation
d. To embed Power BI content in other applications

Answer: c. To create pixel-perfect, paginated reports for printing and PDF

generation

Explanation: Power BI paginated reports are used to create pixel-perfect,

paginated reports that are optimized for printing and PDF generation. They
provide precise control over the layout and formatting of the report.

44. Which of the following is a way to schedule the refresh of a Power BI

dataset?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. None of the above

Answer: b. Using the Power BI service

Explanation: The Power BI service allows users to schedule the refresh of a
Power BI dataset. This can be done by configuring a refresh schedule in the
dataset settings.

45. Which of the following is a way to monitor the performance of a

Power BI report?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. None of the above

Answer: b. Using the Power BI service

Explanation: The Power BI service provides tools for monitoring the

performance of a Power BI report. This includes metrics such as page load
time, rendering time, and query duration.

46. Which of the following is a way to set up row-level security in Power

BI?

a. Using DAX formulas

b. Using Power Query
c. Using Power Automate
d. None of the above

Answer: a. Using DAX formulas

Explanation: Row-level security in Power BI can be set up using DAX
formulas. This allows users to define which rows of data are visible to which
users or groups.

47. Which of the following is a way to export data from a Power BI

report?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. All of the above

Answer: b. Using the Power BI service

Explanation: Data from a Power BI report can be exported using the Power
BI service. This can be done by selecting the desired visualization, clicking the
ellipsis button, and selecting “Export data”.

48. Which of the following is a way to share a Power BI report with

others?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. All of the above

Answer: d. All of the above

Explanation: Power BI reports can be shared with others using the Power BI
desktop application, the Power BI service, and the Power BI mobile app. This
allows users to collaborate and share insights with their colleagues.

49. Which of the following is a way to create a calculated table in Power

BI?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. None of the above

Answer: a. Using the Power BI desktop application

Explanation: Calculated tables in Power BI can be created using the Power

BI desktop application. This can be done by using the DAX formula language
to define the table based on the underlying data.

50. Which of the following is a way to create a data model in Power BI?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. All of the above

Answer: a. Using the Power BI desktop application

Explanation: Data models in Power BI can be created using the Power BI

desktop application. This can be done by importing data from various
sources and then using the Power Query Editor and DAX formulas to
transform and model the data.

51. Which of the following is a way to add custom visuals to a Power BI

report?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. None of the above

Answer: a. Using the Power BI desktop application

Explanation: Custom visuals can be added to a Power BI report using the

Power BI desktop application. This can be done by importing the custom
visual from the marketplace and then adding it to the report canvas.

52. Which of the following is a way to create a drillthrough in Power BI?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. All of the above

Answer: a. Using the Power BI desktop application

Explanation: Drillthroughs in Power BI can be created using the Power BI

desktop application. This can be done by selecting the desired visual and
configuring the drillthrough options in the Visualizations pane.
53. Which of the following is a way to create a paginated report in
Power BI?

a. Using the Power BI desktop application

b. Using the Power BI service
c. Using the Power BI mobile app
d. None of the above

Answer: d. None of the above

Explanation: Paginated reports in Power BI are created using the Power BI

Report Builder application, which is a separate tool from the Power BI
desktop application and the Power BI service.

54. Which of the following is a way to refresh data in a Power BI report?

a. Manually refreshing the report in the Power BI desktop application

b. Scheduling automatic refreshes in the Power BI service
c. Using Power Automate to trigger a refresh
d. All of the above

Answer: d. All of the above

Explanation: Data in a Power BI report can be refreshed manually in the

Power BI desktop application, scheduled for automatic refreshes in the
Power BI service, or triggered by a Power Automate flow.

55. Which of the following is a way to use natural language queries in

Power BI?
a. Using the Q&A feature in the Power BI service
b. Using the Power BI mobile app
c. Using the Power BI desktop application
d. All of the above

Answer: d. All of the above

Explanation: Natural language queries can be used in Power BI through the

Q&A feature in the Power BI service, the Power BI mobile app, and the Power
BI desktop application. This allows users to ask questions in everyday
language and get answers in the form of interactive visuals.

1. Contains reference data such as descriptive attributes__________________

1. Fact table
2. Query table
3. Dimension table
4. Power BI table
Answer: Dimension table
2. What is the recommend method to share your reports?
1. Publish them to the Power BI service
2. Create a PDF of the report, and share the PDF with others
3. Copy the .PBIX file to a file folder, and give coworkers access to that folder
4. None
Answer: Publish them to the Power BI service
3. What symbol would you use for multiplication in Power BI in a DAX formula?
1. +
2. –
3. /
4. *
Answer: *
4. Berikut contoh fungsi COUNTING, kecuali________________
1. MAX
2. COUNT
3. COUNTROWS
4. None
Answer: MAX
5. Type of data modeling in Power BI that Uses Data Analysis Expressions and similar
to Excel formulas______________
1. Query
2. DAX
3. Model
4. None
Answer: DAX
6. Berikut contoh LOGICAL Functions di DAX, kecuali____________
1. OR
2. IF
3. SUMX
4. NOT
Answer: SUMX
7. Fungsi yang termasuk di kategori TEXT FUNCTION_______________
1. IF
2. DATE
3. CONCATENATE
4. COUNT
Answer: CONCATENATE
8. Sometimes, referred to as Power BI online______________
1. Power BI
2. Power BI Service
3. Query Editor
4. Visual Market Place
Answer: Power BI Service
9. Creates the connection between Power BI cloud-based data and the data source
located on-premises_______________
1. Report view
2. Query editor
3. Power BI service
4. Gateway
Answer: Gateway
10. Calculate a result from an expression formula and the result can only be viewed in
the visualization______________
1. Filter
2. Function
3. Calculated column
4. Measures
Answer: Measures
11. What is the common flow of activity in Power BI?
 1. Create a report in the Power BI service, share it to Power BI mobile, interact with
it in Power BI Desktop
2. Bring data into Power BI Desktop and create a report, share it to the Power BI
service, view and interact with reports and dashboards in the service and Power
BI mobile
3. Create a report in Power BI mobile, share it to the Power BI Desktop, view and
interact in the Power BI service
4. Bring data into Power BI mobile, create a report, then share it to Power BI
Desktop
Answer: Bring data into Power BI Desktop and create a report, share it to the
Power BI service, view and interact with reports and dashboards in the service and
Power BI mobile
12. A collection of software services, apps, and connectors to turn unrelated sources
of data into coherent insights_________________
1. Power BI
2. Power Service
3. Query Editor
4. Visual Market Place
Answer: Power BI
13. Which of the following illustrates a Many to One relationship?
1. Many banana trees planted in more than 1 garden
2. 1 banana tree having many bananas on the tree
3. Many gardens having no banana trees
4. Many banana trees planted in a garden
Answer: Many banana trees planted in a garden
14. Which of the following statements is true about shaping data with Power BI
Desktop_____________
1. When shaping or transforming data in Power BI Desktop, the source data remains
unchanged
2. When shaping or transforming data in Power BI Desktop, the source data is also
shaped and transformed
3. The order in which you shape or transform data doesn’t matter, it all comes out
the same
4. None of these
Answer: When shaping or transforming data in Power BI Desktop, the source data
remains unchanged
15.The following are examples of the AGGREGATION function except__________________
1. Logical Functions
2. Aggregation Functions
3. Semua benar
 4. Date Functions
Answer: Semua benar
16. What is the SQL expression used to count the values in a table?
1. SUM
2. COUNT
3. DISTINCT
4. AVERAGE
Answer: COUNT
17. Which of the following tools let you shape data sources?
1. The Relationships view in Power BI Desktop
2. The Power BI admin portal
3. The Power BI Gateway
4. Power Query Editor in either Power BI Desktop or Power BI Service
Answer: Power Query Editor in either Power BI Desktop or Power BI Service
18. A customer may purchase 1 or many products. So the relationship between the
customer table and the products table will be_________________
1. One to Many
2. Many to Many
3. Many to One
4. One to One
Answer: One to Many
19. The topic of discussion of Power BI Session 4 is_______________
1. Data Collection
2. Introduction to DAX
3. Data Preparation
4. Overview
Answer: Introduction to DAX
20. A function that can only work on numeric fields is_______________
1. ISNUMBER
2. AVERAGE
3. AND
4. CONCATENATE
Answer: AVERAGE
21. Which is used to calculate the data in each row__________________
1. Calculated Row
2. Measure
3. Counting
4. Calculated Colum
Answer: Calculated Colum
22. Contains transactional data or facts of a business process_______________
 1. Fact table
2. Query table
3. Dimension table
4. Power BI table
Answer: Fact table
23. Which of these values would be matched using the syntax LIKE “%apple”
1. star apple
2. banapple
3. peach apple
4. All of mentioned above
Answer: All of mentioned above
24. What are the group of data sources can Power BI connect to?
1. Files, Content Packs, Connectors
2. Databases, SQL, Azure
3. Files, SQL, Azure
4. Content Packs, Connectors, SQL
Answer: Files, Content Packs, Connectors
25. What DAX function can be used to return a value in a column if a condition is met?
1. IF
2. VLOOKUP
3. SUM
4. COUNT
Answer: IF
26. What expression is used to indicate the table where the values would be searched
from?
1. WHERE
2. FROM
3. TABLE
4. SELECT
Answer: FROM
27. What is the SQL command to return the values from a table?
1. SELECT
2. WHERE
3. DISTINCT
4. ORDER BY
Answer: SELECT
28. What is the Power Bi file Format?
1. .xlsx
2. .pbi
3. .pbix
 4. .xls
Answer: .pbix
29. A collection of data that you import or connect to___________
1. Dashboards
2. Reports
3. Datasets
4. All of the above
Answer: Datasets
30. Which of the following are building blocks of Power BI?
1. Visualizations, datasets, reports, dashboards, tiles
2. Visual Studio, C#, and JSON files
3. Tiles, dashboards, databases, mobile device
4. None of the above
Answer: Visualizations, datasets, reports, dashboards, tiles