你计划的部署SQL Azure数据库。你的公司有一个卷Microsoft SQL Server2008的许可协议。SQL Azure数据库必须保持每月99.9%的可用性。你需要推荐的方法减少每月的费用与SQL Azure数据库。该有关你推荐()
第1题:
你设计的策略同步SQL Azure数据库和多个远程Microsoft SQL Server 2008数据库。SQL Azure数据库包含许多表圆形的外键关系。你需要为确保推荐的方法吗所有的远程数据库的变化与SQL Azure数据库同步。什么你应该建议吗?()
第2题:
你计划的现有应用程序迁移到Windows Azure和SQL Azure。当前的应用程序包含报告由SQL Server的报告服务。您需要推荐一个方法迁移报告。你应该推荐()
第3题:
你正在设计一个计划对现有的Microsoft SQL Server 2008数据库迁移到SQL Azure数据库包含一个SQL服务器代理工作,清理应用程序日志表。您需要推荐一个方法确保SQL Server代理工作继续不加修改地运行。你推荐()
第4题:
A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend?()
第5题:
你正在设计一个web服务,它将在Windows Azure托管web服务会接受和存储结构化和半结构化数据,web服务必须满足吗以下需求: 在一个事务中更新所有数据。 执行结构化数据的数据结构中的数据存储。 您需要推荐一个方法来存储数据。你推荐什么?()
第6题:
公司A有一个名为SQL1的SQL Server 2005服务器。SQL1设置为SQL Server和Windows身份认证模式。使用Windows认证,在SQL1上你有sysadmin权限。使用SQL1工作的所有用户都反映说:使用SQL1的所有应用程序均停止响应。你的上司让你去调查此问题。在任务管理器中,你注意到CPU使用率为100%。你试图用SQL Server Management Studio连接到SQL1。但SQL1没有响应。你需要连接到SQL1才能诊断问题。哪两种方法可能让你达成此目标?()
第7题:
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? ()
第8题:
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?()
第9题:
公司一个新的员工需要访问名为SQL1服务器上的SQL SERVER 2005 数据库.你用CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’为其创建了登录名ajones。新员工报告说:当他在使用ajones登录的时候,收到如下的错误“用户‘ajones’登录失败。该用户与可信的SQL SERVER 连接无关联”。你需要解决这个问题并允许这个员工去登录SQL1。你应该怎么做?()
第10题:
Use the bcp utility.
Use the dta utility.
Use the SQL Server Import and Export Wizard.
Attach each SQL Server database to SQL Azure.
第11题:
Remove all clustered indexes from the database.
Remove all dependencies on the Microsoft Distributed Transaction Coordinator (MSDTC) from the application.
Use SSL and SQL authentication to connect to the database.
Use SSL and Windows authentication to connect to the database.
第12题:
Add a processor license to the existing SQL Server licensing agreement.
Purchase a Windows Azure consumption platform subscription.
Purchase a SQL Server Services Provider Licensing Agreement (SPLA).
Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.
第13题:
应用程序连接到一个应用程序SQL Azure数据库。偶尔也会失去连接到SQL Azure数据库。你需要给你推荐一个可靠的方法完成数据访问操作。你推荐什么?()
第14题:
你正在设计一个Windows Azure应用程序,应用程序将包括偶尔联系客户,参考数据存储在Windows Azure Blob存储客户端断开连接时可以添加数据。你需要推荐一个方法吗与Windows Azure Blob存储同步离线客户端数据。你应该推荐()
第15题:
要让管理SQL-Server数据库的Management-Studio或者访问数据库的应用程序正常工作,()必须处于启动状态。
第16题:
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? ()
第17题:
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?()
第18题:
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?()
第19题:
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?()
第20题:
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?()
第21题:
Use SQL Azure to host client report definitions.
Use SQL Azure to host server report definitions.
Use Windows Azure to host client report definitions in an ASP.NET webpage.
Use Windows Azure to host server report definitions in an ASP.NET webpage.
第22题:
Use SQLAzure Data Sync Service.
Use SQL Server replication.
Use SQL Server backup and restore.
Use SQL Server database snapshots.
第23题:
Use the SQL Server Profiler to capture all SQL activities.
Use a Dynamic Management View to analyze performance.
Use the Database Engine Tuning Advisor to analyze the workload.
Use Microsoft SQL Server Management Studio to analyze the SQL logs.