多选题You are adatabase developer. You develop atask management application that connect stoa SQLServer 2008 database named TaskDB.Users logon to the application by using a SQLServer login. The application contains amodule named Task that assigns tasks touse

题目

多选题

You are adatabase developer. You develop atask management application that connect stoa SQLServer 2008 database named TaskDB.Users logon to the application by using a SQLServer login. The application contains amodule named Task that assigns tasks tousers. Information about the setasks is stored in the Tasks table of the TaskDB data base. The Tasks table contains multiple columns. These include the Close Dateand Estimated Timecolumns. The application must meet the following security requirements: Users assigned toad atabase role named User 1 canupd ate all task information columns except the Close Date and the Estimated Time columns in the Tasks table. Administrative users assigned toad atabase role named Task_Admin canupd ateall task information in the Tasks table.You needto design a strategy to meet the security requirements. Which two actions should you perform?（）

Add the Task_Admin role to thedb_accessadmin fixed database role.

Grant Update permissions on the Tasks table to the Task_Admin role.

Grant Update permissions on the Tasks table to the User 1 role foreach column except the Close Dateand Estimated Time columns.

Createan INSTEAD OF trigger on the Tasks Table. Use theIs_Member function toprevent the User 1 role from updating the Close Date and Estimated Time columns.

参考答案和解析

正确答案： C,D

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You are adatabase solutionsarchitect.Your company plansto develop asolution by using a SQLServer2008instance.The solutionhasthefollowingbusinessrequirements:ImportdatafromvariousdatasourcessuchasMicrosoftOfficeExcel,Microsoft SQL Server2000,MicrosoftSQLServer2005,andCSVfiles.Profilethesourcedatabeforeitisimported.Providecollaborationandofflinecapabilitiestomobileusers.Allowmobileuserstouseheterogeneousdatastores.YouneedtoconfiguretheappropriateSQLServercomponentstoaccomplishthebusinessrequirements.Youwanttoachievethisgoalbyusingtheminimum amountofadministrativeeffort.

Whichtwo SQL Server componentsshould you use?（）

参考答案：C, E

第2题：

You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

A、Database Control
B、Management Server
C、Management Repository
D、Application Server Control
E、Oracle Management Agent

正确答案:E

第3题：

You develop a serializable class for persisting objects as files.Every time an object is serialized, you have to update the database with the name of the object and location of that file.You elect to employ the OnSerialized attribute to achieve this objective.You now need to apply the OnSerialized attribute to a certain method.What should you do?（）

参考答案：C

第4题：

You are employed as the exchange administrator at TestKing.com. You are in the process of installing anew Exchange Server 2010 Organization. Outlook Web App is used throughout the organization by usersto access their e-mail. TestKing.com wants you to implement a new compliance policy that states that e-mail messaging containing client contracts be kept for two years. Management also wants users to classify e-mails relatingto client contracts as well as moving e-mail messages to other folders. You are instructed a solution thatwill comply with the set criteria. What should you do？（）

A、You should recommend Retention Policy Tags as well as a Retention Policy to management.
B、You should recommend an OWA mailbox policy to management.
C、You should recommend Managed Folder mailbox policies to management.
D、You should recommend Personal Archives and an Archive policy to management.

正确答案:A

第5题：

If an existing script is uploaded to the CRS, what does it ask?（）

A、Do you want to debug the script?
B、Do you want to refresh the script?
C、Do you want to save the application?
D、Do you want to return to Script Management?

正确答案:B

第6题：

When do you need to configure the P1 interface？（）

A、 whenever you have an upstream proxy
B、 whenever you intend to deploy the L4TM in blocking mode
C、 whenever you want to enable the WSA proxy
D、 whenever you have a separate management VLAN orsubnetwork

正确答案:D

第7题：

Certkiller.com has employed you as a Web Application Developer. You are in the process ofcreating an ASP.NET application using Microsoft .NET Framework v3.5. You decide to create acustom Web user control for the application. You name this control TestShare. TestShare will be compiled as a library. The code below iswritten for TestShare. （The line numbers is included for reference purposes） 1 Protected Overloads Overrides Sub OnInit（ByVal e As EventArgs） 2 MyBase.OnInit（e） 3 4 End Sub The master pages in the application contains the directive below：<%@ Master Language="VB" EnableViewState="false" %> You receive an instruction from management to make sure that the state of TestShare is able tocontinue on the pages that reference a master page. You thus need to determine the appropriatecode that should be added at line 3. What should you identify？（）

A、You should consider adding the Page.RegisterRequiresControlState(Me) code fragment.
B、You should consider adding the Page.UnregisterRequiresControlState(Me) code fragment.
C、You should consider adding the Page.RegisterStartupScript("TestShare", "server") codefragment.
D、You should consider adding the Page.RegisterRequiresPostBack(Me) code fragment.

正确答案:A

第8题：

You are adatabase developer.You develop ataskmanagementapplication that connect stoa SQLServer2008databasenamed TaskDB.Users logon to the application by using a SQLServer login. The application containsamodulenamed Taskthatassignstaskstousers.Informationaboutthe setasksisstoredinthe Taskstableofthe TaskDB data base.The Taskstablecontainsmultiplecolumns.These include the Close Dateand Estimated Timecolumns.Theapplication mustmeetthefollowingsecurityrequirements:Usersassigned toad atabase role named User 1 canupd ate all taskinformation columnsexceptthe Close Dateandthe Estimated TimecolumnsintheTaskstable.Administrative usersassigned toad atabase rolenamed Task_Admincanupd ateall taskinformation intheTaskstable.Youneedtodesignastrategy tomeetthesecurityrequirements.

Whichtwoactionsshouldyouperform?（）

参考答案：B, C

第9题：

You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to view the replication status of a mailbox database copy in the organization. What should you do？（）

A、You should consider having the properties of the database copy viewed from the Exchange Management Console （EMC）.
B、You should consider having the properties of the Mailbox server viewed from the Exchange Management Console （EMC）.
C、You should consider having the Test-ServiceHealth cmdlet run from the Exchange Management Shell.
D、You should consider having the Get-DatabaseAvailabilityGroup cmdlet run from the Exchange Management Shell.

正确答案:A

第10题：

You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization.Company.com has its headquarters in London where you are located.During the course of the day you receive notification from management to view the a number of mailbox on the servers that is bigger than 1 GB.What should you do？（）

A、You should consider having the properties of the mailbox database viewed from the Exchange Management Console （EMC）.
B、You should consider running the Get-Mailbox cmdlet from the Exchange Management Shell.
C、You should consider running the Get-MailboxStatistics cmdlet from the Exchange Management Shell.
D、You should consider having a recipient filter created from the Exchange Management Console （EMC）.

正确答案:C

You are adatabase developer. You develop atask management ap

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容