Which action will you perform?
You are a professional level SQL Sever 2008 Database Administrator. A database is
included by an instance. And a large table named OrderDetails is included by the database.
Only DML statements on the last three months data are executed by the application
queries. Administrative audits are managed monthly on data which is longer than four
months. The performance problems listed below are found by you in the database. The
performance of the application queries against the OrderDetail table is poor. It takes a long
time to perform the maintenance tasks against the database, index defragmentation is
contained. The performance problems should be solved with on impact on the server
performance. Which action will you perform?
You need to ensure that the following requirements are met: The data source view uses the altered table name a
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a data source
view.
You add a table named Customer from the data source to the data source view.
You alter the name of the table from Customer to DimCustomer in the data source.
You need to ensure that the following requirements are met:
The data source view uses the altered table name as the source.
All existing relationships and table references are preserved.
What should you do?
You need to configure the server so that all reports render only to Microsoft Excel
You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
Your instance supports several different rendering extensions.
You need to configure the server so that all reports render only to Microsoft Excel.
What should you do?
Which expression should you use?
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a
time dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.
You have a measure named Amount from a measure group named Measures.
You need to create a calculated member to display the Amount measure in the previous time
period for the current level of the Yr-Qtr-Mth hierarchy.
Which expression should you use?
What kind of collector should you utilize?
You are a professional level SQL Sever 2008 Database Administrator in an international
corporation named Wiikigo. A 32-bit version is utilized by the instance on a Windows Server
2008 64-bit server. You activate the awe enabled option. A predictable increase in query
activity will be experienced by the instance. You are required to figure out the most proper
and beneficial time to have the databases migrated to a 64-bit SQL Server 2008 server on
the same hardware. A data collector type that proper information is provided should be
identified. What kind of collector should you utilize?
Which DTExec command line option should you use?
You develop a SQL Server 2008 Integration Services (SSIS) package.
You discover that the package fails and returns an error code of 0x80040E4D.
You need to ensure that the package generates the debug dump files that are associated
with the package only when this error code occurs.
Which DTExec command line option should you use?
You need to modify the package so that the Script task can assign the value of the variable
You design a SQL Server 2008 Integration Services (SSIS) package.
The package assigns a value to a variable by using a Script task. When the package
executes successfully, the value of the variable is not updated.
You need to modify the package so that the Script task can assign the value of the variable.
What should you do?
Which data type should you use?
You are developing a database that will contain price information.
You need to store the prices that include a fixed precision and a scale of six digits.
Which data type should you use?
You need to retrieve all levels by using a single Transact-SQL query
You are a database developer. You plan to design a database solution by using SQL Server
2008. The database will contain a table that has a parent-child relationship to itself. Each
child might also be a parent. This might exist up to 10 levels deep. You need to retrieve all
levels by using a single Transact-SQL query. What should you do?
Which code segment should you use in the report header?
You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a table that displays a list of products. The list of products includes the
three fields named ProductName, ProductCategory, and ProductPrice. The table contains a
textbox named ProductCategory that displays the ProductCategory field.
The dataset is sorted by ProductCategory.
You need to ensure that the report header displays the ProductCategory of the first product
listed on each page of the report.
Which code segment should you use in the report header?