Power Query/Power Query MCQ Question Sample Test,Sample questions

  1. Home

Question: 
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

Question: 
Berikut contoh fungsi COUNTING, kecuali____

1.MAX

2.COUNT

3.COUNTROWS

4.None

Question: 
Berikut contoh LOGICAL Functions di DAX, kecuali______

1.OR

2.IF

3.SUMX

4.NOT

Question: 
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

Question: 
Contains reference data such as descriptive attributes_______

1.Fact table

2.Query table

3.Dimension table

4.Power BI table

Question: 
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

Question: 
Fungsi yang termasuk di kategori TEXT FUNCTION________

1.IF

2.DATE

3.CONCATENATE

4.COUNT

Question: 
Sometimes, referred to as Power BI online____

1.Power BI

2.Power BI Service

3.Query Editor

4.Visual Market Place

Question: 
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

Question: 
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

Question: 
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

Question: 
What symbol would you use for multiplication in Power BI in a DAX formula?

1.+

2.–

3./

4.*

Question: 
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

Posted on by Online Exam TestTeam

More MCQS

  1. Power Query MCQ Question
Search
Olete Team
Online Exam TestTop Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Testwebsite is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!