PowerBi - Part II

PowerBi - Part II

Professional Development

56 Qs

quiz-placeholder

Similar activities

Industries CPQ Developer Training II

Industries CPQ Developer Training II

Professional Development

55 Qs

Randy's Networking Quiz 1

Randy's Networking Quiz 1

Professional Development

54 Qs

SF Sales Cloud Quiz 2

SF Sales Cloud Quiz 2

Professional Development

60 Qs

Overall programming tests

Overall programming tests

Professional Development

60 Qs

ITF+ Practice Exam #1

ITF+ Practice Exam #1

Professional Development

56 Qs

lorem ipsum AWS D4 cap.1-2

lorem ipsum AWS D4 cap.1-2

Professional Development

55 Qs

AZ-900 Practice Test 3

AZ-900 Practice Test 3

Professional Development

51 Qs

Class 9. Data Manipulation

Class 9. Data Manipulation

Professional Development

53 Qs

PowerBi - Part II

PowerBi - Part II

Assessment

Quiz

Computers

Professional Development

Medium

Created by

Trang Mai

Used 10+ times

FREE Resource

56 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

You create a Power BI dataset that contains the table shown in the following exhibit. You need to make the table available as an organizational data type in Microsoft Excel.

How should you configure the properties of the table? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Cost Center/ID/Yes

Headcount/Name/No

ID/ Headcount/ Yes

Name/ Cost center/No

2.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Media Image

You have the Power BI model shown in the following exhibit. A manager can represent only a single country.

You need to use row-level security (RLS) to meet the following requirements:

  • The managers must only see the data of their respective country.

  • The number of RLS roles must be minimized.

Which two actions should you perform? Each correct answer presents a complete solution.


Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

  1. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

  1. Create one role for each country.

For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

You have a Power BI imported dataset that contains the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.


Cardinality/denormalized table

Assume Referential Integrity/Star schema

Cardinality/snowflake schema

Cross filter direction/ denormalized table

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales.

You need to create a measure that calculates the total sales from the equivalent month of the previous year.

How should you complete the calculation? To answer, select the appropriate options in the answer area.


EEVALUATE/SAMEPERIODLASTYEAR/'Date' [Date]

SUMX/DATESSMTD/[Date]

CALCULATE/PARALLELPERIOD/'DATE' [Month]

SUM/TOTALMTD/'Date' [Date]

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

You plan to create a report that will display sales data from the last year for multiple regions.

You need to restrict access to individual rows of the data on a per region-basis by using roles.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Publish the report/ Add a filter to the report/From the Manage roles window, select Create / Add a filter to the report

Assign Users to the role/From the Manage roles window, select Create / Add a filter to the report/From the Manage roles window, select Create

From the Manage roles window, select Create/ Add a filter to the report/From the Manage roles window, select Create /Publish the report

Import data into your Power BI Desktop/From the Manage roles window, select Create/Assign Users to the role/Publish the report

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Report developers and users provide feedback that the data model is too complex. The model contains the following tables.

The model has the following relationships:

  • There is a one-to-one relationship between Sales_Region and Region_Manager.

  • There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.

  • There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.

You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Merge [Sales_region] and [Region_Manager] by using a right join as new query named [Sales_region_and_Region_Manager]

Merge [Sales_Region] and [Region_Manager] by using inner join.

Merge [Region_Manager] and [Manager] by using inner join.

Merge [Sales_Region] and [Sales_Manager] by using an inner join.


Merge [Region_Manager] and [Manager] by using inner join.

Merge [Sales_region] and [Region_Manager] by using a right join as new query named [Sales_region_and_Region_Manager]



Merge [Region_Manager] and [Manager] by using inner join.

Merge [Sales_Region] and [Region_Manager] by using inner join.

Merge [Sales_Managers] and [Sales_Region] by using a left join

Merge [Sales_Region] and [Region_Manager] by using inner join.


Merge [Sales_Managers] and [Sales_Region] by using a left join

Merge [Sales_region] and [Region_Manager] by using a right join as new query named [Sales_region_and_Region_Manager]

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report.

You need to recommend a solution to improve the performance of the report. What should you recommend?


Change any DAX measures to use iterator functions.


Enable visual interactions.

Replace the default visuals with AppSource visuals.

Split the visuals onto multiple pages.

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?