多项选择题

A.response times for frequently used queriesB.database ……

You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline?（）

A.response times for frequently used queries
B.database backup and restore completion times
C.disk I/O
D.CPU utilization
E.network packet size
F.SOAP requests failed

<没有了目录下一题>

热门试题

单项选择题YouneedtoensurethattheCust_CalcDatacolumnisimplementedappropriately.Whatshouldyoudo?（）

A.Specify that the Cust_CalcData column must be implemented as a computed column of the table.
B.Specify that the Cust_CalcData column must be indexed using a non-clustered index.
C.Specify that the Cust_CalcData column must be implemented as a column that uses a user-defined data type.
D.Specify that the Cust_CalcData column must be updated by a SQL Server Agent job that runs nightly.

单项选择题Youneedtoensurethatdatabaseschemachangesinbranchofficesresultinthepropernotifications.Whatshouldyoudo?（）

A.Install Notification Services on all branch office servers， and configure Notification Services to use a local notifications database.
B.Specify that all SQL Server log files must be archived and sent by e-mail to the main office.
C.Implement DML triggers that use Database Mail to send an e-mail message about the DML activity.
D.Implement DDL triggers that use Database Mail to send an e-mail message about the DDL activity.

单项选择题You need to design the Service Broker queues that will be used to submit requests for long-running reports. Your solution must minimize complexity of using the queues by applications. What should you do?（）

A.Specify one queue for each client application that can submit report requests.
B.Specify one queue for each of the two report-generation services.
C.Specify one queue for all long-running report requests.
D.Specify eight queues：One for each service， and one for each client application.

单项选择题Youneedtoensurethatolddataandcurrentdatacanbequeriedaccordingtothebusinessrequirements.Whatshouldyoudo?（）

A.Specify a view based on the archival data table and current data tables.
B.Specify that the data must be queried by using a stored procedure.
C.Specify that both the archival data table and the current data tables must have indexes created on the same columns.
D.Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.

多项选择题Youneedtodesignthedatabasepermissionsforaccessfromtheterminalstothedatabaseserver.Whichactionoractionsshouldyouperform?（）

A.Create a database role named BankTerminals.
B.Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.
C.Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.
D.Grant the BankTerminals role the Execute permission for the Bank schema.
E.Grant the Windows Bank Terminals group the Execute permission for the Bank schema.
F.Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.