Which step should be performed?
You are a professional level SQL Sever 2008 Database Administrator. The solution is
log-shipped for high-availability purposes. The data files of the database reside on drive D,
while the transaction log files of the database reside on drive E. A restoring test plan should
be implemented to satisfy the requirements listed below for the log-shipping solution. First,
the secondary database is brought online in the shortest time. Secondly, the data is in a
consistent state. Thirdly, the data loss is reduced to the least. The first step for the recovery
test plan should be identified in the event of drive D failure. Which step should be
performed?
You need to prevent the user from seeing their UserID What should you do?
You create a SQL Server 2008 Reporting Services (SSRS) report. The report is hosted in a
SharePoint environment.
The UserID is passed into the report automatically when the user views the report. The
UserID will be used to link to other pages on the SharePoint site via url.
You need to prevent the user from seeing their UserID
What should you do?
You need to create a parameter that gives the user the option to choose the server before report execution
You develop a SQL Server 2008 Reporting Services (SSRS) instance of a report model.
The organization requires that users of a report be able to dynamically change the server
environment.
You need to create a parameter that gives the user the option to choose the server before
report execution.
What should you do?
You need to ensure that the query retrieves data in minimum possible time
You are a database developer. You plan to design a database solution by using SQL Server
2008. The database application has a table named Transactions that contains millions of
rows. The table has multiple columns that include transaction_id and transaction_date.
There is a clustered index on the transaction_id column. There is a nonclustered index on
the transaction_date column. You discover that the following query takes a long time to
execute. You need to ensure that the query retrieves data in minimum possible time. What
should you do?
You need to create a drop down list that filters the report by one or more shoe colors
You maintain a SQL Server 2008 Reporting Services (SSRS) instance for a shoe company.
An existing report on shoe sales allows the user to see the company’s revenue across many
different attributes.
You need to create a drop down list that filters the report by one or more shoe colors.
You alter the main dataset and configure the report parameter to accept multiple values.
What should you do next?
Which action will you perform?
You are a professional level SQL Sever 2008 Database Administrator. A SQL Server 2008
instance at the New York central site is managed by you, and it is called Ins01. There is a
sales team in your company, and their task is to finish purchase orders for customer
requests. The sales team updates data regularly in a local database by utilizing their
portable computers. When the central site is connected by portable computers, a database
named Sales will be synchronized with the local database. A duplication model will be
created to duplicate the local database to the Sales database. The requirements listed
below should be satisfied by the duplication model: First, when the same data is updated
by multiple users independently, there should be no data conflicts. Secondly, sensitive
data such as product price cannot be updated by the sales team. Thirdly, the data should
be synchronized by the sales team not only at scheduled times but also on demand. The
best model should be identified to have data duplicated, and you should be reduced the
development efforts to the least. Which action will you perform?
Which role should you use?
You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise
Edition.
You need to use data-driven subscription to distribute reports based on dynamic subscription
data.
Which role should you use?
What is the correct dtutil command syntax?
You are responsible for the SQL Server 2008 Integration Services (SSIS) instance at your
organization. This instance uses SQL Server Authentication.
Other developers develop, configure, and deploy packages to the MSDB database.
You need to determine whether a package named “DailyLoad” exists in the MSDB database
on the local instance of SQL Server.
What is the correct dtutil command syntax?
which order should you perform the steps?
DRAG DROP
You have a SQL Server 2008 Reporting Services (SSRS) Enterprise Edition instance.
You need to add a second report server to this instance.
In which order should you perform the steps? (To answer, move the appropriate five actions
from the list of actions to the answer area and arrange them in the correct order.)
Which command syntax should you use?
You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare
device manufacturing company.
You develop a package named Memberinformation.dtsx with Windows authentication.
You deploy it to SQL Server. You need to validate Memberinformation.dtsx packages
without package execution.
Which command syntax should you use?