题目内容

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?（）

A. You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.
B. You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
C. You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
D. You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.

查看答案

搜索结果不匹配？点我反馈

更多问题

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO\Supervisors. A Windows user named User1 is a member of the WIIKIGO\Supervisors group. WIIKIGO\Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）

A. DROP LOGIN "WIIKIGO\User1";
B. EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';
C. EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1';
D. CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1";

查看答案

Which of the following is the correct syntax to specify the path to a file that generates the strong type？（）

A. <%@ PreviousPageType VirtualPath ="~/MyPage.aspx"% >
B. <%@ PreviousPageType VirtualPath ="/MyPage.aspx/ ~"% >
C. <%@ PreviousPageType VirtualPath ="~/MyPage.master"% >
D. <%@ PreviousPageType VirtualPath ="~/MyPage"% >

查看答案

You are working as a network technician， study the exhibit carefully. Your boss has informed youthat there have been problems with the WAN that is using EIGRP routing protocol. You arerequired to troubleshoot these problems. Before going to the questions of this sim， we should have a quick review about GRE tunneling：GRE Quick Summary. The picture below shows how to configure a GRE Tunnel between two routers， notice that the"tunnel destination" must be the IP address of the interface， not of the opposite tunnel. Notice： The tunnel source on one router must be specified as the tunnel destination on the otherrouter. Below are the questions of this lab-sim. What is preventing the HQ router and the Branch1 router from building up an EIGRP neighborrelationship？（）

A. When running EIGRP over GRE tunnels， you must manually configure the neighbor addressusing the eigrp neighbor ipaddress command
B. The tunnel destination address is incorrect on the HQ router. It should be 10.2.1.1 to match theinterface address of the Branch1 router
C. The tunnel source is incorrect on the Branch1 router. It should be serial 2/0
D. The default route is missing from the Branch1 router
E. The tunnel interface numbers for the tunnel between the HQ router and Branch1 router do notmatch

查看答案

ou work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?（）

A. You should use the http.sys listener to install the SSRS instance.
B. You should configure the SSRS database, make it use Native mode
C. You should configure the SSRS database, make it use SharePoint integrated mode
D. You should use the Internet Information Services default Web site to install the SSRS instance

查看答案