Exam PL-300 topic 2 question 7 discussion

Row label: Name Key column: ID Is featured table: Yes

Maybe a Row label must be a Name.

Among the options — Cost center, Headcount, id, and name — Name is the ideal choice for the row label in a featured table in Power BI. It’s readable, intuitive, and helps users easily recognize each record when browsing the data type in Excel. Meanwhile, ID is the best fit for the key column. It’s unique, consistent, and well-suited for identifying each row unambiguously behind the scenes, especially when connecting or refreshing data. Is featured table: yes

Row label: Chọn cột Name Key column: Chọn cột ID Is featured table: Chọn Yes

Cost Center ; ID; Yes for first one, since name can be duplicated , need to choose the unique identifier

ChatGPT answer: To make the table available as an organizational data type in Microsoft Excel, you need to configure the properties appropriately. Here are the correct selections for each field: Row Label: Cost Center: Since this is likely the unique identifier for each row in your data, it should be the row label. You might want to choose this as it identifies each entry distinctly. Key Column: ID: The "ID" field is typically a unique identifier for each row of data in your dataset, which is necessary for identifying the record and mapping data to Excel properly. Is featured table: Yes: To make the table available as an organizational data type, it should be a "featured table." Marking it as featured helps integrate it with Excel's data type capabilities for easier use. So, the configuration would be: Row Label: Cost Center Key Column: ID Is featured table: Yes

I just saw a video who gave the answer : A. Cost Center B.ID C.Yes https://www.youtube.com/watch?v=zEIiho0wmkw&ab_channel=GlobalTechLearn

I would also vote for Row Label to be "Name" instead "Cost Center" as it will be easier for the users in Exel to identify the row rather than the "Cost Center" which is usually a code. ID and Yes would be my vote for the second and third questions

Surely Cost Center is wrong and the name identifies the business to users??

correct answer is Name, ID and Yes

Row Label: Name Key column: ID Is featured Table: Yes

Shouldn't this be an Excel question rather than power bi?

this youtube video speaks the correct answer on its own! Row label: Name Key column: ID Is featured table: Yes

may I ask why we need a feature table here?

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.

Name, ID, Yes. Name it will be a Business Unit Name.

Do experienced users of Power BI use this feature at all?