微软认证考试
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（） A、 Use a
题目
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）
- A、 Use a Dynamic Management View to check for locks.
- B、 Use a Dynamic Management View to check for blocked queries.
- C、 Use a Dynamic Management View to check for long-running queries.
- D、 Use a Dynamic Management View to check the size and maximum size of the database.
相似问题和答案
第1题：
你计划的现有应用程序迁移到Windows Azure和SQL Azure。当前的应用程序包含报告由SQL Server的报告服务。您需要推荐一个方法迁移报告。你应该推荐（）
- A、使用SQL Azure托管客户端报告定义。
- B、使用SQL Azure主机服务器报告定义。
- C、使用Windows Azure托管客户端报告定义在一个ASP.NET网页。
- D、使用Windows Azure主机服务器报告定义在一个ASP.NET网页。
正确答案:C
第2题：
在Windows Azure存储系统中，（）类型提供了结构化的存储。
- A、Windows Azure Blob
- B、Windows Azure Table
- C、Windows Azure Queue
- D、SQL数据服务
正确答案:B
第3题：
你正在设计一个计划迁移Microsoft SQL Server 2008数据库SQL Azure。你不计划来迁移SQL Server数据库SQL Server 2008 R2，你需要推荐一个方法执行批量数据传输从SQL Server数据库SQL Azure。你推荐什么？（）
- A、使用bcp工具。
- B、使用dta效用。
- C、使用SQL Server导入和导出向导。
- D、附上每个SQL Server数据库SQL Azure。
正确答案:A
第4题：
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
第5题：
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
第6题：
你正在设计一个计划对现有的Microsoft SQL Server 2008数据库迁移到SQL Azure数据库包含一个SQL服务器代理工作，清理应用程序日志表。您需要推荐一个方法确保SQL Server代理工作继续不加修改地运行。你推荐（）
- A、使用SQL Azure数据同步服务。
- B、在SQL Azure运行SQL Server代理。
- C、使用SQL Server集成服务（ssi）连接到SQL Azure。
- D、连接现有的本地SQL Server代理工作SQL Azure。
正确答案:D
第7题：
You are evaluating a Windows Azure application. The application includes the following elements： - A web role that provides the ASP.NET user interface and business logic - A single SQL Azure database that contains all application data Each page must receive data from the business logic layer before returning results to the client. Traffic has increased significantly. The business logic is causing high CPU usage. You need to recommend an approach for scaling the application. What should you recommend？（）
- A、 Move business logic to a worker role.
- B、 Vertically partition the SQL Azure database.
- C、 Store business logic results in Windows Azure local storage.
- D、 Store business logic resultsin Windows Azure Table storage
正确答案:A
第8题：
你设计的策略同步SQL Azure数据库和多个远程Microsoft SQL Server 2008数据库。SQL Azure数据库包含许多表圆形的外键关系。你需要为确保推荐的方法吗所有的远程数据库的变化与SQL Azure数据库同步。什么你应该建议吗？（）
- A、使用SQL Azure数据同步服务。
- B、使用SQL Server复制。
- C、使用SQL服务器备份和恢复。
- D、使用SQL Server数据库快照。
正确答案:A
第9题：
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
第10题：
An application connects to a SQL Azure database. The application occasionally loses the connection to the SQL Azure database. You need to recommend an approach for reliably completing data access operations. What should you recommend？（）
- A、 Use Microsoft ADO.NET connection pooling.
- B、 Pass exceptions to the user interface layer.
- C、 Implement a retry policy in the data access layer.
- D、 Begin a transaction before each data access operation.
正确答案:C