单项选择题
You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory, but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources.
What should you do?()
A.Design a report for Susan that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then, design a report for Joe that displays the detailed sales data.
B.Design two reports for Susan. One report includes the territory information, and one report includes the detailed sales data. Then, design a report for Joe that displays the detailed sales data for his territories.
C.Design a report for Susan that includes the territory information. Then, design a report for Joe that includes detailed sales data for his territories. Finally, configure Susans report so that it includes the data in Joes report.
D.Design a parameterized report for Susan that includes all territory information. Then, design a linked report for Joe that links to Susans report.
相关考题
-
单项选择题
Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005computerthatrunsReportingServices.ReportingServicesisusedtoproducehundredsofreportseachday.YoudiscoverthattheReportServerTempDBdatabaseisgrowing.YouneedtominimizethesizeoftheReportServerTempDBdatabase.Whatshouldyoudo?()
A.Decrease the time between transaction log backups of the database.
B.Delete report snapshot history each week.
C.Minimize the use of session caching in the reports.
D.Minimize the use of report snapshots in the reports. -
单项选择题
Youareadatabaseadministratorforyourcompany.Thecompany’sfinancialforecastingapplicationusesaSQLServer2005databasethatenablesbusinessuserstorunbothadhocandpredefinedqueries.Yoususpectthatsomequeriesconsumeanexcessiveamountofserverresources.Youneedtoidentifywhichqueriesconsumethemostresources.Youwanttoachievethisgoalasquicklyaspossible.Whatshouldyoudo?()
A.Use the DBCC INPUTBUFFER command.
B.Use the sys.dm_exec_query_stats dynamic management view (DMV).
C.Use the sqldiag utility.
D.Use the SHOWPLAN session option. -
单项选择题
YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1containsadatabasethatutilizesSQLServerlogshipping.Logshippingoccursevery30minutes.Eachnight,afullbackupismadeofthedatabase,andalldatabaseindexesarerebuilt.Thecompany’snetworkadministratorreportsthatSQL1snetworkutilizationbecomesexcessiveafterthenightlymaintenancetasksarecomplete.YouneedtoreducethenetworkbandwidthutilizationforSQL1.Whatshouldyoudo?()
A.Configure the database to use the bulk-logged recovery model.
B.Each night, rebuild only those indexes that require it.
C.Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
D.Increase the time between transaction log backups.
