CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. PL-300

Free PL-300 Exam Braindumps (page: 19)

Page 18 of 85
PDF with 356 Questions

HOTSPOT (Drag and Drop is not supported)
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employee_id and employee_photo.
You need to optimize the data model.
What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: Hide
Need in the relation, so cannot delete it.
Box 2: Delete


Reference:

https://community.powerbi.com/t5/Desktop/How-to-Hide-a-Column-in-power-Bi/m-p/414470



HOTSPOT (Drag and Drop is not supported)
You plan to create Power BI dataset to analyze attendance at a school. Data will come from two separate views named View1 and View2 in an Azure SQL database.
View1 contains the columns shown in the following table.
View2 contains the columns shown in the following table.
The views can be related based on the Class ID column.
Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID.
You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:
-The count of classes that occur by period
-The count of students in attendance by period by day
-The average number of students attending a class each month
In which table should you include the Teacher First Name and Period Number fields? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:


  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: Teacher fact
Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc. A fact table contains dimension key columns that relate to dimension tables, and numeric measure columns.
Note: Star schema is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact.
Box 2: Attendance fact
Incorrect:
Dimension tables describe business entities
the things you model. Entities can include products, people, places, and concepts including time itself. The most consistent table you'll find in a star schema is a date dimension table. A dimension table contains a key column (or columns) that acts as a unique identifier, and descriptive columns.


Reference:

https://docs.microsoft.com/en-us/power-bi/guidance/star-schema



You have the Power BI model shown in the following exhibit.
There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?

  1. Create a slicer that filters Departments based on DepartmentID.
  2. Create a row-level security (RLS) role for each department, and then define the membership of the role.
  3. Create a DepartmentID parameter to filter the Departments table.
  4. To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function.

Answer(s): B



In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.
What should you do?

  1. Create an inactive relationship between the tables and select Apply security filter in both directions.
  2. Create an active relationship between the tables and select Apply security filter in both directions.
  3. Create an inactive relationship between the tables and select Assume referential integrity.
  4. Create an active relationship between the tables and select Assume referential integrity.

Answer(s): B






Post your Comments and Discuss Microsoft PL-300 exam with other Community members:

PL-300 Exam Discussions & Posts