You need to modify the path where the package writes event data to a text file
You develop a SQL Server 2008 Integration Services (SSIS) package.
You need to modify the path where the package writes event data to a text file.
What should you do?
You need to ensure that the application is successfully deployed to the instance
You administer a SQL Server 2008 instance. You plan to design the security requirements
for a new database application. The application uses a code segment that contains the
following components: A method that accesses the registry on the SQL Server. A method
that accesses the file system on a network file server. A class definition that uses public
static fields The code segment uses SQL CLR integration and is implemented as a single
assembly. You need to ensure that the application is successfully deployed to the instance.
What should you do?
You need to add the custom data flow component to the toolbox
You are editing a SQL Server 2008 Integration Services (SSIS) package by using Business
Intelligence Development Studio. The package uses a custom data flow component. The
package runs successfully.
You attempt to add another instance of the custom data flow component to the package. The
data flow component does not appear in the toolbox or in the Choose Toolbox Items dialog
box.
You need to add the custom data flow component to the toolbox.
What should you do?
Which two actions should you perform?
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.)
What are two possible ways to achieve this goal?
You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a
source query to a destination table.
You need to insert only those rows that do not already exist in the destination table.
What are two possible ways to achieve this goal? (Each correct answer presents a complete
solution. Choose two.)
You need to ensure that the required information is written to the text file
You implement a SQL Server 2008 Integration Services (SSIS) package.
The package contains the following components:
A data flow task contained in a For Loop container
A Flat File destination component that uses a Flat File connection manager
An OnError event handler
When an error occurs in the package, you plan to write diagnostic information from an
expression that includes the version of the package to a text file.
You need to ensure that the required information is written to the text file.
What should you do?
You need to ensure that the stored procedures in the MSDB database are executed by using the security context
You administer a SQL Server 2008 instance that will host a new database application. You
plan to design the security requirements for the application. Each application user has a
unique login to the SQL Server 2008 server. The application database contains stored
procedures to execute stored procedures in the MSDB database. The stored procedures in
the MSDB database schedule SQLAgent jobs. You need to ensure that the stored
procedures in the MSDB database are executed by using the security context of the
application user. What should you do?
Which three actions should you perform?
You modify a SQL Server 2008 Integration Services (SSIS) package.
The package extracts data from a text file and loads this data to a SQL Server 2008 table as
shown in the following two exhibits.
You need to update the package to extract data from multiple text files of the same directory.
Which three actions should you perform? (Each correct answer presents part of the solution.
Choose three.)
Which code segment should you use?
CORRECT TEXT
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)
You need to create a view named uv_CustomerFullName to meet the following requirements:
The code must NOT include object delimiters.
The view must be created in the Sales schema.
Columns must only be referenced by using one-part names.
The view must return the first name and the last name of all customers.
The view must prevent the underlying structure of the customer table from being changed.
The view must be able to resolve all referenced objects, regardless of the user’s default schema.
Which code segment should you use?
To answer, type the correct code in the answer area.
You need to ensure that data from each query is included in each row in the data flow
You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts
data from two sources. Each source database is located on a different server. Each source
is based on a SELECT statement that uses an ORDER BY clause. The data flow is as
shown in the following diagram.
When the paths from the two sources are connected to a Merge Join component, the
following error message is displayed:
“Data Flow Task: The input is not sorted. The ‘input “Merge Join Left Input” (80)’ must be
sorted.”
You need to ensure that data from each query is included in each row in the data flow. You
want to achieve this goal by using minimum amount of execution time.
What should you do?