9 What should you do to improve performance while getting data in Power BI?

D.Do some calculations in the original data source

A.Only pull data into the Power BI service not Power BI Desktop

B.Use the Select SQL statement in your SQL queries when you are pulling data from a relational database

C.Combine date and time columns into a single column

11 Which of the following option improves performance by generating a single query statement to retrieve and transform source data?

C.Adding custom columns with complex logic

15 What can be achieved by removing unnecessary rows and columns?

C.Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.

A.It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.

B.Deleting unnecessary rows and columns can damage the structure of the data model.

17 Which of the following is the correct definition of data profiling ?

B.Studying the nuances of the data

A.Aggregating columns containing numeric data

18 Which of the following is the risk of including null values in a numeric column?

C.DAX expressions with AVERAGE data will be incorrect

A.AX expressions with MAX data will be incorrect

B.DAX expressions with SUM data will be incorrect

D.DAX expressions with MIM data will be incorrect

19 Which of the following is not a best practice for naming conventions in Power BI?

ARename columns with spaces in them

B.Replace values that have integers with human-readable results

24 What are the two types of tables in a star schema known?

BQualitative and quantitative data tables

25 What is the difference between a fact table and a dimension table?

A.Fact tables store observations or events while dimension tables contain information about specific entities within the data.

B.Fact tables contain information about specific entities while dimension tables contain information about observational data.

C.Dimension tables explain about specific roles in Power BI while fact tables explain the information about facts that are associated with those roles in Power BI.

26 What is Cardinality?

C.The direction that the data flows in a relationship between two tables is Cardinality.

A.Cardinality is how long it takes for the data to load.

B.Cardinality is the granularity of the data.

D.Cardinality is a type of visual element.

29 You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of these functions. What should you recommend?

A.Merge tables by using Power Query

B.Hide unused columns in the model

C.Split the model into multiple models

37 What benefit do you get from analyzing metadata?

A.The benefit of analyzing metadata is that you can clearly identify data inconsistencies with your dataset.

B.The benefit of analyzing the metadata is to get familiar with your data.

C.The benefit of analyzing the metadata is to know the number of rows, columns, and tables being loaded into your model.

D.The benefit of analyzing the metadata is to easily upload data.

42 A critical aspect of data aggregation is that it allows you to focus on

A.The important and most meaningful data

B.Disabling interactive analysis over big data

C.Larger cache size and decreased query performance

44 What is a dashboard?

C.A canvas of report elements that can be built in the Power BI service

A.A canvas of report elements that can be built in Power BI Desktop

B.Dashboards can be built by using visuals that are developed with an underlying data source

D.The canvas in which you can view the data model of a report

45 Why are parameters important in Power BI paginated reports?

C.They allow the user to control aspects of how the report is rendered when the report is run.

A.They are required so that Power BI can call the paginated report.

B.They allow the report developer to control the refresh interval of the report.

46 What is the best description of a workspace?

D.A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, etc."

"A.A workspace is a feature in the Power BI service that allows you to view reports only.

B.A workspace is a feature that allows you to view and edit the data model, build visualizations, and transform the data.

C.A workspace is a feature of Power BI Desktop that allows you to build only.

49 You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

B.Set Data Connectivity mode to DirectQuery

C.Set the Command timeout in minutes setting

D.Set Data Connectivity mode to Import"

50 You build a report to help the sales team of techtrics to understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

D.Line and clustered column chart

Power BI Quiz

Authored by Jhalak Dashora

Computers

University

Used 18+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1 Who enables advanced analytics capabilities through reports and visualizations?

A.Data Visualizer

B.Data Scientist

C.Data Engineer

D.Data Analyst

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

2 Which data analyst task has a critical performance impact on reporting and data analysis?

A.Analyze

B.Visualize

C.Mining

D.Model

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

3 Which of the following is an important step for understanding and interpreting the information that is displayed on the report?

A.Analytics

B.Complex Reports

C.Informed Business Decisions

D.Complex Dashboards

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

4 Select the building blocks of Power BI.

A.Tiles and Dashboards

B.Visual Studio, C#, and JSON files

C.Datasets, Visualizations, Reports, Dashboards, and Tiles

D.Databases and Mobile Devices

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

5 The common flow of activity in Power BI is described by?

A.Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards

B.Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

C.Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.

D.Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

6 Which of the following is a collection of ready-made visuals which is pre-arranged in dashboards and reports?

A.Canvas

B.App

C.Dataset

D.Scheduled refresh

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

7 Which of the following is used to query the data from Microsoft SQL Server?

A.DAX

B.T-SQL

C.MDX

D.DML

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

52 questions

computer memory and storage

Quiz

•

University

50 questions

IUTCS Freshers

Quiz

•

University

50 questions

Computer System Servicing

Quiz

•

University

46 questions

Final Repaso INF-1

Quiz

•

University

50 questions

Quiz

•

University

50 questions

MS Excel Quiz

Quiz

•

University

50 questions

2학기 3-4단원

Quiz

•

7th Grade - University

50 questions

ATS Informatika Genap

Quiz

•

10th Grade - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

7 questions

Fragments, Run-ons, and Complete Sentences

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

10 questions

DNA Structure and Replication: Crash Course Biology

Interactive video

•

11th Grade - University

5 questions

Inherited and Acquired Traits of Animals

Interactive video

•

4th Grade - University

5 questions

Examining Theme

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

Power BI Quiz

1 Who enables advanced analytics capabilities through reports and visualizations?

2 Which data analyst task has a critical performance impact on reporting and data analysis?

3 Which of the following is an important step for understanding and interpreting the information that is displayed on the report?

4 Select the building blocks of Power BI.

5 The common flow of activity in Power BI is described by?

6 Which of the following is a collection of ready-made visuals which is pre-arranged in dashboards and reports?

7 Which of the following is used to query the data from Microsoft SQL Server?

8 You are creating a Power BI report with data from an Azure Analysis Services Cube. The data should be available immediately in the Power BI report whenever the data refreshes in the cube. How should you connect?

9 What should you do to improve performance while getting data in Power BI?

10 Which storage mode leaves the data at the data source?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers