seventy four.You generate a report through the use of SQL Server 2008 Reporting Solutions (SSRS).
The report is intricate and usually requires various minutes to generate.
You wish to configure the report server to cache the report for a half-hour right after the initial ask for.
What should you do?
A.Apply report snapshots.
B.Apply report execution caching.
C.Configure the info source to use snapshot isolation.
D.Configure the information supply to implement a database snapshot.
Answer: B
seventy five.You sustain a report in a very SQL Server 2008 Reporting Solutions (SSRS) instancE.The report is made up of question parameters that make it easy for consumers to filter the contents in the report. The report queries the data source randomly.
You configure the report to be rendered from a report execution snapshot.
You may need to ensure that people can continue to use parameters to filter the report.
What in case you do?
A.Add a default price to all parameters.
B.Modify the datasets to make use of the Table query kind.
C.Take out the filters from the dataset queries. Utilize the parameters to filter the datasets.
D.Move the queries for the stored processes. Make use of the stored methods to populate and filter the datasets within the report.
Solution: C
76.You create a report by making use of SQL Server 2008 Reporting Solutions (SSRS).
You intend to deploy the report on the report server. The report is going to be delivered often to a dynamic listing of subscribers.
You need to build a brand new subscription within the report server.
What should you do?
A.Pick out the report you established, then click on the newest Subscription button.
B.Find the My Subscriptions web page, and then click the brand new Data-driven Subscription button.
Do.Decide upon the report you created. Click the Subscriptions tab, and then just click the newest Data-driven Subscription button.
D.Pick the report you constructed. Click the Subscriptions tab, then simply click the brand new Subscription button.
Reply: Do
77.You acquire a SQL Server 2008 Reporting Providers (SSRS) report.
The report makes use of the “User!UserID” expression inside a text box inside the report header.
You wish to ensure that data-driven subscriptions successfully execute for this report.
What in case you do?
A.Clear away the expression through the report header.
B.Configure the report to work with no qualifications.
C.Configure the report to use saved credentials.
D.Modify the expression from the report header as “User!UserName.”
Response: A