多选题TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those 

题目
多选题
TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）
A

Remove all deterministic function calls from within the view.

B

Remove all nondeterministic function calls from within the view.

C

Schema-bind all functions that are called from within the view.

D

Create the view and specify the WITH CHECK OPTION clause.

相似考题

1. You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.  Which two protocols can you use to achieve this goal？（）A、Named PipesB、TCP/IPC、Shared MemoryD、Virtual Interface Adapter （VIA）E、Multiprotocol

2. TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do？（）A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.B、Configure SQL2 as a remote server. Write the query on SQL1.C、Configure SQL2 as a linked server to impersonate the remote login.D、Configure SQL2 as a distributed server. Use pass-through authentication.

3. 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 as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster.  Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.

4. 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 as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.B、In a query execution plan， you should look for queries with missing or out-of-date statistics.C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.D、In a query execution plan， you should look for queries with a large number of table scans.

更多“TestKing.com uses SQL Server 2005. You are implementing a se”相关问题

  • 第1题：

    TestKing.com uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date.  You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use？（）

    • A、DBCC CHECKTABLE
    • B、ALTER INDEX REORGANIZE
    • C、UPDATE STATISTICS
    • D、CREATE STATISTICS
    • E、DBCC SHOW STATISTICS
    • F、DBCC UPDATEUSAGE

    正确答案:C,D

  • 第2题：

    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 as a database administrator for your company. More than a month ago， the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore， you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view （DMV）， you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition， the impact on database users should e cut to the least.  Which action should be performed to achieve the goal？（）

    • A、To achieve the goal， the UPDATE STATISTICS command should be excuted.
    • B、To achieve the goal， the SQL Server Service should be restarted.
    • C、To achieve the goal， the SQL Server computer should be restarted.
    • D、To achieve the goal， the statistics in the dynamic management view （DMV） should be reset.

    正确答案:D

  • 第3题：

    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

  • 第4题：

    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 as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options， which one is the most possible cause of the problem？（）

    • A、The sp_executesql batches are not being recovered from the procedure cache.
    • B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.
    • C、One new stored procedure is created by a database administrator.
    • D、Ad hoc batches are not being recovered from the procedure cache.

    正确答案:B

  • 第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. 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

  • 第6题：

    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

  • 第7题：

    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 as the database administrator for your company. You find a problem that there are three reports which are running slowly. And through detailed analysis， you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support， you are required to find out which statement is causing the slow performance. Which action should be performed first？（）

    • A、SQL Server Profiler should be run with the Lock：Deadlock event class.
    • B、The Database Engine Tuning Advisor （DTA） f should be run or at least one hour.
    • C、SQL Server Profiler should be run with the TSQL_Duration template.
    • D、The Database Engine Tuning Advisor （DTA） should be run with the default options.

    正确答案:C

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    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 as a database administrator for your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation.  From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）
    A

    To achieve the goal， DBCC DBREINDEX should be utilized.

    B

    To achieve the goal， SELECT * FROM sys.indexes should be utilized.

    C

    To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.

    D

    To achieve the goal， DBCC INDEXDEFRAG should be utilized.


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

  • 第10题：

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


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

  • 第11题：

    单选题
    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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （）
    A

    You should use Dynamic Management Views 

    B

    You should use SQL Server Resource Governor 

    C

    You should use SQL Server Profiler 

    D

    You should use Windows System Monitor


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

  • 第12题：

    多选题
    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）
    A

    In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.

    B

    In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.

    C

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.

    D

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.


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

  • 第13题：

    TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）

    • A、Remove all deterministic function calls from within the view.
    • B、Remove all nondeterministic function calls from within the view.
    • C、Schema-bind all functions that are called from within the view.
    • D、Create the view and specify the WITH CHECK OPTION clause.

    正确答案:B,C

  • 第14题：

    You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）

    • A、one that uses an internal SQL Server Web service endpoint
    • B、one that runs a SQL Server Integration Services （SSIS） package
    • C、one that uses Service Broker
    • D、one that runs a user-defined function

    正确答案:C

  • 第15题：

    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）

    • A、In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.
    • B、In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.
    • C、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.
    • D、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

    正确答案:A,C

  • 第16题：

    TestKing.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application.   You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do？（）

    • A、Trace the Lock：Timeout event by using SQL Server Profiler.
    • B、Observe the SQLServer：Locks - Number of Deadlocks/sec counter by using System Monitor.
    • C、Trace the Lock：Deadlock event by using SQL Server Profiler.
    • D、Trace the Lock：Deadlock Chain event by using SQL Server Profiler.

    正确答案:D

  • 第17题：

    Your company uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use?（）

    • A、 DBCC CHECKTABLE 
    • B、 ALTER INDEX REORGANIZE 
    • C、 UPDATE STATISTICS 
    • D、 CREATE STATISTICS 
    • E、 DBCC SHOW_STATISTICS 
    • F、 DBCC UPDATEUSAGE

    正确答案:C,D

  • 第18题：

    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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

    • A、You should use Dynamic Management Views 
    • B、You should use SQL Server Resource Governor 
    • C、You should use SQL Server Profiler 
    • D、You should use Windows System Monitor

    正确答案:A

  • 第19题：

    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

  • 第20题：

    多选题
    TestKing.com uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date.  You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use？（）
    A

    DBCC CHECKTABLE

    B

    ALTER INDEX REORGANIZE

    C

    UPDATE STATISTICS

    D

    CREATE STATISTICS

    E

    DBCC SHOW STATISTICS

    F

    DBCC UPDATEUSAGE


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

  • 第21题：

    多选题
    You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）
    A

    Named Pipes

    B

    TCP/IP

    C

    Shared Memory

    D

    Virtual Interface Adapter (VIA)

    E

    Multiprotocol


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    多选题
    Your company uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use?（）
    A

    DBCC CHECKTABLE

    B

    ALTER INDEX REORGANIZE

    C

    UPDATE STATISTICS

    D

    CREATE STATISTICS

    E

    DBCC SHOW_STATISTICS

    F

    DBCC UPDATEUSAGE


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

相关内容