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?()

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?()


相关考题:

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()A. The tuned plan is not added to the SQL plan baseline.B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform?()A、In a SQL Trace log file, you should look for queries with low duration values and high read and write values.B、In a query execution plan, you should look for queries with missing or out-of-date statistics.C、In a SQL Trace log file, you should look for queries with high duration values and low read and write values.D、In a query execution plan, you should look for queries with a large number of table scans.

You have an Exchange Server 2010 organization.  All users access their mailboxes by using Outlook Web App (OWA).  You need to plan a solution to reduce the number of e-mail messages that are accidentally sent todistribution groups that contain company executives.  What should you include in the plan?()A、custom MailTipsB、dynamic distribution groupsC、Outlook Protection RulesD、sharing policies

Your company has 300 portable computers that run Microsoft Office Enterprise 2007. The company participates in the Microsoft Software Assurance program.  You are designing a solution that enables remote employees to use Office and to access their Home folders. You plan to implement a Remote Desktop Services (RDS) infrastructure, and you plan to deploy Office Enterprise 2007 as a virtual application on the RDS servers. You need to choose the appropriate licenses.  Which licensing solution should you choose?()A、1 Office Enterprise 2007 license and 300 App-V for Terminal Services licensesB、300 Office Enterprise 2007 licenses and 300 App-V for Terminal Services licensesC、300 Office Enterprise 2007 licenses and 300 Microsoft Desktop Optimization Pack (MDOP)licensesD、300 Windows Server 2008 R2 RDS client access licenses (CALs)

Your company has a main office and 10 branch offices. You have an Exchange Server 2010 organization.  All Exchange servers are installed on virtual machines.  You need to create a monitoring plan for the Exchange servers that meets the following requirements:.Identify Exchange server errors .Provide alerts when Exchange services are stopped .Produce statistical analysis and reporting Which tool should you include in the plan?()A、Microsoft System Center Service ManagerB、Microsoft System Center Operations ManagerC、Microsoft System Center Configuration ManagerD、Microsoft System Center Virtual Machine Manager

Your company has two main offices named Main1 and Main2.An Active Directory site exists for each office. Users connect locally to servers in both offices.  The offices connect to each other by using a high-speed WAN link. You plan to deploy Exchange Server 2010.  You need to plan the deployment of Mailbox servers to meet the following requirements: .Ensure that users can access their mailbox from a server in their site, if a single Mailbox server fails  .Ensure that users can access their mailboxes remotely if a site fails  .Minimize the number of servers How many Mailbox servers should you include in the plan?()A、2B、3C、4D、6

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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? () A、You should backup the master databaseB、You should backup the default.trc fileC、You should backup the SQL Server registry hive.D、You should backup the resource database

You have an Exchange organization named nwtraders.com.All servers in the organization have Exchange Server 2010 Service Pack 1 (SPl) installed.Your company acquires another company named Contoso, Ltd. You plan to create new mailboxes for each user from Contoso. You need to ensure that each new mailbox can receive e-mail messages sent to contoso.com.Which two objects should you create?()A、a Receive connectorB、a Remote domainC、an organizational relationshipD、an accepted domainE、an e-mail address policy

You 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. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?()A、For the SQL Server Agent, you should enable a fail-safe operator B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

You work as the enterprise exchange administrator at TestKing.com. TestKing.com makes use of Microsoft Exchange Server messaging solution. The TestKing.com network consists of a single ActiveDirectory domain named testking.com. TestKing.com is configured to run in an Exchange Server 2010 environment. You have received instructions from the CIO to minimize the amount of e-mail messages for company executives, which areusally sent to the distribution groups. What should you do?()A、The best option is to include sharing policies in the plan.B、The best option is to include Outlook Protection Rules in the plan.C、The best option is to include custom MailTips in the plan.D、The best option is to include dynamic distribution groups in the plan.

You 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. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory.  Which SQL Server database engine subdirectory should be backed up?()A、DATAB、INSTALL C、LOG D、BINN

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.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?()  A、You should use the Database Engine Tuning Advisor. B、In Microsoft SQL Server Management Studio, you should create a maintenance plan C、You should use the SQL Server Configuration Manager D、In Microsoft SQL Server Management Studio, you should create a policy

单选题Your company has 300 portable computers that run Microsoft Office Enterprise 2007. The company participates in the Microsoft Software Assurance program.  You are designing a solution that enables remote employees to use Office and to access their Home folders. You plan to implement a Remote Desktop Services (RDS) infrastructure, and you plan to deploy Office Enterprise 2007 as a virtual application on the RDS servers. You need to choose the appropriate licenses.  Which licensing solution should you choose?()A1 Office Enterprise 2007 license and 300 App-V for Terminal Services licensesB300 Office Enterprise 2007 licenses and 300 App-V for Terminal Services licensesC300 Office Enterprise 2007 licenses and 300 Microsoft Desktop Optimization Pack (MDOP)licensesD300 Windows Server 2008 R2 RDS client access licenses (CALs)

问答题Practice 4  ● A foreign business associate is visiting your company for three days. You have been asked to organize the visit and plan appropriate entertainment.  ● Write a letter to the visitor outlining a timetable for the visit and describing the activities you have planned.  ● Write 200-250 words on your Answer Sheet.

单选题You want to create a template to be used as a standard for all company reports, which are many different styles. How many different templates must you have if you plan to use multiple report styles?()ATwo BOne COne per report styleDOne per report style + one more

单选题Your company has 1,000 Windows XP computers.  You plan to migrate these computers to Windows 7.   You need to detect compatibility issues that can occur during the installation and configuration process for a specific application.   Which tool should you use?()AInventory CollectorBSetup Analysis ToolCUpdate Compatibility EvaluatorDWindows Compatibility Evaluator

单选题You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?()A assign users to consumer groupsB set the resource plan for the instanceC configure a simple resource plan and specify plan directivesD configure a complex resource plan and specify plan directives

单选题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.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?()AYou should use the Database Engine Tuning Advisor. BIn Microsoft SQL Server Management Studio, you should create a maintenance plan CYou should use the SQL Server Configuration Manager DIn Microsoft SQL Server Management Studio, you should create a policy

单选题You 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. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?()AFor the SQL Server Agent, you should enable a fail-safe operator BYou should modify the database maintenance plan, making it send an e-mail to the appropriate operators CYou should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. DYou should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

单选题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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? ()AYou should backup the master databaseBYou should backup the default.trc fileCYou should backup the SQL Server registry hive.DYou should backup the resource database

单选题You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan?()Aassign users to consumer groupsBset the resource plan for the instanceCconfigure a simple resource plan and specify plan directivesDconfigure a complex resource plan and specify plan directives

单选题Your company’s network has client computers that run Windows 7.   A software vendor releases version 2 of an application that your company uses.  Your company currently uses version 1.  Version 1 and version 2 are not compatible. You plan to deploy version 2 of the application.   You have the following requirements:Users must be able to run both versions of the application on their computers.   Version 2 must be available when a client computer is not connected to the network.  You need to plan a software deployment process that meets the requirements.   What should you do?()A Deploy version 2 of the application by using Microsoft Application Virtualization (App-V). B Deploy version 2 of the application as a Remote Desktop Services RemoteApp.C Deploy version 2 of the application by using a Group Policy Software Installation policy.D Deploy version 2 of the application by using a Microsoft System Center Configuration Manager package.

多选题You have an Exchange organization named nwtraders.com.All servers in the organization have Exchange Server 2010 Service Pack 1 (SPl) installed.Your company acquires another company named Contoso, Ltd. You plan to create new mailboxes for each user from Contoso. You need to ensure that each new mailbox can receive e-mail messages sent to contoso.com.Which two objects should you create?()Aa Receive connectorBa Remote domainCan organizational relationshipDan accepted domainEan e-mail address policy