Which action should you take?

You are a database developer on an instance of SQL Server 2008. Your database contains the Task and TaskType tables, which were defined with the following Transact-SQL statements:
CREATE TABLE TaskType
(TaskTypeID int PRIMARY KEY,
Description varchar(40) NOT NULL);
CREATE TABLE Task(
TaskID int IDENTITY(1,1) PRIMARY KEY,
Description varchar(50) NOT NULL,
TaskTypeID int NOT NULL FOREIGN KEY REFERENCES TaskType(TaskTypeID),
DateAdded datetime NOT NULL DEFAULT (GETDATE()),
DateDue datetime);
You need to create a view that makes data from both tables visible. You also want the view to be updatable.
Which action should you take?
A. Create a partitioned view that allows users to update only their respective partitions.
B. Create a view that includes a CTE.
C. Create a view that includes both tables and define INSTEAD OF triggers to allow DML operations.
D. Create a parameterized stored procedure and create a view on the returned result set.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.