网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “多选题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？（）AImplement transactions for database queries.BClose database connections in the application.CUse Microsoft ADO.NET in the data access layer.DImplement a retry policy in the data access layer.” 相关考题
考题
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.
考题
You need to recommend an automated deployment solution for the new servers in the finance department. What should you include in the recommendation？（）A、Microsoft Hyper-V Server 2008 R2B、Microsoft System Center Virtual Machine Manager （VMM）C、Windows Deployment Services （WDS）D、Windows Server Migration Tools
考题
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
考题
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.
考题
You manage a SQL Server 2005 computer that was installed using default settings. After a power failure， the SQL Server （MSSQLSERVER） service on your database server does not start. You need to find out the cause of the problem. Which three actions should you perform？（）A、In Event Viewer， view the system log.B、In Event Viewer， view the application log.C、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog.1 file.D、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/ErrorLog file.E、In Notepad， view the C:///Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/LOG/SQLAgent.out file.
考题
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）A、Ensure that the source database is Microsoft SQL Server.B、Ensure that the destination database is Microsoft SQL Server.C、Ensure that the column names in the source table match the column names in the destination table.D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.
考题
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.
考题
You are adatabase solutions architect.Your company plans to develop asolution by using a SQLServer 2008 instance. The solutionhas the following business requirements: Import datafromvarious datasources suchas MicrosoftOffice Excel, Microsoft SQL Server2000, Microsoft SQL Server 2005, and CSV files. Profile the source data before it is imported. Provide collaboration andoffline capabilities to mobile users. Allowmobile users to use heterogeneous data stores. You need to configure the appropriate SQL Server components to accomplish the business requirements. You want to achieve this goal by using the minimum amount of administrative effort. Which two SQL Server components should you use?（）A、Analysis ServicesB、Reporting ServicesC、Integration ServicesD、Notification ServicesE、Microsoft Sync Framework
考题
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.
考题
You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）A、a domain user accountB、a local user accountC、the NETWORK SERVICE accountD、the LOCAL SYSTEM account
考题
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.
考题
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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? （） A、You should use the Database Engine Tuning Advisor tool B、You should use the Windows System Monitor tool C、You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D、You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
考题
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.
考题
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.
考题
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
考题
You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）A、Internet Information ServicesB、SQL Server BrowserC、SQL Server AgentD、Microsoft Distributed Transaction Coordinator
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
单选题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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）A
The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.B
The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.C
The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.D
The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.
考题
单选题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.
考题
单选题Your company has a Microsoft Hyper-V Server 2008 R2 environment. You manage the environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You attempt to migrate child partitions through a firewall by using network migration. The migration fails. You need to ensure that you can successfully complete the migration. Which firewall port should you open？（）A
80B
135C
445D
8554
考题
单选题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. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? （）A
You should use the Database Engine Tuning Advisor tool B
You should use the Windows System Monitor tool C
You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D
You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
考题
单选题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
考题
单选题Your virtual environment includes Microsoft Virtual Server 2005 R2 and third-party hypervisors. The virtual machines （VMs） include messaging， application， and database servers. You intend to standardize on Windows Server 2008 R2 Hyper-V servers. You are developing a migration plan by using the Microsoft Assessment and Planning （MAP） Toolkit. You need to gather the necessary information to analyze the current virtual environment. Which MAP assessment should you choose？（）A
Windows Server Role DiscoveryB
Application Virtualization AssessmentC
Virtual Machine InventoryD
Windows Server 2008 R2 Readiness
考题
多选题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？（）ARemove all clustered indexes from the database.BRemove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.CUse SSL and SQL authentication to connect to the database.DUse SSL and Windows authentication to connect to the database.
考题
单选题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.
热门标签
最新试卷