exam questions

Exam 70-762 All Questions

View all questions & answers for the 70-762 exam

Exam 70-762 topic 1 question 69 discussion

Actual exam question from Microsoft's 70-762
Question #: 69
Topic #: 1
[All 70-762 Questions]

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stores information about the employees of your company.
You need to implement and enforce the following business rules:
✑ Limit the values that are accepted by the Salary column.
✑ Prevent salaries less than $15,000 and greater than $300,000 from being entered.
✑ Determine valid values by using logical expressions.
✑ Do not validate data integrity when running DELETE statements.
Solution: You implement cascading referential integrity constraints on the table.
Does the solution meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
References:
https://technet.microsoft.com/en-us/library/ms186973(v=sql.105).aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Heisenberg008
Highly Voted 5 years, 4 months ago
Answer should be No. Correct answer would be Check Constraint.
upvoted 17 times
...
New_user
Highly Voted 5 years, 5 months ago
Can anyone explain how cascade constraint prevents excessive values?
upvoted 10 times
gripasha
5 years, 4 months ago
I think that the answer to the question is - no. Solution does NOT meet the goal
upvoted 9 times
...
JohnFan
5 years, 3 months ago
CASCADE Repeat on the referencing table what occurs in the referenced. If the key column is changed, change it in the referencing table. If the row is deleted, remove it from the referencing table as well.
upvoted 4 times
...
course104
4 years, 5 months ago
Noone can!
upvoted 1 times
...
...
Solomon2020
Most Recent 4 years, 7 months ago
The answer should be NO. It is the Check constraint not referential cascade
upvoted 2 times
...
SoupDJ
4 years, 8 months ago
I believe the answer is NO for two reasons: (1) As many people below point out - a referential integrity constraint is not the kind of constraint that can perform the first three conditions. (2) In addition, the question explicitly states that there should NOT be any sort of check when a row is deleted - which is exactly what a referential integrity check WILL do.
upvoted 1 times
...
auuuu
4 years, 9 months ago
Hey People, I understand that it is check constraint. My question is "Is that the only way to so?" I mean instead of insert we can check what is being inserted and if it is not supported by requirements we can throw error.
upvoted 1 times
databasejamdown
4 years, 8 months ago
Yes, instead of insert can definitely work
upvoted 1 times
...
...
stm22
4 years, 11 months ago
i agree answer should be NO: Cascading referential integrity constraints allow you to define the actions when a user tries to delete or update a key for which foreign keys exist. Cascading is used with the drop command when we want to drop a parent table even when a child table exists. If you execute a delete command without a cascading constraint then it will show an error.
upvoted 2 times
...
mamarach
4 years, 12 months ago
I think NO
upvoted 3 times
...
strikersree
4 years, 12 months ago
Answer is NO :)
upvoted 3 times
...
Nelly100
5 years, 2 months ago
Correct answer should be Check Constraint which is not there. This dump has many misleading answers. Watch out!!!!!
upvoted 9 times
...
als2kool
5 years, 3 months ago
I know that a foreign key can be referenced in the same table so I'm thinking perhaps that is what they were thinking? That is certainly not the best way to design a table.
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 ...