单项选择题

A.Grant the SELECT permission on the Sales.Customers ob……

There are currently no permissions set on the following four objects in the proseware_biz database：

You need to permit the sales_employee database role to retrieve data by using the Sales.GetContact stored procedure.
Which action or actions should you perform？（）

A.Grant the SELECT permission on the Sales.Customers object to the sales_employee role.
B.Grant the SELECT permission on the Sales.CustomerContacts object to the sales_employee role.
C.Grant the SELECT permission on the Sales.ContactList object to the sales_employee role.
D.Grant the EXECUTE permission on the Sales.GetContact object to the sales_employee role.

<上一题目录下一题>

热门试题

单项选择题YouneedtodesignahostingserviceoptionforcustomerswhowanttoaccesstheirdatabasesbyusingtheirownActiveDirectorydomainaccounts.Whatshouldyoudo？（）

A.Design a hosting service option that duplicates each customer’s domain user account as SQL Serverlogin account.
B.Design a hosting service option that provides VPN-based connectivity from each customer’s network tothe SQL Server computer that hosts that customer’s daabase or databases.
C.Design a hosting service option that provides a dedicated server to each customer.Join that server to that customer’s Active Directory domain
D.Design a hosting service option that configures a unique instance of SQL Server 2005 for each customer.Configure that instance to use Integrated Windows authentication.

单项选择题Youneedtoimplementanauditingstrategythatwillfulfillthecompany’sbusinessrequirements.Whatshouldyoudo？（）

A.Use C2 auditing.
B.Use DML triggers.
C.Use DDL triggers.
D.Use event notifications.

单项选择题YouneedtodesigntheconsolidationplanforSQL1，SQL2，andSQL3.YouneedtoidentifytheappropriatecombinationofSQLServerinstancesandSQLServer2005computersthatareneededtofulfillthecompany’sconsolidationplansandsecurityrequirements.Whichcombinationshouldyouuse？（）

A.one SQL Server 2005 computer with one instance
B.two SQL Server 2005 computers， each with two instances
C.two SQL Server computers， one with one instance and one with three instances
D.one SQL Server 2005 computer with two instances

单项选择题YouneedtodesigntheconsolidationstrategyforthePromotionsandPartnersdatabases.Youwanttochooseastrategythatresultsinthebestdatabaseperformancewhilemaintainingthepermissionsofendusersineachdatabase.Whatconsolidationstrategyshouldyouchoose？（）

A.Place each database in a separate instance running on SQL2.
B.Place each database in a separate instance running on SQL3.
C.Place both databases in a single instance running on SQL2.
D.Place both databases in a single instance running on SQL3.

单项选择题YouneedtomigratetheDeliveryVans，AirlinePreferences，andSeasonalContractorsdatabasesintothedatacenter.Whatshouldyoudo？（）

A.Install a separate instance of SQL Server 2005 for each of the databases on a single server.
B.Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
C.Import the data from each of the databases into a single database in an instance of SQL Server 2005.
D.Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.