Q.1
The MAP chart is a useful visualization to show locations of cities and countries with bubbles to indicate the size of the data points.
  • False
  • True
Q.2
Sometimes when analyzing data we may use our dimensions as a measure to understand values like no. of instances, average pricing or maximum price
  • False
  • True
Q.3
The Power Query Editor does not save changes made to the data tables. It saves the applied steps separately so that the steps will need to be applied every time the table is loaded.
  • False
  • True
Q.4
Creates the connection between Power BI cloud-based data and the data source located on-premises
  • Power BI service
  • Report view
  • Query editor
  • Gateway
Q.5
A collection of software services, apps, and connectors to turn unrelated sources of data into coherent insights
  • Query Editor
  • Power Service
  • Power BI
  • Visual Market Place
Q.6
The following are examples of the AGGREGATION function except:
  • Aggregation Functions
  • Logical Functions
  • Date Functions
  • Semua benar
Q.7
A function that can only work on numeric fields is
  • AND
  • ISNUMBER
  • AVERAGE
  • CONCATENATE
Q.8
Which of these values would be matched using the syntax LIKE "%apple"
  • peach apple
  • starapple
  • banapple
  • All Of above
Q.9
What expression is used to indicate the table where the values would be searched from?
  • TABLE
  • WHERE
  • FROM
  • SELECT
Q.10
What is the SQL command to return the values from a table?
  • DISTINCT
  • SELECT
  • WHERE
  • ORDER BY
Q.11
What is the SQL expression used to count the values in a table?
  • COUNT
  • SUM
  • AVERAGE
  • DISTINCT
Q.12
In any analytics report, it is not necessary to have measures.
  • False
  • True
Q.13
To enable two tables to be joined. A unique key between the 2 tables is required. For example between the customer table and the sales table. The key would be customer ID.
  • False
  • True
Q.14
Which of the following illustrates a Many to One relationship?
  • 1 banana tree having many bananas on the tree
  • Many banana trees planted in more than 1 garden
  • Many banana trees planted in a garden
  • Many gardens having no banana trees
Q.15
Fungsi yang termasuk di kategori TEXT FUNCTION:
  • CONCATENATE
  • IF
  • COUNT
  • DATE
Q.16
Berikut contoh LOGICAL Functions di DAX, kecuali:
  • IF
  • OR
  • NOT
  • SUMX
Q.17
Berikut contoh fungsi COUNTING, kecuali:
  • COUNT
  • COUNTA
  • MAX
  • COUNTROWS
Q.18
Berikut contoh fungsi AGREGASI, kecuali:
  • COUNT
  • SUM
  • AVERAGE
  • MAX
Q.19
What is the recommend method to share your reports?
  • Copy the .PBIX file to a file folder, and give coworkers access to that folder.
  • Publish them to the Power BI service.
  • Create a PDF of the report, and share the PDF with others.
Q.20
Calculate a result from an expression formula and the result can only be viewed in the visualization
  • Calculated column
  • Filter
  • Function
  • Measures
0 h : 0 m : 1 s