Interview Questions

1. What can SQL Server Reporting Services do?

Options:

a. To create files

b. To create tables

c. To create Reports

d. None

Reveal Answer

2. How many default rending options are available in SSRS2008?

Options:

a. Four

b. Five

c. Two

d. One

Reveal Answer

3. What does mean by nested datasets?

Options:

a. Used datasets within dataset

b. A dataset

c. None

d. A table

Reveal Answer

4. You are managing a SQL Server 2008 Reporting Services (SSRS) sample which does not give some same rendering extensions for Company.com. You should make sure that you could set the server in order to render to Microsoft for Which is the correct answer?

Options:

a. You should change the AppSetttings.config file

b. You should change the Global.asax file

c. You should change the Machine.config file

d. You should change the RSReportServer.config file

Reveal Answer

5. You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com. In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?

Options:

a. You should back up the master database

b. You should back up the local database

c. You should back up the system database

d. You should back up the systemdb database

Reveal Answer

6. What are the parameters which should be considered for the Reporting Services Disk storage requirement?

Options:

a. Number of reports to be hosted server

b. Report size and frequency of reports

c. Number of snapshots to be saved

d. None of these

Reveal Answer

7. Can you use a stored procedure to provide data to an SSRS report?

Options:

a. Yes

b. NO

Reveal Answer

Interview Questions and Answer

1. What can SQL Server Reporting Services do?

2. How many default rending options are available in SSRS2008?

3. What does mean by nested datasets?

4. You are managing a SQL Server 2008 Reporting Services (SSRS) sample which does not give some same rendering extensions for Company.com. You should make sure that you could set the server in order to render to Microsoft for Which is the correct answer?

5. You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com. In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?

6. What are the parameters which should be considered for the Reporting Services Disk storage requirement?

7. Can you use a stored procedure to provide data to an SSRS report?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources