下列关于SQL Server 2008身份认证模式的说法，正确的是（）。A、只能在安装过程中设置身份认证模式，安装完成之后不能再修改B、只能在安装完成后设置身份认证模式，安装过程中不能设置C、在安装过程中可以设置身份认证模式，安装完成之后还可以再对其进行修改D、身份认证模式是系统规定好的，在安装过程中及安装完成后都不能进行修改
下列关于SQL Server 2008身份认证模式的说法，正确的是（）。
- A、只能在安装过程中设置身份认证模式，安装完成之后不能再修改
- B、只能在安装完成后设置身份认证模式，安装过程中不能设置
- C、在安装过程中可以设置身份认证模式，安装完成之后还可以再对其进行修改
- D、身份认证模式是系统规定好的，在安装过程中及安装完成后都不能进行修改
相关考题：
可以用做局域网的操作系统软件是(35)。A．SQL Server、Windows XPB．Unix、Windows Server 2008C．Windows XP、UnixD．SQL Server、Linux
下列哪个版本的SQL Server是完全由微软公司开发的第一个SQL Server版本( )。 A、SQL Server4.2B、SQL Server6.0C、SQL Server 7.0D、SQL Server 2000
在哪里可以查看SQL Server 2008中的当前日志()。 A.SQL Server Management Studio中的安全性——SQL Server日志B.SQL Server Management Studio中的数据库——SQL Server日志C.SQL Server Management Studio中的管理——SQL Server日志D.SQL Server Management Studio中的管理——维护计划
下列关于SQL Server 2008中guest用户的说法,错误的是( )。A.guest用户没有对应的登录账户名SX 下列关于SQL Server 2008中guest用户的说法，错误的是（ ）。A.guest用户没有对应的登录账户名B.通过授权语句可以启用数据库中的guest用户C.所有数据库用户都继承该数据库中guest用户的权限D.任何SQL Server登录账户都可以访问启用了9uest用户的数据库
下列关于SQL Server 2008身份验证模式的说法，错误的是（ ）。A.在“Windows身份验证模式”下，不允许sa登录到SQL Server服务器B.在“Windows身份验证模式”下，所有Windows用户都自动具有登录到SQL Server服务器的权限C.不管是哪种身份验证模式，Windows中的Administrator无需授权就可登录到SQL Server服务器D.安装好SQL Server之后，可以根据需要随时更改身份验证模式
下列属于SQL Server 2008最核心服务的是（）。A数据库引擎服务BSQL Server Management StudioCSQL Server配置管理器DSQL Server 管理工具
你正在设计一个计划迁移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。
在哪里可以查看SQL Server 2008中的当前日志（）。A、SQLServer Management Studio中的管理——SQL Server日志B、SQLServer Management Studio中的管理——维护计划C、SQLServer Management Studio中的安全性——SQL Server日志D、SQLServer Management Studio中的数据库——SQL Server日志
在哪里可以查看SQL Server 2008中的当前日志（）。A、SQL Server Management Studio中的安全性——SQLServer日志B、SQL Server Management Studio中的数据库——SQLServer日志C、SQL Server Management Studio中的管理——SQLServer日志D、SQL Server Management Studio中的管理——维护计划
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 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 need to recommend a Windows Server 2008 R2 server configuration that meets the following requirements： èSupports the installation of Microsoft SQL Server 2008 èProvides redundancy for SQL services if a single server fails What should you recommend？（） A、Install a Server Core installation of Windows Server 2008 R2 Enterprise on two servers. Configure the servers in a failover cluster.B、Install a full installation of Windows Server 2008 R2 Standard on two servers. Configure Network Load Balancing on the two servers.C、Install a full installation of Windows Server 2008 R2 Enterprise on two servers. Configure Network Load Balancing on the two servers.D、Install a full installation of Windows Server 2008 R2 Enterprise on two servers. Configure the servers in a failover cluster.
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 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. There is a database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. B、You should identify whether the SQL Server Agent is started on the primary server. C、You should identify whether the AdventureWorks database uses the Simple recovery model. D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
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 uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances. Which service should you start?（） A、Server B、SQL Server Agent C、SQL Server Browser D、SQL Active Directory Helper
单选题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. There is an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（）AYou should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured BYou should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured CYou should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured DYou should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA
单选题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 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?（）AYou should install SQL Server 2008 as a named instance, and make the new application to use the new instance. BYou should install SQL Server 2008 as the default instance, and make the new application to use the default instance. CYou should upgrade the SQL Server 2005 application to use SQL Server 2008. DYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
单选题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? （）AThe SQL Server 2008 Upgrade Advisor should be used BYou should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes CYou should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes DYou should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes.
单选题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? （）AYou should install SQL Server 2008 as the default instance, and configure the new application to use the default instance BYou should upgrade the SQL Server 2005 application to use SQL Server 2008 CYou should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance DYou should install SQL Server 2008 as a named instance, and make the new application use the new instance.
单选题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?（）AYou should use the Database Engine Tuning Advisor. BIn Microsoft SQL Server Management Studio, you should create a maintenance plan CYou should use the SQL Server Configuration Manager DIn Microsoft SQL Server Management Studio, you should create a policy
单选题下列属于SQL Server 2008最核心服务的是（）。A数据库引擎服务BSQL Server Management StudioCSQL Server配置管理器DSQL Server 管理工具