You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named col1. You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?

T2-One-to-25

Quiz
•
Business
•
Professional Development
•
Medium

Al B
Used 1+ times
FREE Resource
25 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
In the report, add a DAX calculated column that calculates the length of col1
In the report, add a DAX function that calculates the average length of col1
From Power Query Editor, add a column that calculates the length of col1
From Power Query Editor, change the distribution for the Column profile to group by length for col1
Answer explanation
1. Power Query Editor -> View -> Enable Column Profile
2. Select three dots (top left corner) in the profile pane appear at the bottom of the Query Editor window.
3. Group By -> Text length
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions. Each sales region has an HR manager.You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?
Publish the reports in an app and grant the HR managers access permission.
Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
Publish the reports to a different workspace other than the one hosting the datasets.
Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
Answer explanation
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?
Viewer
Admin
Contributor
Member
Answer explanation
Member role allows adding members or other with lower permissions to the workspace.Reference:https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces
4.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
You have a Power BI query named Sales that imports the columns shown in the following table in the image.Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis. You need to reduce the load times of the query without affecting the analysis. Which two actions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Remove the rows in which Sales[Status] has a value of Canceled.
Remove Sales[Sales_Date].
Change the data type of Sale[Delivery_Time] to Integer.
Split Sales[Sale_Date] into separate date and time columns.
Remove Sales[Canceled Date].
Answer explanation
Removing uninteresting rows will increase query performance.
Splitting the Sales_Date column will make comparisons on the Sales date faster.
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
You build a report to analyze customer transactions from a database that contains the tables shown in the following table in the image.
You import the tables.Which relationship should you use to link the tables?
one-to-many from Transaction to Customer
one-to-one between Customer and Transaction
many-to-many between Customer and Transaction
one-to-many from Customer to Transaction
Answer explanation
One on the primary Key side (customer table), many on the foreign key side (Transaction table) of the relation.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?
From Model view, set the Subject and Body columns to Hidden.
Remove the Subject and Body columns during the import.
Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
None of the options
Answer explanation
The Subject and the Body are not needed in the report. Dropping them resolves the security problem and minimizes the model.
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
You create a Power BI dataset that contains the table shown in the following exhibit image.
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.
Row label: Cost Center
Key Column: ID
Is featured table: Yes
Row label: Cost Center
Key Column: ID
Is featured table: No
Row label: Name
Key Column: ID
Is featured table: No
Row label: Name
Key Column: ID
Is featured table: Yes
Answer explanation
Box 1: Name -The Row label field value is used in Excel so users can easily identify the row. It appears as the cell value for a linked cell, in the Data Selector pane, and in the Information card.Box 2: ID -The Key column field value provides the unique ID for the row. This value enables Excel to link a cell to a specific row in the table.Box 3: Yes -In the Data Types Gallery in Excel, your users can find data from featured tables in your Power BI datasets.Reference:https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-excel-featured-tables
Create a free account and access millions of resources
Similar Resources on Wayground
20 questions
GENERAL BUSINESS ENGLISH

Quiz
•
10th Grade - Professi...
20 questions
Business Model Canvas

Quiz
•
University - Professi...
20 questions
Business English Units 1-2 Vocabulary

Quiz
•
11th Grade - Professi...
20 questions
Quiz 20 Jam Pelatihan Bidang Pengawasan PPDP

Quiz
•
Professional Development
30 questions
Product Life Cycle

Quiz
•
Professional Development
20 questions
ACCOUNTING FOR BASIC MERCHANDISING TRANSACTIONS

Quiz
•
Professional Development
20 questions
Operating Cashier (MSIB)

Quiz
•
Professional Development
23 questions
Excel Shortcuts Quiz

Quiz
•
Professional Development
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade