单项选择题

Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005computerthatrunsReportingServices.ReportingServicesisusedtoproducehundredsofreportseachday.YoudiscoverthattheReportServerTempDBdatabaseisgrowing.YouneedtominimizethesizeoftheReportServerTempDBdatabase.Whatshouldyoudo？（）
A.Decreasethetimebetweentransactionlogbackupsofthedatabase.
B.Deletereportsnapshothistoryeachweek.
C.Minimizetheuseofsessioncachinginthereports.
D.Minimizetheuseofreportsnapshotsinthereports.

A.ThecompanyusesaSQLServer2005computerthatrunsReportingServices.ReportingServicesisusedtoproducehundredsofreportseachday.YoudiscoverthattheReportServerTempDBdatabaseisgrowing.YouneedtominimizethesizeoftheReportServerTempDBdatabase.Whatshouldyoudo？（）
A.Decreasethetimebetweentransactionlogbackupsofthedatabase.
B.Deletereportsnapshothistoryeachweek.
C.Minimizetheuseofsessioncachinginthereports.
D.Minimizetheuseofreportsnapshotsinthereports.

你可能感兴趣的试题

单项选择题

Youareadatabaseadministratorforyourcompany.Thecompany’sfinancialforecastingapplicationusesaSQLServer2005databasethatenablesbusinessuserstorunbothadhocandpredefinedqueries.Yoususpectthatsomequeriesconsumeanexcessiveamountofserverresources.Youneedtoidentifywhichqueriesconsumethemostresources.Youwanttoachievethisgoalasquicklyaspossible.Whatshouldyoudo？（）
A.UsetheDBCCINPUTBUFFERcommand.
B.Usethesys.dm_exec_query_statsdynamicmanagementview（DMV）.
C.Usethesqldiagutility.
D.UsetheSHOWPLANsessionoption.

A.Thecompany’sfinancialforecastingapplicationusesaSQLServer2005databasethatenablesbusinessuserstorunbothadhocandpredefinedqueries.Yoususpectthatsomequeriesconsumeanexcessiveamountofserverresources.Youneedtoidentifywhichqueriesconsumethemostresources.Youwanttoachievethisgoalasquicklyaspossible.Whatshouldyoudo？（）
A.UsetheDBCCINPUTBUFFERcommand.
B.Usethesys.dm_exec_query_statsdynamicmanagementview（DMV）.
C.Usethesqldiagutility.
D.UsetheSHOWPLANsessionoption.

单项选择题

Youareadatabaseadministratorforyourcompany.ThecompanyhastwoSQLServer2005computersnamedSQL1andSQL2.SQL1islocatedonthelocalnetwork.SQL2islocatedatavendorssiteandisconnectedbyusingaVPNovertheInternet.YouneedtowriteheterogeneousqueriesonSQL1thataccessdatafrombothSQL1andSQL2.Toensurethatyourqueriesarefunctional，youmustconfigureaccesstothevendorssite.Whatshouldyoudo？（）
A.ConfigureanHTTPendpointforSQL2onSQL1.
B.ConfigureSQL2asalinkedserveronSQL1.
C.ConfigureanHTTPendpointforSQL1onSQL2.
D.ConfigureSQL1asalinkedserveronSQL2.

A.ThecompanyhastwoSQLServer2005computersnamedSQL1andSQL2.SQL1islocatedonthelocalnetwork.SQL2islocatedatavendorssiteandisconnectedbyusingaVPNovertheInternet.YouneedtowriteheterogeneousqueriesonSQL1thataccessdatafrombothSQL1andSQL2.Toensurethatyourqueriesarefunctional，youmustconfigureaccesstothevendorssite.Whatshouldyoudo？（）
A.ConfigureanHTTPendpointforSQL2onSQL1.
B.ConfigureSQL2asalinkedserveronSQL1.
C.ConfigureanHTTPendpointforSQL1onSQL2.
D.ConfigureSQL1asalinkedserveronSQL2.