You are adatabase solutionsarchitect.Your company plansto develop asolution by using a SQLServer2008instance.The solutionhasthefollowingbusinessrequirements:ImportdatafromvariousdatasourcessuchasMicrosoftOfficeExcel,Microsoft SQL Server2000,MicrosoftSQLSe

题目

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?（）

相似考题

1.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.

2. 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

3. 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）

4. 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.

参考答案和解析
参考答案：C, E
更多“You are adatabase solutionsarchitect.Your company plan ”相关问题

  • 第1题：

    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 Manager
    • B、Microsoft System Center Operations Manager
    • C、Microsoft System Center Configuration Manager
    • D、Microsoft System Center Virtual Machine Manager

    正确答案:B

  • 第2题：

    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 database
    • B、You should backup the default.trc file
    • C、You should backup the SQL Server registry hive.
    • D、You should backup the resource database 

    正确答案:C

  • 第3题：

    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.

    正确答案:D

  • 第4题：

    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、DATA
    • B、INSTALL 
    • C、LOG 
    • D、BINN

    正确答案:C

  • 第5题：

    单选题
    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 licenses

    B

    300 Office Enterprise 2007 licenses and 300 App-V for Terminal Services licenses

    C

    300 Office Enterprise 2007 licenses and 300 Microsoft Desktop Optimization Pack （MDOP）licenses

    D

    300 Windows Server 2008 R2 RDS client access licenses （CALs）


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    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?（）
    A

    Two 

    B

    One 

    C

    One per report style

    D

    One per report style + one more


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    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 groups

    B

     set the resource plan for the instance

    C

     configure a simple resource plan and specify plan directives

    D

     configure a complex resource plan and specify plan directives


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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 groups

    B

    set the resource plan for the instance

    C

    configure a simple resource plan and specify plan directives

    D

    configure a complex resource plan and specify plan directives


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    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 connector

    B

    a Remote domain

    C

    an organizational relationship

    D

    an accepted domain

    E

    an e-mail address policy


    正确答案： C,E
    解析： 暂无解析

  • 第11题：

    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、2
    • B、3
    • C、4
    • D、6

    正确答案:C

  • 第12题：

    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 connector
    • B、a Remote domain
    • C、an organizational relationship
    • D、an accepted domain
    • E、an e-mail address policy

    正确答案:B,E

  • 第13题：

    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.

    正确答案:C

  • 第14题：

    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

    正确答案:D

  • 第15题：

    问答题
    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.

    正确答案： 【参考范文】
    Dear Richard,
    Further to our discussion of 6 May, I’m writing to present the scheduled programme during your visit to our company(12—15 May). I‘ll be waiting at the airport on Tuesday morning. If the airliner arrives on time, I’11 take you right to your hotel. Then you can have a rest and refresh yourself. As Mr. Cooper desires to see you before the meeting, you will have a private talk. After that we’ll travel to the company site for the meeting which according to the schedule will run form 15:30 to 17:00. Since that will be a busy day, I recommend a complete relaxation at a nearby entertainment centre. Wednesday’s meeting is due to start at 10:00a.m. A limousine has been arranged to collect you from the hotel at 9 : 40a.m. As the meeting will last for a whole day, we will have a working lunch. When work’s finished, you’11 have some free time at your disposal before attending a welcome banquet to be held at The Sheraton Hotel at 19: 00.
    We have enter your name for the Tennis Tournament (9:30 a.m on Thursday morning). Mr. Cooper will pick you up at the hotel at 9:00a.m. Then there is a cocktail party at 12:30 a.m, which some important local government officials will attend.
    A sedan will pick you up at your hotel at 9:50a.m on Friday morning to send you to the airport in time for your return flight at 11:50a.m. I’m looking forward to seeing you on the 12th. At the meanwhile, if you have any questions, please do not hesitate to contact me at 01082253922.
    Yours sincerely,
    Mary Young
    Personal Assistant to Mr. Cooper
    解析： 暂无解析

  • 第16题：

    单选题
    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？（）
    A

    Inventory Collector

    B

    Setup Analysis Tool

    C

    Update Compatibility Evaluator

    D

    Windows Compatibility Evaluator


    正确答案： C
    解析： 暂无解析

  • 第17题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第18题：

    单选题
    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 database

    B

    You should backup the default.trc file

    C

    You should backup the SQL Server registry hive.

    D

    You should backup the resource database 


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

相关内容