You need to ensure that the reports hosted on the instance continue to function correctly
You administer a SQL Server 2008 Reporting Services (SSRS) instance. The instance
contains several reports that use stored credentials to access data from a SQL Server 2008
instance. A computer that hosts the instance recovers from a hardware failure and has a
newly installed SSRS instance. You need to ensure that the reports hosted on the instance
continue to function correctly. What should you do?
You need to rewrite the stored procedure to use a single statement to load the data
You are a database developer. You plan to design a database solution by using SQL Server
2008. A stored procedure uses the INSERT, UPDATE, and DELETE statements separately
to load data into a table. You need to rewrite the stored procedure to use a single statement
to load the data. What should you do?
Which data flow component should you use?
You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data
to a SQL Server 2008 database.
You need to ensure that the data flow updates the existing records in the SQL Server
database by using data from the rows in your data flow.
Which data flow component should you use?
You need to ensure that the package runs and loads additional files even if an error occurs during the loading
You are developing a SQL Server 2008 Integration Services (SSIS) package. The package
extracts data from text files and loads the data to a SQL Server 2008 database. You
configure the data flows to fail on a single error.
The control flow package is as shown in the following exhibit. (Click the Exhibit button.)
The package extracts data from files that are stored in two folders. Each folder can store a
maximum of 10 files.
You need to ensure that the package runs and loads additional files even if an error occurs
during the loading of a file.
What should you do?
Which action will you perform?
You are a professional level SQL Sever 2008 Database Administrator. A maintenance
strategy should be designed for a mission-critical database, and a large table named Orders
is contained by the database. Index maintenance operations are contained in the design
plan. When you design the strategy, the facts listed below should be taken into
consideration. First, the users continuously access to the Orders table in the database.
Secondly, a column of the xml data type is contained by Orders table. Thirdly, the new rows
are regularly added to the Orders table. Fourthly, the average fragmentation for the
clustered index of the Orders table is no more than 2 percent. A strategy should be
designed to have the performance of the queries on the table optimized. Which action will
you perform?
Which command line utility should you use?
You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
You plan to implement a failure recovery plan.
You need to back up the report server encryption key.
Which command line utility should you use?
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 have an application named Appl. You have a parameter named @Count that uses the int data
type. App1 is configured to pass @Count to a stored procedure. You need to create a stored
procedure named usp_Customers for Appl. Usp_Customers must meet the following requirements:
NOT use object delimiters.
Minimize sorting and counting.
Return only the last name of each customer in alphabetical order.
Return only the number of rows specified by the @Count parameter.
The solution must NOT use BEGIN and END statements.
Which code segment should you use?
To answer, type the correct code in the answer area.
Which rendering extensions should the users select?
You administer an instance of SQL Server 2008 Reporting Services.
You deploy various drill-down reports to the server. When users render these reports, detail
information that must be hidden by default is always present.
You need to ensure that users use an appropriate rendering extension that supports the
toggling of visibility.
Which rendering extensions should the users select?
Which partition query WHERE clauses should you use?
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You have a table named FactSales that contains columns named Country and Year.
You discover that data is frequently queried for the following values:
The Country column as USA
The Year column as 2008
You decide to implement two partitions for the measure group based on the FactSales table.
The first partition contains the frequently queried data and the second partition contains the
remaining fact table data.
Which partition query WHERE clauses should you use?
What should you recommend?
You are a database developer. You plan to design a database solution by using SQL Server
2008. The database includes a table that contains the following product inventory
information: ·Department ·Class ·Item ·Quantity You plan to write a query that produces the
sum of quantity data broken into the following groups. ·Department ·Department and Class
·Department and Item ·Department, Class, and Item You need to write the query by using
the minimum possible number of Transact-SQL statements. What should you recommend?