You are designing a strategy for synchronizing a SQL Azure d

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are designing a Windows Azure application.   The application will include services hosted in different geographic locations.  The service locations may change.   You must minimize the cost of communication between services.  You need to recommend an approach for calling the services.  What should you recommend?()

  • A、 Use the Service Management API.
  • B、 Use Windows Azure Table storage.
  • C、 Use Windows Azure Queue storage.
  • D、 Use the Windows Azure AppFabric Service Bus.

正确答案:D

第2题:

You are designing a strategy for synchronizing two geographically disparate SQL Azure databases.  A database named DB1 is located in North America. A database named DB2 is located in Asia.  DB2 contains a subset of the tables in DB1.  You need to recommend an approach for bidirectionally synchronizing the databases each day.  What should you recommend?()

  • A、 Use SQL Azure Data Sync.
  • B、 Use custom Microsoft Sync Framework metadata.
  • C、 Use a Microsoft Sync Framework Partial Participant.
  • D、 Use a Microsoft Sync Framework file synchronization provider.

正确答案:A

第3题:

You are planning the migration of an existing application to Windows Azure and SQL Azure. The current application includes reports that are hosted by SQL Server Reporting Services.  You need to recommend an approach for migrating the reports.  What should you recommend? ()

  • A、 Use SQL Azure to host client report definitions.
  • B、 Use SQL Azure to host server report definitions.
  • C、 Use Windows Azure to host client report definitions in an ASP.NET webpage.
  • D、 Use Windows Azure to host server report definitions in an ASP.NET webpage.

正确答案:C

第4题:

You are designing a web service that will be hosted in Windows Azure.  The web service will accept and store structured and semi-structured data. The web service must meet the following requirements:   - Update all data within a single transaction.  - Enforce the data structure for structured data within the data store.    You need to recommend an approach for storing the data.  What should you recommend?()

  • A、 Use Windows Azure Queues.
  • B、 Use a single SQL Azure database.
  • C、 Use a single Windows Azure Drive.
  • D、 Use Windows Azure Table storage.

正确答案:B

第5题:

Multiple Windows Azure applications connect to multiple SQL Azure servers.  On-premise users connect to the SQL Azure servers for a variety of purposes.   You successfully deploy a new Windows Azure application with its own SQL Azure server.  When on- premise users attempt to connect to the new SQL Azure server they receive connection errors.   You need to recommend an approach for mitigating the connectivity issue.  What should you recommend? ()

  • A、 Open port 1433 on the network firewall.
  • B、 Use Security Support Provider Interface (SSPI).
  • C、 Disable the validation of the SSL certificate for the SQL Azure server through theconnection string.
  • D、 Change the firewall rules of the new SQL Azure server to allow access by computers on the internalnetwork.

正确答案:D

第6题:

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

第7题:

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

第8题:

You are designing a Windows Azure application that will store data. You have the following requirements:   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend?()

  • A、 Use Windows Azure Queues.
  • B、 Use Windows Live Mesh 2011.
  • C、 Use a single SQL Azure database.
  • D、 Use Windows Azure Table storage

正确答案:D

第9题:

You are designing a Windows Azure application that will use a worker role. The worker role will create temporary files.  You need to recommend an approach for creating the temporary files that minimizes storage transactions.  What should you recommend?()

  • A、 Create the files on a Windows Azure Drive.
  • B、 Create the files in Windows Azure local storage.
  • C、 Create the files in Windows Azure Storage page blobs.
  • D、 Create the files in Windows Azure Storage block blobs.

正确答案:B

第10题:

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

更多相关问题