Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 7 discussion

Actual exam question from Microsoft's PL-300
Question #: 7
Topic #: 2
[All PL-300 Questions]

HOTSPOT -
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.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Cost Center -
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

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Namenick10
Highly Voted 2 years, 1 month ago
Row label: Name Key column: ID Is featured table: Yes
upvoted 123 times
HamzaMeziane
2 years, 1 month ago
why you said is ?
upvoted 1 times
...
Ashokku22
1 year, 4 months ago
Yes right you can also see in example given in the solution it mentioned companyname rather than cost centre
upvoted 2 times
...
Churato
2 years ago
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. 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. Source: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-excel-featured-tables
upvoted 10 times
...
...
Alexeyvykhodtsev
Highly Voted 2 years, 1 month ago
Maybe a Row label must be a Name.
upvoted 24 times
fdsdfgxcvbdsfhshfg
2 years, 1 month ago
Yeah, Name of the Business Unit should be a Row Label
upvoted 10 times
...
...
JPShields
Most Recent 3 weeks, 4 days ago
Surely Cost Center is wrong and the name identifies the business to users??
upvoted 1 times
...
LuluSkyy
1 month ago
correct answer is Name, ID and Yes
upvoted 1 times
...
rcaliandro
2 months, 3 weeks ago
Row Label: Name Key column: ID Is featured Table: Yes
upvoted 1 times
...
OLAG19
9 months, 3 weeks ago
Shouldn't this be an Excel question rather than power bi?
upvoted 8 times
LuluSkyy
1 month ago
Its need to be done in power bi before its brought into excel.
upvoted 1 times
...
...
Abdulwahab1983
10 months, 1 week ago
this youtube video speaks the correct answer on its own! Row label: Name Key column: ID Is featured table: Yes
upvoted 9 times
...
65945de
10 months, 2 weeks ago
may I ask why we need a feature table here?
upvoted 5 times
...
Dsbuff
10 months, 3 weeks ago
Row label: Name Key column: ID Is featured table: Yes The reason for "Row label" as Name is that the "Name" of a Business Unit would be more descriptive and recognizable to users than a numeric ID or a Cost Center code, making it easier to identify the Business Unit in Excel.
upvoted 5 times
...
agelee
12 months ago
Name, ID, Yes. Name it will be a Business Unit Name.
upvoted 6 times
...
reignreign03
1 year ago
Do experienced users of Power BI use this feature at all?
upvoted 2 times
...
Igetmyrole
1 year, 2 months ago
"Name", "Headcount" and "Yes" are correct answers. It is because in row label, we should choose the "Name" column as the row label because it is typically the primary identifier or name associated with the data in an organization data type. In column we should choose the "Headcount" column as the column because it represents a numeric value (presumably the headcount) associated with the organization data. Is featured table, we should select "Yes" to indicate that this table should be recognized as an organization data type in Excel.
upvoted 1 times
RicoPallazzo7
1 year, 1 month ago
As key column i would say ID, why headcount?
upvoted 1 times
...
...
RicoPallazzo7
1 year, 2 months ago
This has not been shown in any of the path on the microsoft sites suggested for the pl-300...
upvoted 6 times
AfterRain007
7 months, 3 weeks ago
IKR! I'm like, I literally don't know any of this thing lmao
upvoted 1 times
...
...
MEG_Florida
1 year, 3 months ago
For me Name doesn't mean much. In a report in the corp level I've only ever used Cost Center, oddly enough i've never been asked the name of the cost center.. (weird probably yeah) and we have one but still
upvoted 2 times
...
AshND
1 year, 5 months ago
There could be more than one business units under a cost centre so I think Business Unit Name should be the correct choice for Row label.
upvoted 2 times
...
SanaCanada
1 year, 6 months ago
Correct answer Cost Center ID Yes with this explanation In a table or matrix visualization in Power BI, the row labels are typically the fields that define the categories or groups along the rows of the table or matrix. In the case of the given fields, "Cost Center" and "Headcount" can be considered as row labels because they represent categories or groups along the rows of the table or matrix. "ID" and "Name" are typically used as column labels or values. However, the choice of row labels ultimately depends on the specific analysis and reporting needs of the data.
upvoted 10 times
MoxieTT
1 year, 5 months ago
I've seen your replies in a few questions now. Have you successfully cleared the exam?
upvoted 6 times
...
...
SanaCanada
1 year, 6 months ago
In a table or matrix visualization in Power BI, the row labels are typically the fields that define the categories or groups along the rows of the table or matrix. In the case of the given fields, "Cost Center" and "Headcount" can be considered as row labels because they represent categories or groups along the rows of the table or matrix. "ID" and "Name" are typically used as column labels or values. However, the choice of row labels ultimately depends on the specific analysis and reporting needs of the data.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...