单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server 

题目
单选题
You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend？（）
A

 Use the bcp utility.

B

 Use the dta utility.

C

 Use the SQL Server Import and Export Wizard.

D

 Attach each SQL Server database to SQL Azure.

相似考题

1.You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.You cancel the SQL Server upgrade wizard.You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

2.You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）A、Microsoft SQL Server 2005 Mobile EditionB、Microsoft SQL Server 2005 Express EditionC、Microsoft SQL Server 2005 Standard EditionD、Microsoft SQL Server 2005 Workgroup Edition

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. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line.  In the options below， which utility should you choose to use？（）A、bcp.exe B、dta.exe C、dtexec.exe D、sqlmaint.exe

4.You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

更多“单选题You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server ”相关问题

  • 第1题：

    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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do？ （）

    • A、The SQL Server 2008 Upgrade Advisor should be used. 
    • B、The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 
    • C、A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 
    • D、A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.

    正确答案:C

  • 第2题：

    You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）

    • A、one SQL Server 2005 computer with one instance
    • B、two SQL Server 2005 computers， each with two instances
    • C、two SQL Server computers， one with one instance and one with three instances
    • D、one SQL Server 2005 computer with two instances

    正确答案:D

  • 第3题：

    You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table.   You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification.  What should you recommend？（）

    • A、 Use the SQL Azure Data Sync service.
    • B、 Run the SQL Server Agent in SQL Azure.
    • C、 Use SQL Server Integration Services （SSIS） to connect to SQL Azure.
    • D、 Connect the existing on-premise SQL Server Agent jobs to SQL Azure.

    正确答案:D

  • 第4题：

    You are planning the migration of an existing application to Windows Azure and SQL Azure.  The original application includes a Microsoft SQL Server 2008 database.   You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure.  Which two actions should you recommend？（）

    • A、 Remove all clustered indexes from the database.
    • B、 Remove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.
    • C、 Use SSL and SQL authentication to connect to the database.
    • D、 Use SSL and Windows authentication to connect to the database.

    正确答案:B,C

  • 第5题：

    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

  • 第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 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

  • 第7题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）

    • A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 
    • B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 
    • C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. 
    • D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

    正确答案:A

  • 第8题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）
    A

    You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 

    B

    You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 

    C

    You should upgrade the SQL Server 2005 application to use SQL Server 2008. 

    D

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 


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

  • 第9题：

    单选题
    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. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （）
    A

    The SQL Server 2008 Upgrade Advisor should be used 

    B

    You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes 

    C

    You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes 

    D

    You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes. 


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

  • 第10题：

    单选题
    You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）
    A

    Install a separate instance of SQL Server 2005 for each of the databases on a single server.

    B

    Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.

    C

    Import the data from each of the databases into a single database in an instance of SQL Server 2005.

    D

    Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.


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

  • 第11题：

    单选题
    You are planning the deployment of a SQL Azure database.  Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%.   You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database.  What should you recommend？（）
    A

     Add a processor license to the existing SQL Server licensing agreement.

    B

     Purchase a Windows Azure consumption platform subscription.

    C

     Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.

    D

     Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.


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

  • 第12题：

    单选题
    You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）
    A

    one SQL Server 2005 computer with one instance

    B

    two SQL Server 2005 computers， each with two instances

    C

    two SQL Server computers， one with one instance and one with three instances

    D

    one SQL Server 2005 computer with two instances


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

  • 第13题：

    You are planning the deployment of a SQL Azure database.  Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%.   You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database.  What should you recommend？（）

    • A、 Add a processor license to the existing SQL Server licensing agreement.
    • B、 Purchase a Windows Azure consumption platform subscription.
    • C、 Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.
    • D、 Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.

    正确答案:B

  • 第14题：

    You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend？（）

    • A、 Use the bcp utility.
    • B、 Use the dta utility.
    • C、 Use the SQL Server Import and Export Wizard.
    • D、 Attach each SQL Server database to SQL Azure.

    正确答案:A

  • 第15题：

    You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases.  The SQL Azure database contains many tables that have circular foreign key relationships.  You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database.  What should you recommend？（）

    • A、 Use SQLAzure Data Sync Service.
    • B、 Use SQL Server replication.
    • C、 Use SQL Server backup and restore.
    • D、 Use SQL Server database snapshots.

    正确答案:A

  • 第16题：

    ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） 

    • A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
    • B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
    • C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
    • D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

    正确答案:D

  • 第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. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （） 

    • A、The SQL Server 2008 Upgrade Advisor should be used 
    • B、You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes 
    • C、You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes 
    • D、You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes. 

    正确答案:B

  • 第18题：

    You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure.   You need to recommend an approach for ensuring that database connectivity does not degrade.   Which two actions should you recommend？（）

    • A、 Implement transactions for database queries.
    • B、 Close database connections in the application.
    • C、 Use Microsoft ADO.NET in the data access layer.
    • D、 Implement a retry policy in the data access layer.

    正确答案:B,D

  • 第19题：

    单选题
    You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases.  The SQL Azure database contains many tables that have circular foreign key relationships.  You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database.  What should you recommend？（）
    A

     Use SQLAzure Data Sync Service.

    B

     Use SQL Server replication.

    C

     Use SQL Server backup and restore.

    D

     Use SQL Server database snapshots.


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

  • 第20题：

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


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

  • 第21题：

    单选题
    You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table.   You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification.  What should you recommend？（）
    A

     Use the SQL Azure Data Sync service.

    B

     Run the SQL Server Agent in SQL Azure.

    C

     Use SQL Server Integration Services （SSIS） to connect to SQL Azure.

    D

     Connect the existing on-premise SQL Server Agent jobs to SQL Azure.


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

  • 第22题：

    单选题
    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. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line.  In the options below， which utility should you choose to use？（）
    A

    bcp.exe 

    B

    dta.exe 

    C

    dtexec.exe 

    D

    sqlmaint.exe


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

  • 第23题：

    单选题
    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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do？ （）
    A

    The SQL Server 2008 Upgrade Advisor should be used. 

    B

    The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 

    C

    A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 

    D

    A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.


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

相关内容