Which Transact-SQL query should you use?
A table named Profits stores the total profit made each year within a territory. The Profits table has
columns named Territory, Year, and Profit.
You need to create a report that displays the profits made by each territory for each year and its
previous year.
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.
Some object show below in the cube
* A time dimension named TimeDimension that has an attribute named TimeKiller.
* A fact table named FactOrdersTable.
Different hierarchies should be included in the Time dimension,
You should take method to do it
Which is the correct answer?
Which action should you perform to finish the task?
You are a professional level SQL Sever 2008 Database Administrator. A database is hosted
by the instance and the database is configured by utilizing high-safety mirroring operation
mode along with a witness server. A memory failure is experienced by the witness server;
therefore the server will be offline for five hours. The mirroring strategy should be reset to
cut the risk of database unavailability to the least level. Which action should you perform to
finish the task?
Which is the correct answer?
You are changing a SQL Server 2008 Integration Services (SSIS) instance which get
information from a doc file and loads this information to a SQL Server 2008 table for
Company.com. The information is listed below:
You should make sure that you could modify the instance to get data from many text files of
the same directory.
Which is the correct answer? (Select more than one)
Which is the correct answer?
You are creating a SQL Server 2008 Integration Services (SSIS) instance which includes
components listed below for Company.com.
A String variable called FileTestName.
A String variable called DirectoryTestPath.
A Foreach Loop container for the Collection property is listed below:
A Foreach Loop container for the Variable Mappings property is listed below: In order to
update the package so that the DirectoryTestPath variable gets the directory path for the file
path reserved in the FileTestName variable.
Which is the correct answer? (Select two)
Which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) method for
Company.com.
There is a dimension called Product and a time dimension called TestTimer in your solution.
You own a fact table which includes a column called ProductBalance which includes the
current account balance.
You should make sure that you develop a measure called Test ProductBalance from the
TestBalance column to show the closing account balance for some times.
Which is the correct answer?
You need to ensure that users can execute the stored procedures
You are a database developer. You develop solutions by using SQL Server 2008 in an
enterprise environment. You plan to create a stored procedure that queries a sales table
and produces forecast data. You do not have administrative permissions, and you are not
the owner of the database. You have permissions to create stored procedures. Users will
only have permissions to execute your stored procedures. You need to ensure that users
can execute the stored procedures. What should you do?
What should you do first before start the batch process?
You are a professional level SQL Sever 2008 Database Administrator. A large financial
database is hosted by the instance. The backup strategies listed below are contained by the
database: First, the performance of a full database backup is implemented once a week.
Secondly, the performance of a differential backup is implemented every day. Thirdly, the
performance of a transaction log backup is implemented every hour. An end-of-year batch
process should be implemented, and the process takes two hours to run. About five percent
of data within the database will be changed by the batch process. Since you are the
technical support, you are required to make sure that the batch operation can be rolled back
in the shortest time, if the batch process is not approved by the Finance department. What
should you do first before start the batch process?
Which is the correct answer?
You are managing a SQL Server 2008 Reporting Services (SSRS) sample which includes
some reports for Company.com.
Through utilizing the Business Intelligence Development Studio (BIDS), you will publish a
report project.
You find out that the data sources are changed through the test data sources on the report.
You should make sure that the existed reports are running normally when the report project
is published soon.
Which is the correct answer?
Which is the correct answer?
You are running a SQL Server 2008 Analysis Services (SSAS) solution which contains data
mining extensions (DMX) to search a data mining model for Company.com.
In order to search a Clerk Walker data mining model in a Decision Tree data mining
structure, the codes are listed below:
11 SELECT
12 [Decision Tree].[Clerk Walker] AS Buyer
13 FROM
14 [Decision Tree]
15
16 (SELECT 28 AS [Age],
17 ‘2-5 Miles’ AS [Commute Distance],
18 ‘1’ AS [House Owner Flag],
19 1 AS [Number Cars Owned],
20 2 AS [Total Children]) AS t
In the data mining structure, you should make sure that the input columns map to the
columns. Which is the correct answer?