You  are  adatabase  solutions architect.Your  company  plans to  develop  asolution  by  using  a  SQLServer 2008 instance. The  solutionhas the following business requirements: Import datafromvarious datasources suchas MicrosoftOffice Excel, Microsoft  SQL  Server2000, Microsoft SQL Server 2005, and CSV files. Profile the source data before it is imported. Provide collaboration andoffline capabilities to mobile users. Allowmobile users to use heterogeneous data stores. You need to configure the appropriate SQL Server components to accomplish the business requirements. You want to achieve this goal by using the minimum  amount of administrative effort.
Which two  SQL  Server  components should  you  use?（）

多项选择题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?（）

A.Add the Task_Admin role to thedb_accessadmin fixed database role.
B.Grant Update permissions on the Tasks table to the Task_Admin role.
C.Grant Update  permissions on  the  Tasks table to  the  User  1  role foreach  column  except the  Close  Dateand Estimated  Time columns.
D.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.

单项选择题Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?（）

A.ALTER DATABASE Sales  MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)
B.ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)
C.EXEC sys.sp_configure 'fill factor (%)', '60'
D.UPDATE STATISTICS Sales.Sales History(Products)  WITH FULLSCAN, NORECOMPUTE

单项选择题You are a database developer. You plan to design a database solution byusing SQL Server 2008. You are creating adataba seto support the office manager. Your database model has the following structure. The database design has the following business requirements: An employee can be assigned more than one task. Upon completion, thetask is deleted. When a task is deleted, the associated assignment is deleted. When an employee is nolonger available tocomple tea task, theemployee link to the assignment is replaced with a NULL value. You need to implement the business requirements to maintain data integrity. What should you do?（）

A.Create DDL INSERT triggers on the Employee. Task and  Assignment entities.
B.Create CHECK constraints on the Task  ID and Employee  ID attributes in the  Assignment entity.
C.Create  Foreign  Keys constraints on  the  Task  ID and  EmployeeID attributes in the  Assignment entity. Reference the Task and  Employee entities respectively. Specify the  appropriate On Delete action.
D.Create  Foreign  Keys constraints  on  the  Task  ID and  Employee  ID attributes in theTask and  Employeeentities respectively. Reference the  Assignment entity, and specify the  appropriate On Delete action.

多项选择题Youneedtocreateacolumnthatallowsyoutocreateauniqueconstraint.Whichtwo column definitionsshouldyou choose?（）

A.nvarchar（100） NULL
B.nvarchar（max） NOT NULL
C.nvarchar（100） NOT NULL
D.nvarchar（100） SPARSE NULL