单选题You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-

题目
单选题
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（）
A

Create the database by using a single data file and a single log file.

B

Create the database by using a single data file and multiple log files.

C

Create the database by using a single log file and multiple filegroups.

D

Create the database by using a single log file and a filegroup that has multiple data files.

相似考题

1. You administer a SQL Server 2008 instance. The instance is located on a four-processor, quad-core server. The server frequently experiences CPU pressure. The instance contains a very large mission-critical database that is used continuously. You need to ensure that online index rebuilds do not consume all available CPU cycles. Which configuration option should you use?（）A、affinity maskB、affinity I/O mask C、max degree of parallelismD、optimize for ad hoc workloads

2.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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? （） A、You should configure Distributed File SystemB、You should configure SQL ServerC、You should configure SQL Server Full TextD、You should configure SQL Server VSS Writer

3. 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.

4.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. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）  A、For the AdventureWorks database, enable Server Auditing B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance C、You should configure the data collector and make it capture the deadlock graphsD、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

更多“You administer a SQL Server 2008 instance. You plan to deplo”相关问题

  • 第1题：

    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

    • A、Create the database by using a single data file and a single log file.
    • B、Create the database by using a single data file and multiple log files.
    • C、Create the database by using a single log file and multiple filegroups.
    • D、Create the database by using a single log file and a filegroup that has multiple data files.

    正确答案:C

  • 第2题：

    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

    正确答案:B

  • 第3题：

    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? （） 

    • A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
    • B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
    • C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
    • D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

    正确答案:D

  • 第4题：

    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. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory.  Which SQL Server database engine subdirectory should be backed up？（）

    • A、DATA
    • B、INSTALL 
    • C、LOG 
    • D、BINN

    正确答案:C

  • 第5题：

    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

    正确答案:D

  • 第6题：

    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?（）

    • A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 
    • B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 
    • C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. 
    • D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

    正确答案:A

  • 第7题：

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


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    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?（）
    A

    You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 

    B

    You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 

    C

    You should upgrade the SQL Server 2005 application to use SQL Server 2008. 

    D

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal？（）
    A

    You should recapture the workload by using the data collector.

    B

    You should enable the XP_MSVER stored procedure on the local server.

    C

    You should enable the XP_MSVER stored procedure on the remote server

    D

    You should recapture the workload to a trace file by using SQL Profiler.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You administer a SQL Server 2008 Reporting Services (SSRS) instance. You plan to design an authentication method for SSRS reports that use SQL Server data connections. You need to ensure that all SSRS reports communicate to the SQL Server instance by using the Kerberos authentication protocol. What should you do?（）
    A

    Configure the default Web site on the instance to use the Integrated Security type.

    B

    Configure the application pool used by the default Web site to use a domain account. 

    C

    Configure the default Web site on the instance to use the Secure Sockets Layer (SSL) protocol.

    D

    Register a service principal name (SPN) in the Active Directory directory service for the SSRS instance.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?（）
    A

    For the AdventureWorks database, enable Server Auditing 

    B

    First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 

    C

    You should configure the data collector and make it capture the deadlock graphs

    D

    You should configure a SQL Profiler trace, and make it capture the deadlock graphs


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    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 configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （）
    A

    You should backup the master database

    B

    You should backup the default.trc file

    C

    You should backup the SQL Server registry hive.

    D

    You should backup the resource database 


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal？（）

    • A、You should recapture the workload by using the data collector.
    • B、You should enable the XP_MSVER stored procedure on the local server.
    • C、You should enable the XP_MSVER stored procedure on the remote server
    • D、You should recapture the workload to a trace file by using SQL Profiler.

    正确答案:D

  • 第14题：

    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 configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? （） 

    • A、You should backup the master database
    • B、You should backup the default.trc file
    • C、You should backup the SQL Server registry hive.
    • D、You should backup the resource database 

    正确答案:C

  • 第15题：

    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. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）

    • A、For the SQL Server Agent, you should enable a fail-safe operator 
    • B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
    • C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
    • D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

    正确答案:D

  • 第16题：

    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. 

    正确答案:B

  • 第17题：

    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

    正确答案:C

  • 第18题：

    单选题
    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 SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）
    A

    For the database, you should turn on the TRUSTWORTHY database option

    B

    For the database, the PAGE_VERIFY database option should be set to CHECKSUM

    C

    For the database, the database compatibility level option should be set to 10

    D

    For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION. 


    正确答案： A
    解析： 暂无解析

  • 第19题：

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


    正确答案： B
    解析： 暂无解析

  • 第20题：

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


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You administer a SQL Server 2008 instance. You plan to deploy a third-party database application to the instance. The application uses stored procedures that are developed by using SQL CLR integration. The application must be configured to enable the EXTERNAL_ACCESS code access security setting. You need to ensure that the application is deployed to the instance without loss of functionality. What should you do first?（）
    A

    Replace read write non-static fields in the code with static fields.

    B

    Replace read-only static fields in the code with read write static fields. 

    C

    Use the peverify.exe PEVerify tool to verify whether the code meets the type-safety requirements.

    D

    Use the regasm.exe assembly registration tool to register the assembly on the server before deployment.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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? （）
    A

    You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 

    B

    You should upgrade the SQL Server 2005 application to use SQL Server 2008 

    C

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 

    D

    You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    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. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）
    A

    For the SQL Server Agent, you should enable a fail-safe operator 

    B

    You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 

    C

    You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 

    D

    You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    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. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which performance object should you capture?（）
    A

    SQLServer:Buffer Manager 

    B

    SQLServer:Access Methods 

    C

    SQLServer:General Statistics 

    D

    SQLServer:Exec Statistics


    正确答案： C
    解析： 暂无解析

相关内容