70-447 無料問題集「Microsoft UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005」
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 administrator of a SQL Server 2005 computer, and the computer is named SQL1. Two user databases are included by the SQL01. In addition, the publisher database should be included by the SQL1 for a transactional replication publication. A full backup is performed to all databases every night. And Transaction log backups are performed twice a day for both user databases. SQL1 is set so as to utilize SQL Server and Windows authentication. Client applications connect by using SQL Server login accounts. A complete failure is experienced by the disk subsystem on SQL01. The failed hardware should be replaced, Microsoft Windows Server 2003 should be reinstalled, and SQL Server 2005should be reinstalled. Since you are the database administrator, you are required to confirm that SQL1 is operating normally in a fastest possible way, and a least number of data losses are allowed.
After the solution is implemented, the user databases should be available to client applications once those databases are restored. Which action should be performed first to achieve the goal?
You work as the administrator of a SQL Server 2005 computer, and the computer is named SQL1. Two user databases are included by the SQL01. In addition, the publisher database should be included by the SQL1 for a transactional replication publication. A full backup is performed to all databases every night. And Transaction log backups are performed twice a day for both user databases. SQL1 is set so as to utilize SQL Server and Windows authentication. Client applications connect by using SQL Server login accounts. A complete failure is experienced by the disk subsystem on SQL01. The failed hardware should be replaced, Microsoft Windows Server 2003 should be reinstalled, and SQL Server 2005should be reinstalled. Since you are the database administrator, you are required to confirm that SQL1 is operating normally in a fastest possible way, and a least number of data losses are allowed.
After the solution is implemented, the user databases should be available to client applications once those databases are restored. Which action should be performed first to achieve the goal?
正解：A
解答を投票する
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 administer a SQL Server 2005 computer named SQL01. There is a database named DB01 in the company. SQL01 stores confidential customer information in DB01. According to the requirement of the company's written security policy, transmission of customer data between client computers and servers must always occur in a manner that supports authentication, non-repudiation, and encryption. Data access is not granted to client computers that do not support the company's written security policy. Now the company assigns a task to you. You should make sure that the Customers database conforms to the company's security policy. What action should you perform to make sure of this?
正解：B
解答を投票する
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 administrator of a SQL Server 2005 computer, and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy, strong passwords are mandated for all domain, local, and application accounts. The company utilizes a Group Policy object (GPO) to deploy the proper domain password policy. MSDOS-based or UNIX-based operating systems are run by many of the company's computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator, you are required to confirm that the Services database can be accessed by these computers.
And the company's written security policy should not be violated. Which action should be performed by you?
You work as the administrator of a SQL Server 2005 computer, and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy, strong passwords are mandated for all domain, local, and application accounts. The company utilizes a Group Policy object (GPO) to deploy the proper domain password policy. MSDOS-based or UNIX-based operating systems are run by many of the company's computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator, you are required to confirm that the Services database can be accessed by these computers.
And the company's written security policy should not be violated. Which action should be performed by you?
正解：C
解答を投票する
正解：
Company Overview
STE is a large express company. STE is an acronym for
Satisfied Transport and Express+-. Therefore, it aims to provide satisfied delivery service for America. This company coordinates package deliveries throughout America. It cooperates with multiple regional delivery companies to distribute packages of all sizes. The company resides in St Louis and its regional delivery partners reside in all parts of America.
Planned Changes
Specifications are being written for a new application to manage employee benefits for STE. This application will authenticate the users to SQL Server by using the Active Directory credentials of users. Some of the benefits data is sensitive and should be viewable only from the benefits management application. However, when users issue ad hoc queries against the benefits data by using Microsoft Access, they are permitted to view other, less sensitive benefits data.
In order to cut down expenditures, the company will consolidate the Promotions database and the Partners database onto a single SQL Server computer. Employees of the regional delivery companies use SQL Server-authenticated logins to access both of these databases. The Partners database is accessible to all users who have access to the Promotions database, but not all users of the Partners database are allowed to access the Promotions database. This SQL Server computer should have as few instances as possible while still meeting these requirements.
Problem Statements
Users report that in the Shipment Tracking application, browser makes slow response, which uses the Tracking database. A large number of global temporary tables are used by the Shipment Tracking application. According to the indication of application diagnostics, performance issues in the database server named SQL01 causes the delays. Results of running the Performance MMC snap-in (PerfMon) reveal high values for the following counters in the tempdb database on SQL01:
Log Flush Wait/sec
Log Growths
The main tables in the Orders database on a server named SQL05 frequently experience heavy data modification and heavy report generation at the same time, causing performance problems for the reports due to excessive blocking.
EXISTING DATA ENVIRONMENT
Database Servers
The table below shows the SQL Server computers that are running SQL Server 2005, are shown in the following table.
Weekly full database backups, nightly differential backups, and hourly log backups for all user databases are included in the existing operations schedule. System databases are backed up every night.
Databases
The Orders application uses a single SQL Server-authenticated login named OrdersApp to connect to SQL05.
The Orders database makes use of data encryption, event notification, DDL triggers, CLR stored procedures, and snapshot isolation. The database master key for the Orders database is encrypted using the service master key for SQL05.
At the time that the server starts, the size of tempdb on SQL01 is 50 MB. But it typically increases to about 1.5 GB, growing 50 MB at a time. At present this database currently has a single data file.
At present all historical customer data are hold by the CRM database from the seven latest completed fiscal years plus the current year to date.
EXISTING INFRASTRUCTURE
Network Infrastructure
STE has configured its WAN to allow browser-based extranet access for its regional delivery partners. The diagram below shows the network configuration.
Server Infrastructure
As shown in the following table, the listed protocols are enabled for inbound connections to the servers in the perimeter network.
BUSINESS REQUIREMENTS
General Requirements
Data that is held in the Tracking database must be accessible and can be updated to applications that are run by the regional delivery partners.
With the purpose of research, customer information must be kept in the CRM database for two years. With the purpose of auditing, the company has to keep monthly copies of CRM data for at least five years. This auditing requirement is the only reason the older data must be retained, this is because data older than two years will most likely never be needed. However, if the older data is ever needed, it must be made available, in its entirety, in a database other than CRM so that it can be examined separately from the current data.
Availability
SQL06 has storage area network (SAN) storage, and CRM is supported by SQL06. CRM is an important application that must be available with the least downtime. The ERP application is supported by SQL07. SQL07 must be available with the least downtime.
The company has identified the following availability requirements for SQL06 and SQL07.
Any failover from one SQL Server computer to another should happen automatically.
Each of the servers must be available at an IP address that is the same before and after a failover event.
Performance degradation for the other server cannot be caused by the failure of SQL06 or the failure of SQL07.
Before the initiation of the failover, special data copy operations or other special processing should not be required.
After a failover event, SQL Server Agent jobs must resume running, with no human intervention.
Recoverability
The company must design a process to restore a copy of the Orders database to another SQL Server instance at the end of each month. End-of-month accounting reports will be run by using this copy of the Orders database.
In order to simplify recovery operation, if any type of data loss occur CRM database, no more than five restore operations must be required.
TECHNICAL REQUIREMENTS
Security
According to the requirement of the written security policy of the company, credit card information that is stored in the Orders database should be viewable only within the Orders application.
In the ExtraNet and Partners databases, individual users must use SQL Server-authenticated logins to log in to SQL Server. Password expiration must be enforced on all accounts that can access these databases.
According to the requirement of the written security policy of the company, incoming connections to the perimeter network, and all connections from the regional delivery companies, are only allowed over HTTP and HTTPS.
Performance
For performance reasons, applications of the regional delivery companies must be able to use a local copy of the Tracking database to retrieve and update data. This local copy of Tracking database synchronizes back to the central Tracking database.
Interoperability
Some values in the Tracking database must be populated by reading the Windows registry on a Microsoft Windows Server 2003 application server named AppServer1, which resides in St Louis. In order to keep shipment tracking information up-to-date, these values must be populated once per hour.
STE is a large express company. STE is an acronym for
Satisfied Transport and Express+-. Therefore, it aims to provide satisfied delivery service for America. This company coordinates package deliveries throughout America. It cooperates with multiple regional delivery companies to distribute packages of all sizes. The company resides in St Louis and its regional delivery partners reside in all parts of America.
Planned Changes
Specifications are being written for a new application to manage employee benefits for STE. This application will authenticate the users to SQL Server by using the Active Directory credentials of users. Some of the benefits data is sensitive and should be viewable only from the benefits management application. However, when users issue ad hoc queries against the benefits data by using Microsoft Access, they are permitted to view other, less sensitive benefits data.
In order to cut down expenditures, the company will consolidate the Promotions database and the Partners database onto a single SQL Server computer. Employees of the regional delivery companies use SQL Server-authenticated logins to access both of these databases. The Partners database is accessible to all users who have access to the Promotions database, but not all users of the Partners database are allowed to access the Promotions database. This SQL Server computer should have as few instances as possible while still meeting these requirements.
Problem Statements
Users report that in the Shipment Tracking application, browser makes slow response, which uses the Tracking database. A large number of global temporary tables are used by the Shipment Tracking application. According to the indication of application diagnostics, performance issues in the database server named SQL01 causes the delays. Results of running the Performance MMC snap-in (PerfMon) reveal high values for the following counters in the tempdb database on SQL01:
Log Flush Wait/sec
Log Growths
The main tables in the Orders database on a server named SQL05 frequently experience heavy data modification and heavy report generation at the same time, causing performance problems for the reports due to excessive blocking.
EXISTING DATA ENVIRONMENT
Database Servers
The table below shows the SQL Server computers that are running SQL Server 2005, are shown in the following table.
Weekly full database backups, nightly differential backups, and hourly log backups for all user databases are included in the existing operations schedule. System databases are backed up every night.
Databases
The Orders application uses a single SQL Server-authenticated login named OrdersApp to connect to SQL05.
The Orders database makes use of data encryption, event notification, DDL triggers, CLR stored procedures, and snapshot isolation. The database master key for the Orders database is encrypted using the service master key for SQL05.
At the time that the server starts, the size of tempdb on SQL01 is 50 MB. But it typically increases to about 1.5 GB, growing 50 MB at a time. At present this database currently has a single data file.
At present all historical customer data are hold by the CRM database from the seven latest completed fiscal years plus the current year to date.
EXISTING INFRASTRUCTURE
Network Infrastructure
STE has configured its WAN to allow browser-based extranet access for its regional delivery partners. The diagram below shows the network configuration.
Server Infrastructure
As shown in the following table, the listed protocols are enabled for inbound connections to the servers in the perimeter network.
BUSINESS REQUIREMENTS
General Requirements
Data that is held in the Tracking database must be accessible and can be updated to applications that are run by the regional delivery partners.
With the purpose of research, customer information must be kept in the CRM database for two years. With the purpose of auditing, the company has to keep monthly copies of CRM data for at least five years. This auditing requirement is the only reason the older data must be retained, this is because data older than two years will most likely never be needed. However, if the older data is ever needed, it must be made available, in its entirety, in a database other than CRM so that it can be examined separately from the current data.
Availability
SQL06 has storage area network (SAN) storage, and CRM is supported by SQL06. CRM is an important application that must be available with the least downtime. The ERP application is supported by SQL07. SQL07 must be available with the least downtime.
The company has identified the following availability requirements for SQL06 and SQL07.
Any failover from one SQL Server computer to another should happen automatically.
Each of the servers must be available at an IP address that is the same before and after a failover event.
Performance degradation for the other server cannot be caused by the failure of SQL06 or the failure of SQL07.
Before the initiation of the failover, special data copy operations or other special processing should not be required.
After a failover event, SQL Server Agent jobs must resume running, with no human intervention.
Recoverability
The company must design a process to restore a copy of the Orders database to another SQL Server instance at the end of each month. End-of-month accounting reports will be run by using this copy of the Orders database.
In order to simplify recovery operation, if any type of data loss occur CRM database, no more than five restore operations must be required.
TECHNICAL REQUIREMENTS
Security
According to the requirement of the written security policy of the company, credit card information that is stored in the Orders database should be viewable only within the Orders application.
In the ExtraNet and Partners databases, individual users must use SQL Server-authenticated logins to log in to SQL Server. Password expiration must be enforced on all accounts that can access these databases.
According to the requirement of the written security policy of the company, incoming connections to the perimeter network, and all connections from the regional delivery companies, are only allowed over HTTP and HTTPS.
Performance
For performance reasons, applications of the regional delivery companies must be able to use a local copy of the Tracking database to retrieve and update data. This local copy of Tracking database synchronizes back to the central Tracking database.
Interoperability
Some values in the Tracking database must be populated by reading the Windows registry on a Microsoft Windows Server 2003 application server named AppServer1, which resides in St Louis. In order to keep shipment tracking information up-to-date, these values must be populated once per hour.
正解：
Company Overview
LuckStone Research is an international organization which is not aim to earn profit, and the organization specializes in offering research support to a lot of organizations all over the United States.
There is a single office for the company, and the single office is in St Louis.
Planned changes
A new SQL Server 2005 failover cluster will be implemented by the company. Each of the three databases will be deployed with one instance on the cluster. The three databases are presently on a mainframe computer. And they are respectively called Research, Parts, and Engineering. Mission-critical data will be held by the data. An N+1 configuration is offered by utilizing a four-node failover cluster. And the company will call the cluster SQLCLUST.
After migrating these databases to SQLCLUST, the company requests to add a new identity column to most table in all of the databases so as to have a surrogate primary key supported. At the time the databases turn to production, the company requests to reset the seed value for all identity columns.
In order to get access to the Parts, Engineering, Customer, and Bids databases, the new Web services-based applications will be implemented. And the users will utilize their Windows credentials to access these applications.
The company intends to consolidate current SQL Server computers to minimize the database administration expense. The quantity of SQL Server computers and SQL Server instances should be cut to the least.
A Bid_Archive database will be created by the company. And the company plans to remove some row instantly from the Bids database to Bis_Archive. The row should meet the following requirements. The information on completed bids should be included by the row. In addition, the completed bids should not result in a new or extended contract.
You need to make sure the users can have the information retrieved, and the Bid_Archive database should not be modified.
CURRENT DATA ENVIRONMENT
Databases
From the table listed below, you can see the eight databases which are researched presently by them.
The users read data in the Contractor database more regularly than modifying it.
A Completed column is contained by the Bid_Tracking table in the Bids database. The Completed column is set to 1 when the bid is not active no more. In addition, a Successful column is contained by the table. And when the bid results in a new or extended contract, the Successful column is set to 1.
Database Servers There are three current SQL Server 2005 computers in the company, and the comaputers run with default instances, and the following databases is included by the instances.
Database Client Computers
Microsoft Windows XP Professional is run by all database client computers. Client computers utilize different custom.NET Framework applications to get access to the databases.
EXISTING INFRASTRUCTURE
Active Directory Infrastructure
There is a single Active Directory domain on the LuckStone Research network. Windows user accounts are utilized by all users to get access to SQL Server.
BUSINESS REOUIREMENTS
General Requirements
Completed annual performance review forms will be stored in the HR database. And each review form is bigger than 9.000 characters. Multiple languages and alphabets should be handled by the column which holds the review form to assist the prospective future international improvement. In addition, the data should be available in a single column.
The present state of the data in the Accounting data base should be viewed by the accounting managers at the close of any day during a week. In addition, modification can be made by them if it is necessary. A single field will be updated more than once a day, but it probably will be updated on several days continuously.
Performance
All information should be migrated to a Customer_Archive database so as to have the performance on the Customer database enhanced. And the database will be accessible for running long reports which are presently leading to the contention problems. Network traffic between the Customer database and the distribution database should be cut to the least in the management intention. What's more, the Customer_Archive database will be utilized as an added layer of fault tolerance. Management would like to utilize current servers, though additional servers are accessible.
Availability
In the event of the failure of a single hard disk, the Customer database should not fail. Hotswappable drives should be supported by the solution. And additional hardware can be utilized to support the solution.
Recoverability
A large number of modifications are received by the customer database every day in the business hours from 09:00 to 17:00. Most of the modifications happened in the afternoon. And they seldom receive modification when it is not business hours. One hour of data loss is permitted by the business requirements. The company will not permit more than six backups for any recovery. After testing on the performance of various backup scenarios, the company concluded that in business hours, the full database backups should not be performed, while the differential backups should be performed merely once in business time.
TECHNICAL REQUIREMENTS
Security
The Accounting and HR databases administrators are members of a domain global group, and the group is called SQL1_DBA. And their job is to manage all databases and SQL Server configurations on SQL01.
Some of the users are members of the DBAdmins global group, and their job is to manage the SQL Server instances on SQL02 and SQL03.
The physical computers and the Windows operating system are managed by the central IT department, and the SQL Server computers are on the Windows operating system. The Windows administrative privileges are not given to members of the DBAdmins.
Merely the least permissions should be given to all employee user accounts. And the permission is necessary and sufficient to perform their work.
According to the company's written security policy, delegation should be utilized when users of one database request to get access to another database on a separate SQL Server computer or SQL Server instance.
Except in the absolutely essential conditions, the company doesn't want to have the services installed.
At present, read access to each table in the HR database is required by all employees in the human resources (HR) department. In addition, the hiring managers should be enabled so as to have the data in five tables in the HR database read, added, deleted, and modified. Additional tables will be added by the company, and the read access to table is only permitted to a few employees. What's more, the read access to one table will be required by the future employees.
A new custom application is deployed by the company so as to have the duplication administrated by the new Customer_Archive database. Common language runtime (HR) integration and CLR stored procedures in the Customer database will be utilized by the company so as to offer limited and controlled access to the shares and files on SQL2.
Dbo should be made as the owner of all the assemblies which are created.
Maintainability
The company intends to have SQL Server Agent schedules on all servers for sustenance. And the company will utilize Database Mail to send alert. And the users will not utilize Net send to send messages. SQL Server computer will make a small number of Windows shares accessible for duplication and management.
Interoperability
The company requests to have all namespaces that are utilized for Web services applications reserved. Therefore, when the SQL Server service is not running, the same name cannot be reserved by another program on the computer.
LuckStone Research is an international organization which is not aim to earn profit, and the organization specializes in offering research support to a lot of organizations all over the United States.
There is a single office for the company, and the single office is in St Louis.
Planned changes
A new SQL Server 2005 failover cluster will be implemented by the company. Each of the three databases will be deployed with one instance on the cluster. The three databases are presently on a mainframe computer. And they are respectively called Research, Parts, and Engineering. Mission-critical data will be held by the data. An N+1 configuration is offered by utilizing a four-node failover cluster. And the company will call the cluster SQLCLUST.
After migrating these databases to SQLCLUST, the company requests to add a new identity column to most table in all of the databases so as to have a surrogate primary key supported. At the time the databases turn to production, the company requests to reset the seed value for all identity columns.
In order to get access to the Parts, Engineering, Customer, and Bids databases, the new Web services-based applications will be implemented. And the users will utilize their Windows credentials to access these applications.
The company intends to consolidate current SQL Server computers to minimize the database administration expense. The quantity of SQL Server computers and SQL Server instances should be cut to the least.
A Bid_Archive database will be created by the company. And the company plans to remove some row instantly from the Bids database to Bis_Archive. The row should meet the following requirements. The information on completed bids should be included by the row. In addition, the completed bids should not result in a new or extended contract.
You need to make sure the users can have the information retrieved, and the Bid_Archive database should not be modified.
CURRENT DATA ENVIRONMENT
Databases
From the table listed below, you can see the eight databases which are researched presently by them.
The users read data in the Contractor database more regularly than modifying it.
A Completed column is contained by the Bid_Tracking table in the Bids database. The Completed column is set to 1 when the bid is not active no more. In addition, a Successful column is contained by the table. And when the bid results in a new or extended contract, the Successful column is set to 1.
Database Servers There are three current SQL Server 2005 computers in the company, and the comaputers run with default instances, and the following databases is included by the instances.
Database Client Computers
Microsoft Windows XP Professional is run by all database client computers. Client computers utilize different custom.NET Framework applications to get access to the databases.
EXISTING INFRASTRUCTURE
Active Directory Infrastructure
There is a single Active Directory domain on the LuckStone Research network. Windows user accounts are utilized by all users to get access to SQL Server.
BUSINESS REOUIREMENTS
General Requirements
Completed annual performance review forms will be stored in the HR database. And each review form is bigger than 9.000 characters. Multiple languages and alphabets should be handled by the column which holds the review form to assist the prospective future international improvement. In addition, the data should be available in a single column.
The present state of the data in the Accounting data base should be viewed by the accounting managers at the close of any day during a week. In addition, modification can be made by them if it is necessary. A single field will be updated more than once a day, but it probably will be updated on several days continuously.
Performance
All information should be migrated to a Customer_Archive database so as to have the performance on the Customer database enhanced. And the database will be accessible for running long reports which are presently leading to the contention problems. Network traffic between the Customer database and the distribution database should be cut to the least in the management intention. What's more, the Customer_Archive database will be utilized as an added layer of fault tolerance. Management would like to utilize current servers, though additional servers are accessible.
Availability
In the event of the failure of a single hard disk, the Customer database should not fail. Hotswappable drives should be supported by the solution. And additional hardware can be utilized to support the solution.
Recoverability
A large number of modifications are received by the customer database every day in the business hours from 09:00 to 17:00. Most of the modifications happened in the afternoon. And they seldom receive modification when it is not business hours. One hour of data loss is permitted by the business requirements. The company will not permit more than six backups for any recovery. After testing on the performance of various backup scenarios, the company concluded that in business hours, the full database backups should not be performed, while the differential backups should be performed merely once in business time.
TECHNICAL REQUIREMENTS
Security
The Accounting and HR databases administrators are members of a domain global group, and the group is called SQL1_DBA. And their job is to manage all databases and SQL Server configurations on SQL01.
Some of the users are members of the DBAdmins global group, and their job is to manage the SQL Server instances on SQL02 and SQL03.
The physical computers and the Windows operating system are managed by the central IT department, and the SQL Server computers are on the Windows operating system. The Windows administrative privileges are not given to members of the DBAdmins.
Merely the least permissions should be given to all employee user accounts. And the permission is necessary and sufficient to perform their work.
According to the company's written security policy, delegation should be utilized when users of one database request to get access to another database on a separate SQL Server computer or SQL Server instance.
Except in the absolutely essential conditions, the company doesn't want to have the services installed.
At present, read access to each table in the HR database is required by all employees in the human resources (HR) department. In addition, the hiring managers should be enabled so as to have the data in five tables in the HR database read, added, deleted, and modified. Additional tables will be added by the company, and the read access to table is only permitted to a few employees. What's more, the read access to one table will be required by the future employees.
A new custom application is deployed by the company so as to have the duplication administrated by the new Customer_Archive database. Common language runtime (HR) integration and CLR stored procedures in the Customer database will be utilized by the company so as to offer limited and controlled access to the shares and files on SQL2.
Dbo should be made as the owner of all the assemblies which are created.
Maintainability
The company intends to have SQL Server Agent schedules on all servers for sustenance. And the company will utilize Database Mail to send alert. And the users will not utilize Net send to send messages. SQL Server computer will make a small number of Windows shares accessible for duplication and management.
Interoperability
The company requests to have all namespaces that are utilized for Web services applications reserved. Therefore, when the SQL Server service is not running, the same name cannot be reserved by another program on the computer.
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?
正解：D
解答を投票する
Since you are the technical support, you are asked to improve the performance for the following query in the internet_rentals database. SELECT videotitle, upc_no, retailprice
FROM srvideo.videotitle WHERE releasedate BETWEEN '05-01-2005' AND '05-30-2005'
The code segment below shows the scripts that were originally used to create the existing table and indexes that are used in the query.
create table srvideo.videotitle (videoid int IDENTITY(1,1) primary key nonclustered videotitle nvarchar(100) not null , description nvarchar(255) null , videolanguage nvarchar(50) null , releasedate datetime null , isbn nvarchar(25) , upc_no nvarchar(25) , format nvarchar(25) , cost money , retailprice money) go create clustered index cl_videotitle on srvideo.videotitle (videotitle);
You must not diminish the performance on other SELECT queries that are performed on a regular basis. What action should you perform?
FROM srvideo.videotitle WHERE releasedate BETWEEN '05-01-2005' AND '05-30-2005'
The code segment below shows the scripts that were originally used to create the existing table and indexes that are used in the query.
create table srvideo.videotitle (videoid int IDENTITY(1,1) primary key nonclustered videotitle nvarchar(100) not null , description nvarchar(255) null , videolanguage nvarchar(50) null , releasedate datetime null , isbn nvarchar(25) , upc_no nvarchar(25) , format nvarchar(25) , cost money , retailprice money) go create clustered index cl_videotitle on srvideo.videotitle (videotitle);
You must not diminish the performance on other SELECT queries that are performed on a regular basis. What action should you perform?
正解：B
解答を投票する
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 receive report from users saying that a SQL Server 2005 application makes no response for several seconds at a time during the day. This problem happens at random throughout the day and many users are affected at once. You check at the time that the problem happens. You find that both CPU utilization and disk utilization on the SQL Server 2005 computer are low, but that the network is operating normally. Therefore, you have to examine additional information that is related to the problem. What action should you perform?
正解：E
解答を投票する