You are a database developer. You develop a task management application that connects
to a SQL Server 2008 database named TaskDB. Users log on to the application by using a
SQL Server login. The application contains a module named Task that assigns tasks to
users. Information about these tasks is stored in the Tasks table of the TaskDB database.
The Tasks table contains multiple columns. These include the CloseDate and
EstimatedTime columns. The application must meet the following security requirements:
·Users assigned to a database role named User1 can update all task information columns
except the CloseDate and the EstimatedTime columns in the Tasks table. ·Administrative
users assigned to a database role named Task_Admin can update all task information in the
Tasks table. You need to design a strategy to meet the security requirements. Which two
actions should you perform? (Each correct answer presents part of the solution. Choose
two.)

You have a SQL Server Integration Services (SSIS) package that contains an Execute
Process task. You need to schedule the SSIS package to run on a regular basis. What
should you do?

You plan to deploy a new application. The application will perform the following operations:
·Create a new database ·Add new logins ·Back up the new database You need to configure
a login to support the deployment of the new application. The solution must ensure that the
application uses the most restrictive permissions possible. What should you do?

You are designing a maintenance strategy for a database that contains several views. The
views will be assigned custom permissions. You need to recommend a solution that will
allow developers to modify the views without affecting the views’ existing permissions. What
should you recommend?

You need to create a Service Broker solution. Which object should you create first?

You plan to create a Service Broker solution. The solution will transport data from one
queue to another queue. You need to identify which message type must be used to
transport binary data. The solution must minimize the amount of data transported. Which
message type should you use?

You are a database developer. You plan to design a database solution by using SQL Server
2008. You have a Web site supported by a database that has the full-text search
component installed. You plan to create a table named Courses that will have the following
structure. Users of the Web site will search for courses based on the CourseTitle field. You
need to construct a full-text query that ensures the following compliances when a user
launches the search for a course: ·Rows are returned when the exact search phrase is
found. ·Rows are in order of how well they match with the search phrase. What should you
specify in the full-text query?

You are a database solutions architect. Your company plans to develop a solution by using
a SQL Server 2008 instance. You design a new database that contains a table to store
Microsoft Office documents. You have the following business requirements: ·The
documents are part of the database backup. ·The snapshots of the database are used. You
need to use an appropriate data type to store the documents. Which data type should you
use?

You are a database developer. You plan to design a database solution by using SQL Server
2008. You create a table that contains information about Web pages that are added to a
Web site. The Web site has a home page and contains various other Web pages. The home
page is the root page of the site. All pages except the root page have a link to an
upper-level page. The table must support the following design considerations: ·Records of
the Web pages that are linked to a particular page can be quickly retrieved. ·The position of
a Web page in a collection of linked pages can be quickly retrieved. ·Changing the links to
the upper-level pages is a rare requirement. You need to ensure that the table is designed
appropriately. What should you use?

You are designing a database table for a content management system. Users will store
images and videos in the database. You need to ensure that the database can store files
that are 20 MB or less. The solution must minimize the amount of space required to store
the data. Which data type should you use?