New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-600 Exam - Topic 1 Question 30 Discussion

Actual exam question for Microsoft's PL-600 exam
Question #: 30
Topic #: 1
[All PL-600 Questions]

You are designing the data model for a school. The school wants to track students' enrollments in courses.

The system must meet the following requirements:

Track the courses in which each student is enrolled.

Track the students that are enrolled in each course.

Track dates when each student enrolled in each course and the person who approved the enrollment.

Allow users to create a report that details which students are enrolled in which courses.

You need to recommend a data model that will fit the school's requirements.

Which logical model should you recommend?

Show Suggested Answer Hide Answer
Suggested Answer: A

Need a relationship table.

N:N (Many-to-Many): A table relationship that depends on a special Relationship table, sometimes called an

Intersect table, so that many rows of one table can be related to many rows of another table.

When viewing rows of either table in a N:N relationship you can see a list of any rows of the other table that are

related to it.


https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships

by Ammie at Sep 21, 2022, 03:06 PM

Limited Time Offer

25%

Off

Get Premium PL-600 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Cory
4 months ago
Option D is definitely the best choice for this scenario.
upvoted 0 times
...
Maurine
4 months ago
I’m surprised they need to track who approved enrollments too!
upvoted 0 times
...
Jesusita
4 months ago
Wait, does Option A even track enrollment dates?
upvoted 0 times
...
Horace
4 months ago
I disagree, Option C seems more comprehensive.
upvoted 0 times
...
Arlyne
5 months ago
I think Option B fits all the requirements.
upvoted 0 times
...
Tayna
5 months ago
I feel like Option B might be the right choice since it seems to cover all the requirements, but I wish I had more confidence in my answer.
upvoted 0 times
...
Jospeh
5 months ago
This question reminds me of a practice scenario we did on tracking enrollments. I think it was a similar setup with students and courses, but I can't remember the specifics of the model we used.
upvoted 0 times
...
Arthur
5 months ago
I'm a bit unsure about which option to choose. I think we need to consider the attributes for enrollment dates and approval, but I can't recall the exact model that fits best.
upvoted 0 times
...
Renea
5 months ago
I remember we discussed many-to-many relationships in class, which seems relevant here since students can enroll in multiple courses and vice versa.
upvoted 0 times
...
Junita
5 months ago
Local Host Cache might be a good solution to keep the environment running without the SQL databases. I'll need to research the details on how to set that up.
upvoted 0 times
...
Lorrine
5 months ago
Okay, I've got a strategy for this. I'll read through the options carefully and think about where in the system the post-processing scripts would logically be added. That should help me narrow it down.
upvoted 0 times
...

Save Cancel