You need to configure a login to support the deployment of the new application
You plan to deploy a new application. The application will perform the following operations:
·Create a new database ·Add new logins ·Back up the new database You need to configure
a login to support the deployment of the new application. The solution must ensure that the
application uses the most restrictive permissions possible. What should you do?
You need to ensure that the report executes without user interaction from the Report Manager
You develop a SQL Server 2008 Reporting Services (SSRS) solution.
You add a report that contains a single dataset and a query parameter.
You need to ensure that the report executes without user interaction from the Report
Manager.
What should you do?
Which solution should you use?
You administer a SQL Server 2008 infrastructure. An instance hosts a business-critical
database that must be continuously available to the users without data loss. The database
includes Filestream data. You need to implement a high-availability solution for the site.
Which solution should you use?
You need to ensure that the application renders the report correctly
You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report will be included in a Windows Forms application that is distributed to remote
users.
These users have no access to the report server.
You need to ensure that the application renders the report correctly.
What should you do?
You need to ensure that the following requirements are met: Summary information is displayed when the report i
You design a report by using SQL Server 2008 Reporting Services (SSRS).
Detail information is displayed each time the users render the report.
You need to ensure that the following requirements are met:
Summary information is displayed when the report is initially rendered.
Detail information is displayed only when the users click a column header.
What should you do?
You need to modify the report to help search for multiple Category values by using minimum amount of developme
You develop a SQL Server 2008 Reporting Services (SSRS) report. The report contains a
parameter named Category that is used to filter a list of products. The list uses a dataset that
contains the following query:
You modify the report parameter to allow multiple values. You need to modify the report to
help search for multiple Category values by using minimum amount of development effort.
What should you do?
Which cluster configuration should you use?
You administer four SQL Server 2008 instances. Each instance hosts a single database
application. You plan to migrate all four instances to a new SQL Server failover cluster. The
four instances are configured as shown in the following table. The four instances are fully
optimized and have no spare CPU cycles or extra memory. The new cluster will host all four
databases on a single virtual cluster IP address. You need to ensure that the new cluster is
configured to handle the workload of all the database applications by using the minimum
amount of hardware resources. Which cluster configuration should you use?
You need to create a deployment manifest for all packages in the project
You are developing a SQL Server 2008 Integration Services (SSIS) project in Business
Intelligence Development Studio.
You configure the project properties as shown in the following image.
You need to create a deployment manifest for all packages in the project.
What should you do?
What should you recommend?
You are designing a maintenance strategy for a database that contains several views. The
views will be assigned custom permissions. You need to recommend a solution that will
allow developers to modify the views without affecting the views’ existing permissions. What
should you recommend?
You need to modify the package to refer to the SQL_PROD1 server when being executed
You create a SQL Server 2008 Integration Services (SSIS) package by using SQL Server
2008.
You use a development server named SQL_DEV1. There is no network connectivity
between the development server and the production server.
You deploy the package to the SQL_PROD1 server.
The package fails to execute. The error message states that the package cannot connect to
the SQL_DEV1 server.
You need to modify the package to refer to the SQL_PROD1 server when being executed.
What should you do?