Which is the correct answer?
You are developing a SQL Server 2008 Reporting Services (SSRS) report for
Company.com.
You could show detailed information when the users changes the report.
The requirements should be met listed below:
*When the users click a column header, only detailed information is showed.
*When the report is rendered at the beginning of it, summary information is showed.
Which is the correct answer?
You need to ensure that sales trend analysis report runs as quickly as possible
You are a database developer. You create a database by using SQL Server 2008 in an
enterprise environment. The database contains two stored procedures named ModifySales
and RetrieveSalesTrend. The ModifySales stored procedure uses a transaction that
updates a table named SalesOrders. The RetrieveSalesTrend stored procedure retrieves
and aggregates data from the SalesOrders table for a sales trend analysis report. Both
stored procedures are executed frequently each day. Users report a considerable wait time
while they run the sales trend analysis report. You need to ensure that sales trend analysis
report runs as quickly as possible. What should you do?
Which action will you perform?
You are a professional level SQL Sever 2008 Database Administrator. A new database
application is hosted by the instance. The data security strategy should be designed for the
application. The data should be duplicated to another instance of SQL Server 2008 by
utilizing the Snapshot duplication. Since you are the technical support of the company, you
should make sure that all stored data should be encrypted, and the minimum amount of
administrative effort should be utilized. Which action will you perform?
Which is the correct answer?
You are creating a SQL Server 2008 Reporting Services (SSRS) report which utilizes a
Multidimensional Expressions (MDX) query including a parameter to show products
information for various product categories for Company.com.
The codes listed below:
SELECT NON EMPTY {[Measures].[Reseller Sales-Order Quantity] } ON COLUMNS,
NON EMPTY {([Month.[Calendar Year].[Calendar Year].ALLMEMBERS *
[Products].[Category].
[Category].ALLMEMBERS ) } ON CHAPTERS
FROM (SELECT (STRTOSET(@Category,CONSTRAINED)) ON COLUMNS FROM
[Adventure
Works Cube])
You find out that the search produces an error when running.
You should make sure that the query runs normally. Which is the correct answer?
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?
Which Transact-SQL query should you use?
You support a database structure shown in the exhibit. (Click the Exhibit button.)
You need to write a query that displays the following details:
Total sales made by sales people, year, city, and country
Sub totals only at the city level and country level
A grand total of the sales amount
Which Transact-SQL query should you use?
Which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.
The fact table named FactOrderstest should be included in the project; the table contains
columns named
*Order Amount,
*Country,
*Order Date Key
“Select * from FactOrderstest where [Order Date Key]>400 or Country=’CHINA'” is created
by the first partition for the fact table with the Source property the second partition for the fact
table to make sure that accurate results is outputted when queried should be created.
Which is the correct answer?
which is the correct answer?
You are creating a SQL Server 2008 Integration Services (SSIS) data flow which gets
information from two sources for Company.com.
You are in the process of creating a SQL Server 2008 Integration Services (SSIS) data flow.
Every source database is belongs to a different server and based on a SELECT statement
which utilizes an ORDER BY clause.
The data flow is listed below:
You get error message below when you connect the paths from the two sources
“Data Flow Task: The input is not sorted.
The ‘input “Merge Join Left Input” (80)’ must be sorted.”
You should make sure that data from every search is contained in every row in the data flow.
In order to solve the problem, which is the correct answer?
Which action should you perform?
You are a professional level SQL Sever 2008 Database Administrator. Your company wants
to enforce naming standards for the database objects. A solution should be designed by you
to enforce naming standards, and the least amount of administrative and programming
efforts should be utilized. Which action should you perform?
Which is the correct answer?
You are creating a SQL Server 2008 Integration Services (SSIS) instance which contains a
Data Flow task which reproduces some million rows for Company.com.
The data flow asks a match against a reference table which includes 50,000 rows including
every row would be utilized during the data flow in the reference table.
You should make sure that the data flow runs least time.
Which is the correct answer?