POWER BI

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

2 Mark(s)

Exporting to a PDF file
Publishing to the Power BI service
Sharing a link to the report
All of the above

Q.86.What is a measure in Power BI?

2 Mark(s)

A connection to a data source
A visualization option for displaying data
A calculation based on data in a dataset
A filter that restricts the amount of data displayed in a report

Q.85.What is a dashboard in Power BI?

2 Mark(s)

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

Q.84. Which of the following statements is true about shaping data with Power BI Desktop_____________

2 Mark(s)

When shaping or transforming data in Power BI Desktop, the source data remains unchanged
The order in which you shape or transform data doesn’t matter, it all comes out the same
When shaping or transforming data in Power BI Desktop, the source data is also shaped and transformed
None of these

Q.83.Contains reference data such as descriptive attributes__________________

2 Mark(s)

Fact table
Query table
Dimension table
Power BI table

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

2 Mark(s)

Slicer
Scatter plot
Histogram
Line chart

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

2 Mark(s)

Excel spreadsheets
JSON files
Oracle databases
Adobe Photoshop files

Q.79.Functions that belong to the category of TEXT FUNCTION.

2 Mark(s)

IF
DATE
CONCATENATE
COUNT

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

2 Mark(s)

Pivot table
Histogram
Bubble chart
All of the above

Q.77. Which programming language is used to create custom visuals in Power BI?

2 Mark(s)

Which programming language is used to create custom visuals in Power BI?
C#
Java
R

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

2 Mark(s)

Data modeling
Data visualization
Data exploration
Data cleansing

Q.87.What is the purpose of Power Query in Power BI?

2 Mark(s)

To create and manage data models
To analyze and visualize data
To import, transform, and combine data from various sources
To create custom visuals for data visualization

Q.88.What is the purpose of Power View in Power BI?

2 Mark(s)

To create and share reports and dashboards
To import and transform data from various sources
To analyze and visualize data
To create and manage data models

Q.89.What is the purpose of the Power BI service?

2 Mark(s)

To create and manage data models
To import and transform data from various sources
To analyze and visualize data
To share reports and dashboards with other users

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

2 Mark(s)

Using the Fields pane
Using the Filters pane
Using the Visualizations pane
Using the Pages pane

Q.98.What are the building blocks of Power BI?

2 Mark(s)

Visual Studio, C#, and JSON files
Tiles, dashboards, databases, mobile devices
Visualizations, datasets, reports, dashboards, tiles
None of the above

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

2 Mark(s)

To create and manage data models
To import and transform data from various sources
To analyze and visualize data
To share reports and dashboards with other users

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

2 Mark(s)

Using a slicer
Using a chart
Using a table
All of the above

Q.95.What file format is used for Power BI files?

2 Mark(s)

.xlsx
.pbi
.pbix
.xls

Q.94.Which of the following is a way to connect to a data source in Power BI?

2 Mark(s)

Using a web browser
Using a command-line interface
Using an API
All of the above

Q.93.Which of the following is a way to create a calculated column in Power BI?

2 Mark(s)

Using DAX formula language
Using SQL query language
Using Python programming language
Using JavaScript programming language

Q.92.Which of the following is a way to create a new measure in Power BI?

2 Mark(s)

Using DAX formula language
Using SQL query language
Using Python programming language
Using JavaScript programming language

Q.91.What is the purpose of Power Pivot in Power BI?

2 Mark(s)

To import and transform data from various sources
To create and manage data models
To analyze and visualize data
To share reports and dashboards with other users

Q.90.Which of the following is a way to share a report or dashboard in Power BI?

2 Mark(s)

Publish to the Power BI service
Export to a PDF file
Share via email
All of the above

Q.75.What is Power BI?

2 Mark(s)

business analytics tool
database management system
project management software
graphic design tool

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

2 Mark(s)

Charts
Word processing
Video editing
Animation

Q61. What is the way to create a data model in Power BI?

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
All of the above

Q60. What is the way to create a calculated table in Power BI?

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
None of the above

Q59. How can a Power BI report be shared with others?

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
All of the above

Q58. What is the common flow of activity in Power BI?

2 Mark(s)

Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop
Create a report in Power BI mobile, share it to Power BI Desktop, view and interact in the Power BI service0
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
Bring data into Power BI mobile, create a report, then share it to Power BI Desktop

Q57. What is the way to export data from a Power BI report?

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
All of the above

Q56. How can row-level security be set up in Power BI?

2 Mark(s)

Using DAX formulasUsing Power Query
Using Power Automate
Using Power Query
None of the above

Q55. Which of the following is a way to monitor the performance of a Power BI report?

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
None of the above

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

2 Mark(s)

To provide a high-level overview of data from multiple sources
To create interactive data visualizations
To create pixel-perfect, paginated reports for printing and PDF generation
To embed Power BI content in other applications

Q53. Which of the following is a way to customize the appearance of a Power BI report?

2 Mark(s)

Using custom themes
Using custom visuals
Using custom tooltips
All of the above

Q52. Which of the following is a way to schedule the refresh of a Power BI dataset?

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
None of the above

Q62. Which of the following is a way to add custom visuals to a Power BI report?

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
None of the above

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

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
All of the above

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

2 Mark(s)

Using the Power BI desktop application
Using the Power BI service
Using the Power BI mobile app
None of the above

Q.73.What symbol would you use for multiplication in Power BI in a DAX formula?

2 Mark(s)

+
-
/
*

Q.72. What is the recommend method to share your reports?

2 Mark(s)

Publish them to the Power BI service
Create a PDF of the report, and share the PDF with others3. Copy the .PBIX file to a file folder, and give coworkers access to that folder4. NoneAnswer: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. MAX2. COUNT3. COUNTROWS4. NoneAnswer:MAX 5. Type of data modeling in Power BI that Uses Data Analysis Expressions and similarto Excel formulas______________1. Query2. DAX3. Model4. NoneAnswer: DAX 6. Berikut contoh LOGICAL Functions di DAX, kecuali____________Copy the .PBIX file to a file folder, and give coworkers access to that folder
Copy the .PBIX file to a file folder, and give coworkers access to that folder
NoneAnswer: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. MAX2. COUNT3. COUNTROWS4. NoneAnswer:MAX 5. Type of data modeling in Power BI that Uses Data Analysis Expressions and similarto Excel formulas______________1. Query2. DAX3. Model4. NoneAnswer: DAX 6. Berikut contoh LOGICAL Functions di DAX, kecuali____________

Q.71.1. Contains reference data such as descriptive attributes__________________

2 Mark(s)

Fact table
Query table
Dimension table
Power BI table

Q70. Which of the following illustrates a Many to One relationship?

2 Mark(s)

Many banana trees planted in a garden
Many gardens having no banana trees
1 banana tree having many bananas on the tree
Many banana trees planted in more than 1 garden

Q69. A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights_________________

2 Mark(s)

Power BI
Power Service
Query Editor
Visual Marketplace

Q68. Calculate a result from an expression formula and the result can only be viewed in the visualization______________

2 Mark(s)

Measures
Function
Calculated column
Filter

Q67. Which of the following is a way to use natural language queries in Power BI?

2 Mark(s)

Using the Q&A feature in the Power BI service
Using the Q&A feature in the Power BI service
Using the Q&A feature in the Power BI service
All of the above

Q67. Which of the following is a way to use natural language queries in Power BI?

2 Mark(s)

Using the Q&A feature in the Power BI service
Using the Q&A feature in the Power BI service
Using the Q&A feature in the Power BI service
All of the above

Q66. What values would match the syntax LIKE “%apple” in Power BI?

2 Mark(s)

Star apple
Banapple
Peach apple
All of the above

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

2 Mark(s)

Manually refreshing the report in the Power BI desktop application
Scheduling automatic refreshes in the Power BI service
Using Power Automate to trigger a refresh
All of the above

Q51. What is the purpose of Power BI Embedded?

2 Mark(s)

To embed Power BI content in other applications
To provide additional data modeling capabilities in Power BI
To manage user access to Power BI content
To increase the performance and scalability of Power BI reports and dashboards

POWER BI : Question 1 of 50

Q61. What is the way to create a data model in Power BI?

Q61. What is the way to create a data model in Power BI?

Q60. What is the way to create a calculated table in Power BI?

Q60. What is the way to create a calculated table in Power BI?

Q59. How can a Power BI report be shared with others?

Q59. How can a Power BI report be shared with others?

Q58. What is the common flow of activity in Power BI?

Q58. What is the common flow of activity in Power BI?

Q57. What is the way to export data from a Power BI report?

Q57. What is the way to export data from a Power BI report?

Q56. How can row-level security be set up in Power BI?

Q56. How can row-level security be set up in Power BI?

Q55. Which of the following is a way to monitor the performance of a Power BI report?

Q55. Which of the following is a way to monitor the performance of a Power BI report?

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

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

Q53. Which of the following is a way to customize the appearance of a Power BI report?

Q53. Which of the following is a way to customize the appearance of a Power BI report?

Q52. Which of the following is a way to schedule the refresh of a Power BI dataset?

Q52. Which of the following is a way to schedule the refresh of a Power BI dataset?

Q62. Which of the following is a way to add custom visuals to a Power BI report?

Q62. Which of the following is a way to add custom visuals to a Power BI report?

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

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

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

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

Q70. Which of the following illustrates a Many to One relationship?

Q70. Which of the following illustrates a Many to One relationship?

Q69. A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights_________________

Q69. A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights_________________

Q68. Calculate a result from an expression formula and the result can only be viewed in the visualization______________

Q68. Calculate a result from an expression formula and the result can only be viewed in the visualization______________

Q67. Which of the following is a way to use natural language queries in Power BI?

Q67. Which of the following is a way to use natural language queries in Power BI?

Q67. Which of the following is a way to use natural language queries in Power BI?

Q67. Which of the following is a way to use natural language queries in Power BI?

Q66. What values would match the syntax LIKE “%apple” in Power BI?

Q66. What values would match the syntax LIKE “%apple” in Power BI?

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

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

Q51. What is the purpose of Power BI Embedded?

Q51. What is the purpose of Power BI Embedded?