You need to design the physical database structure for optimal backup performance
You administer a SQL Server 2008 instance. You plan to deploy a new database to the
instance. The database will be subject to frequent inserts and updates. The database will
have multiple schemas. One of the schemas will contain a large amount of read-only
reference data. You need to design the physical database structure for optimal backup
performance. What should you do?
You need to deploy SSRS in a fault tolerant scale-out deployment
You plan to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008
failover cluster. Internet Information Services (IIS) is installed on both nodes of the cluster.
The IIS is virtualized on the Network Load Balancing (NLB) cluster. You need to deploy
SSRS in a fault tolerant scale-out deployment. What should you do?
You need to migrate the reports and their snapshots to the production server in the minimum amount of time
You maintain a SQL Server 2008 Reporting Services (SSRS) database server.
The instance contains a large number of reports that take a long time to execute. The
reports contain multiple execution snapshots.
You have a new production server along with SSRS installed.
You need to migrate the reports and their snapshots to the production server in the minimum
amount of time.
What should you do?
You need to supply the stored procedure with multiple event names and their dates as parameters
You develop a database for a travel application. You need to design tables and other database
objects. You create a stored procedure. You need to supply the stored procedure with multiple
event names and their dates as parameters. What should you do?
You need to ensure that only the Managers group can view and modify reports in the Management Reports folder
You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server
contains a folder named Management Reports.
All groups can view and modify reports in any folder.
You need to ensure that only the Managers group can view and modify reports in the
Management Reports folder.
What should you do?
Which two actions should you perform?
You administer a SQL Server 2008 instance. You deploy a new database named
Engineering. The Engineering database manages large documents that will be revised
occasionally. You need to design a table structure that allows fast read access. You also
need to minimize storage space requirements. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)
Which database should you restore?
You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
A developer accidentally deploys 1000 reports to the SSRS instance.
You need to restore the SSRS instance to its original state.
Which database should you restore?
You need to provide a developer the ability to create and modify database diagrams from an existing database b
You need to provide a developer the ability to create and modify database diagrams from an
existing database by using SQL Server Management Studio. The solution must minimize
the amount of permissions assigned to the developer. What should you do?
You need to create a new subscription on the report server
You create a report by using SQL Server 2008 Reporting Services (SSRS).
You plan to deploy the report on a report server. The report will be delivered on a regular
basis to a dynamic list of subscribers.
You need to create a new subscription on the report server.
What should you do?
You need to configure the report server to cache the report for 30 minutes after the initial request
You create a report by using SQL Server 2008 Reporting Services (SSRS).
The report is complex and takes several minutes to generate.
You need to configure the report server to cache the report for 30 minutes after the initial
request.
What should you do?