MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Power Bi
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page