DRAG DROP
You develop a database application for a university. You need to create a view that will be
indexed that meets the following requirements:
Displays the details of only students from Canada.
Allows insertion of details of only students from Canada.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the correct order.)
Answer: 
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms187956.aspx
wouldnt it be create indexed view?
0
0
Wait never mind iam stupid
0
0
https://msdn.microsoft.com/en-AU/library/ms187956.aspx
Quote: “Forces all data modification statements executed against the view to follow the criteria set within select_statement.”
CHECK OPTION helps this: Allows insertion of details of only students from Canada.
0
0
Displays the details of only students from Canada (by securing the view definition to prevent alteration): WITH ENCRYPTION
Allows insertion of details of only students from Canada (by filtering what data can be inserted): WITH CHECK OPTION
0
0
WITH SCHEMABINDING will prevent the view from being altered.
0
0
** Index View Must be created with Schema binding
** WITH CHECK OPTION to grantee inserted records will be within view scope
0
0
By the way, part of new Microsoft 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0
What’s more, part of new Microsoft 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0
CREATE VIEW dbo.CanadianStudents
WITH SCHEMABINDING
AS
SELECT s.LastName,
s.FirstName,
s.JobTitle,
a.Country,
e.LastQualification
FROM Student s
INNER JOIN NativeAddress a
ON a.AddressID = s.AddressID
INNER JOIN EducationHistory e
ON s.StudentID = e.StudentID
WHERE a.Country = ‘Canada’
WITH CHECK OPTION;
0
0