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?（）A、Analysis ServicesB、Reporting ServicesC、Integration ServicesD、Notification ServicesE、Microsoft Sync Framework
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?（）
- A、Analysis Services
- B、Reporting Services
- C、Integration Services
- D、Notification Services
- E、Microsoft Sync Framework
相关考题：
Are you still here? You were here half an hour ago. Who( )for? A、were you waitingB、are you waitingC、did you waitD、do you wait
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?（）
Youare adatabase developer.Youplantodesigna&ensp Youare adatabase developer.YouplantodesignadatabasesolutionbyusingSQLServer2008.You are creating adataba seto supportthe office manager.Your database modelhasthe following structure.Thedatabasedesignhasthefollowing businessrequirements:Anemployeecanbeassignedmorethanone task.Uponcompletion,thetaskisdeleted.Whenataskisdeleted,theassociatedassignmentisdeleted.When an employee isnolonger availabletocomple tea task,theemployee linkto the assignmentisreplacedwithaNULLvalue.Youneed toimplementthebusinessrequirementstomaintaindataintegrity.Whatshouldyoudo?（）
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?（）
How do you do? Glad to meet you.（）AFine. How are you?BHow do you do? Glad to meet you, too.CHow are you? Thank you!DNice. How are you?
下面代码执行后，正确的输出结果是（）。A、You are fired! You are hired!B、You are fired! You are fired!C、You are hired! You are hired!D、You are hired! Youarefired!
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.
多选题In a two-tier configuration， it is recommended to put which of the following components on different nodes？（）ADatabase client and database serverBWebSphere Application Server and Database ServerCWebSphere Commerce Server and WebSphere Application ServerDWeb server and WebSphere Application Server
单选题How do you do? Glad to meet you.（）AFine. How are you?BHow do you do? Glad to meet you, too.CHow are you? Thank you!DNice. How are you?
单选题SQL语句的编译和执行是在SGA的哪一部分中进行的（）ADatabase Buffer CacheBRedo Log BufferCShared PoolDLarge PoolEJava Pool
单选题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？（）ADatabase ControlBManagement ServerCManagement RepositoryDApplication Server ControlEOracle Management Agent
多选题Which two are the prerequisites to enable Flashback Data Archive？（）ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.
单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）ADatabase Datafiles BDatabase Control Files COnline redo logsDArchived redo logs EThe database SPFILE FNone of the above, all these files are backed up.
单选题FusionSphere OpenStack控制节点中，不会包含以下哪个角色？（）Adatabase_keystoneBmeasureCvcenter-prowyDCeilometer
多选题Which three features are supported in a license for Cisco Unified Contact Center Express Enhanced? （）Adatabase integrationBprompt and collectCVoiceXMLDopening and parsing HTTP and XML documentsEPQFE-mail Queuing
多选题Which four service offerings are included in Oracle Public Cloud?（）ADatabase ServiceBData ServiceCJava ServiceDSecurity ServiceE.NET ServiceFSOA Service
多选题Which of the following files cannot be backed up by RMAN？（）ADatabase datafilesBControl filesCOnline redo logsDDatabase pfilesEArchived redo logs
多选题ASM supports all but which of the following file types？（）ADatabase filesBSpfilesCRedo-log filesDArchived log filesERMAN backup setsFPassword filesGinit.ora files
单选题如果一个SQLServer数据库维护人员，需要具有建立测试性的数据库的权限，那么应该指派给他哪个权限（）？ADatabase CreatorsBSystem AdministratorsCServer AdministratorsDSecurity Adiministrators
单选题If you were offered a trip to the moon, ______ it?Adid you acceptBare you going to acceptCwill you acceptDwould you accept
多选题Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
单选题Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）ADatabase replayBSQL Tuning AdvisorCSQL Access AdvisorDSQL Performance AnalyzerEAutomatic Workload Repository compare reports
单选题The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）Adatabase table Btransactional trigger Cstored procedure DFROM clause query Eclient-side procedure
多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs
多选题Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）ADatabase datafilesBControl filesCOnline redo logsDDatabase pfilesEArchived redo logs
多选题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?（）AAnalysis ServicesBReporting ServicesCIntegration ServicesDNotification ServicesEMicrosoft Sync Framework