PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
are responsible for the security in SQL Server 2008 Reporting Services (SSRS). After a new
user is assigned to a role, you should give the permissions to the user, making the user

publish reports and manage content only in a private folder. So what action should you
perform?

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. You
company CIO decides to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL
Server 2008 failover cluster. Since you are the IT support, the company CIO assigns this
task to you. You check and find that both nodes of the cluster have been installed with
Internet Information Services (IIS) which is virtualized on the Network Load Balancing (NLB)
cluster. Now you have to perform the deployment of the SSRS in a fault-tolerant scale-out
deployment. So what action should you perform?

You need to ensure that the following tasks are accomplished: ·The import is successfully completed even

You are a database developer. You create a database that uses SQL Server 2008 in an
enterprise environment. You plan to import data from an external source into a table. You
need to ensure that the following tasks are accomplished: ·The import is successfully
completed even if it encounters rows that fail foreign key constraints. ·The rows that fail the
foreign key constraints during import are inserted into a separate table. What should you
do?

what action should you perform to achieve this goal?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
are in charge of a SQL Server 2008 Reporting Services (SSRS) database server. Large
quantities of reports are contained in the instance, and the reports executes slowly. Multiple
execution snapshots are contained in the reports. There is a new production server and you
have installed SSRS on the server. Now you receive an e-mail from your company CIO,
according to the requirement of the CIO, the reports and their snapshots have to be moved
to the production server as soon as possible. You’ve been assigned this task. So what action
should you perform to achieve this goal?

You need to ensure that the user names and passwords are protected from access by unauthorized users

You administer a SQL Server 2008 instance. You plan to deploy new SQL Server 2008
Integration Services (SSIS) packages that are created by the SQL Server Import and Export
Wizard. The packages will connect to external data sources by using stored user names
and passwords. You need to ensure that the user names and passwords are protected from
access by unauthorized users. What should you do?

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
are in charge of a SQL Server 2008 Reporting Services (SSRS) instance. Some reports are
included in the instance. The reports access data from a SQL Server 2008 instance by using
stored credentials. There is a computer which contains an instance. The computer
experiences hardware failure, after it recovers, you install a new SSRS instance on it. Now
you must make sure that the reports hosted on the instance can still function correctly. So
what action should you perform?

what action should you perform?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
There is a SQL Server 2008 Reporting Services (SSRS) instance. Now you are in charge of
a report in this instance.
Query parameters are contained in this report which queries the data source at random.
Users are allowed to filter the contents of the report according to the query parameters.
You perform this configuration on the report, making it be rendered from a report execution
snapshot.
You must make sure that parameters can still be used to filter the report after the
configuration.
So what action should you perform?

what should you do to successfully execute the package?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
According to the requirement of the company CIO, you are using SQL Server 2008
Integration Services (SSIS) to create packages.
The package connects to a third-party database server by using an OLE DB connection
manager.
Integrated Windows authentication is not supported by the database.

A configuration file is created to configure the connection manager. The configuration file is
added to the package after it is created.
An error message pops up when the package executes.
The error message says that the login step fails. Now you must solve this problem.
So what should you do to successfully execute the package?

You need to ensure that the application developers can deploy the project successfully to the production serve

You administer a SQL Server 2008 instance for your company. Your company has a team
of database administrators. A team of application developers create SQL Server 2008
Integration Services (SSIS) packages on the test server in a shared project. One of the
packages requires a fixed cache file. On completion of development, the packages will be
deployed to the production server. Only the database administrators can access the
production server. You need to ensure that the application developers can deploy the
project successfully to the production server. What should you do?