You need to execute the package successfully
You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database
server.
The database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager.
You add the configuration file to the package.
When the package executes, you receive an error message which indicates that login failure
occurred.
You need to execute the package successfully.
What should you do?
You need to schedule the SSIS package to run on a regular basis
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 need to ensure that all stored data is encrypted by using the least amount of administrative effort
You administer a SQL Server 2008 instance. The instance hosts a new database
application. You plan to design the data security strategy for the application. You will use
Snapshot replication to replicate the data to another instance of SQL Server 2008. You
need to ensure that all stored data is encrypted by using the least amount of administrative
effort. What should you do?
You need to define the required dataset or datasets for this report
You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list
of customers by using a List control. For each customer in the List control, you plan to
include a table that contains the orders for that customer. The customer data is stored in the
Customers table in the data source, and the order data is stored in the Orders table. You
need to define the required dataset or datasets for this report. What should you do?
Which code segment should you use for each text box?
You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a table.
You need to ensure that alternate rows in the table have a pale green background.
Which code segment should you use for each text box?
You need to ensure that the query executes successfully
You develop a SQL Server 2008 Reporting Services (SSRS) report.
A Multidimensional Expressions (MDX) query used in the report contains a parameter to
display sales data for various product categories. You write the following query.
You discover that the query generates an error when executed.
You need to ensure that the query executes successfully.
What should you do?
What are two possible ways to achieve this goal?
You administer SQL Server 2008 servers on a single site. The site contains the following
two SQL Server 2008 instances: An Enterprise Edition server on a server that has a
redundant array of independent disks (RAID) 10 disk system A Standard Edition server
on a server that has a RAID 5 disk system Each instance hosts a single application. You
need to recommend a high-availability solution for the site to meet the following business
requirements: The solution can be implemented on the existing systems. The database
is available with minimal downtime. Data loss is minimal. There is minimal effect on the
existing system. What are two possible ways to achieve this goal? (Each correct answer
presents a complete solution. Choose two.)
Which expression in the Group properties dialog box should you use?
You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report uses a Table data region and contains a dataset. The dataset has a column
named LastName.
You need to ensure that the report items are grouped by the first character in the LastName
column.
Which expression in the Group properties dialog box should you use?
You need to ensure that the following requirements are met: The code segment compiles successfully
You create a report in SQL Server 2008 Reporting Services (SSRS) solution. You write the
following code segment in the report.
The code segment generates errors when compiled.
You need to ensure that the following requirements are met:
The code segment compiles successfully.
The GetCmFromInches function can be called from other reports.
What should you do?
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 query that calculates the total sales of each OrderId from the Sales.Details
table. The solution must meet the following requirements:
Use one-part names to reference columns.
Sort the order of the results from OrderId.
NOT depend on the default schema of a user.
Use an alias of TotalSales for the calculated ExtendedAmount.
Display only the OrderId column and the calculated TotalSales column.
Which code segment should you use?
To answer, type the correct code in the answer area.