Microsoft UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 - 070-447무료 덤프문제 풀어보기
According to the company requirements, the interim disk availability solution should be designed for SQL1. Windows RAID functionality will be utilized. A most proper RAID configuration should be identified to meet the availability requirements. From the following four RAID configurations, which one should be utilized?
정답: 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 work as the database administrator for your company. Developers need access to create, alter, and drop tables in your SQL Server 2005 database. There is a table named Valid_Production_Tables in the database. This table maintains a list of production tables. There are users who attempt to use commands to drop or alter current production tables. You must be able to automatically roll back any commands. When you try to achieve this, you must reduce the processor resources being used to the least. So what action should you perform?
정답: 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. Three instances of SQL Server are run by SQL01. Your company's disaster recovery plan of the company contains the ability to connect to the dedicated administrative connection on each instance of SQL Server. While testing this ability, you find that you are able to connect to the dedicated administrative connection on SQL1s default instance. But you fail to connect to the dedicated administrative connection on the two other instances on SQL01. You are sure that the instances are running and can be accessed by client applications. Besides, you also confirm that the dedicated administrative connection is enabled for all instances. You are sure that no other administrators are trying to connect to any dedicated administrative connections on SQL01.
You must make sure that you can connect to the dedicated administrative connection on all three instances. What action should you perform to make sure of this?
You administer a SQL Server 2005 computer named SQL01. Three instances of SQL Server are run by SQL01. Your company's disaster recovery plan of the company contains the ability to connect to the dedicated administrative connection on each instance of SQL Server. While testing this ability, you find that you are able to connect to the dedicated administrative connection on SQL1s default instance. But you fail to connect to the dedicated administrative connection on the two other instances on SQL01. You are sure that the instances are running and can be accessed by client applications. Besides, you also confirm that the dedicated administrative connection is enabled for all instances. You are sure that no other administrators are trying to connect to any dedicated administrative connections on SQL01.
You must make sure that you can connect to the dedicated administrative connection on all three instances. What action should you perform to make sure of this?
정답: C
정답:
Company Overview
GoldenGenius is an international corporation which specializes in technical content development. And the major business of the company is to create documentation and training materials for different software vendors.
At present, there are 30 full-time employees working in its head office in Portland. And more than 100 external contract writers are employed by the company, and the writers are working in home in different locations all over the world.
Planned Changes
A new and web-based solution will be implemented by the company so as to simplify the submitting work process for remote contract writers.
At present, the remote contract writers submit the work by e-mail as Microsoft Word document attachments, and the file shares on the file server called FP2 stores the work. After implementing the new solution, the remote contract writers will be permitted to have their work submitted to a Web service in WordML format, and then the work will be stored in an xml column in a new database called goldengenius_projects.
The Web service should be hosted on a current Web server in the perimeter network, and the Web service will be impersonated to gain access to the database server.
You can see the design for the new application solution from the diagram listed below.
Problem Statements
A review of the company's present security policies is required by the management. And the security should be enhanced to the maximum level so as to prevent the company data form unauthorized access or inadvertent deletion.
CURRENT DATA ENVIRONMENT
Databases
At present, there is a single SQL Server 2005 database named goldengenius_biz in GoldenGenius, Inc. and the database is utilized to store the company's financial and personnel data.
Dbo has all objects in the goldengenius_biz database.
Database Servers
There are two database servers in the Portland office. They are a primary server and a warm standby server which is respectively named SQL1 and SQL2. SQL1 is utilized to store the glodengenius_biz database, while SQL2 is utilized to utilize log shipping to replicate the goldengenius_biz database.
When a server fails, the goldengenius_biz database on SQL2 should be able to be brought online manually, and the client application should be simply set to have the standby server utilized.
The hardware on both servers greatly surpasses the existing requests for database performance.
Database Client Computers The goldengenius_biz is available to a managed client/server application, and ADO.NET
2.0 is utilized to access the database server.
CURRENT INFRASTRUCTURE Network Infrastructure From the diagram listed below, you can see there are two subnets in the network.
From the table listed below, you can see the detailed description of the servers included by the network.
Directory Services Infrastructure
There is a single Active Directory named goldengenius.com in the company network.
You can see the relating organizational units(OUS), user accounts, and global groups in the domain from the diagram listed below.
The company defines the accounts for contract writers in the ContractAccts OU, and defines other user accounts in the Users container.
BUSINESS REQUIREMENTS
General Requirements
All existing projects and archived content from previously finished projects should be included by the new goldengenius_projects database. Multiple revisions of a document can be submitted by writers. And when the project is active, all types of the documents should be sustained. When a project is finished, the final version should be handed off to the customer.
The data in archived projects is available to writers and project managers so as to retrieve replications of documents that have already been handed off to customers.
Availability
The company regards the existing availability strategy for the goldengenius_biz database as sufficient, and the strategy should not be modified. However, a level of availability should be provided by the goldengenius_biz database so as to make sure the database will be completely available in the shortest time when a server or a storage array fails. Besides that, the company request to have the risk of the data loss cut to the least.
The company will not allow any new hardware purchase to implement the availability solution. Nevertheless, the presently server which is utilized to store project documents is named FP2. When the new application is implemented, FP2 will be decommissioned. And if it is necessary, the FP2 can be utilized.
The company has to insert a great number of data into the goldengenius_biz database incidentally through a custom load operation, and the custom load operation requests to place the database in single user mode. And during the operation process, the users should be enabled to retrieve project data with no failover to the warm standby server which is utilized for log shipping.
Recoverability
A combination of full, partial, and transaction log backups will be utilized to back up all system and user databases. Since you are the technical support, you are required to create a recovery plan to specify the steps which are essential to utilize the backups when recover from a server failure.
In the event of the corruption or destruction on the goldengenius_project database, the recovery strategy should be optimized so as to make sure of the following two points. First, the filegroups which present project data is included should be recovered.
Second, the database should be made available in the shortest time.
Besides the regularly backups, the goldengenius_biz database should be able to be recovered to its previous state in the event of the error during the manual bulk load process.
TECHNICAL REQUIREMENTS
Security
The logins in the goldengenius_biz database should be managed only by the database administrator.
The SQL Server logins and the access for database users to the new goldengenius_project database should be managed by the database administrator and the project managers.
The employees' salary information will be stored in the goldengenius_biz database. And the information should be prevented from unauthorized access.
The company wants to encrypt all traffic to and from the HTTP endpoint by utilizing SSL, and the HTTP endpoint is utilized by the goldengenius_project.
After the solution is implemented, you should make sure the principle of least privileges should be applied. In another word, only the permissions which are necessary will be granted to the users.
Maintainability
In order to cut the management overhead to the least, the company's database administrator intends to reduce the number of the separate database server to the least.
For improving availability, multiple servers can be utilized. However, when it is probable, the daily maintenance of the database should be primarily put on a single server.
The complete recovery model should be utilized by the planned goldengenius_projects database. And the three filegroups in the table listed below should be included.
GoldenGenius is an international corporation which specializes in technical content development. And the major business of the company is to create documentation and training materials for different software vendors.
At present, there are 30 full-time employees working in its head office in Portland. And more than 100 external contract writers are employed by the company, and the writers are working in home in different locations all over the world.
Planned Changes
A new and web-based solution will be implemented by the company so as to simplify the submitting work process for remote contract writers.
At present, the remote contract writers submit the work by e-mail as Microsoft Word document attachments, and the file shares on the file server called FP2 stores the work. After implementing the new solution, the remote contract writers will be permitted to have their work submitted to a Web service in WordML format, and then the work will be stored in an xml column in a new database called goldengenius_projects.
The Web service should be hosted on a current Web server in the perimeter network, and the Web service will be impersonated to gain access to the database server.
You can see the design for the new application solution from the diagram listed below.
Problem Statements
A review of the company's present security policies is required by the management. And the security should be enhanced to the maximum level so as to prevent the company data form unauthorized access or inadvertent deletion.
CURRENT DATA ENVIRONMENT
Databases
At present, there is a single SQL Server 2005 database named goldengenius_biz in GoldenGenius, Inc. and the database is utilized to store the company's financial and personnel data.
Dbo has all objects in the goldengenius_biz database.
Database Servers
There are two database servers in the Portland office. They are a primary server and a warm standby server which is respectively named SQL1 and SQL2. SQL1 is utilized to store the glodengenius_biz database, while SQL2 is utilized to utilize log shipping to replicate the goldengenius_biz database.
When a server fails, the goldengenius_biz database on SQL2 should be able to be brought online manually, and the client application should be simply set to have the standby server utilized.
The hardware on both servers greatly surpasses the existing requests for database performance.
Database Client Computers The goldengenius_biz is available to a managed client/server application, and ADO.NET
2.0 is utilized to access the database server.
CURRENT INFRASTRUCTURE Network Infrastructure From the diagram listed below, you can see there are two subnets in the network.
From the table listed below, you can see the detailed description of the servers included by the network.
Directory Services Infrastructure
There is a single Active Directory named goldengenius.com in the company network.
You can see the relating organizational units(OUS), user accounts, and global groups in the domain from the diagram listed below.
The company defines the accounts for contract writers in the ContractAccts OU, and defines other user accounts in the Users container.
BUSINESS REQUIREMENTS
General Requirements
All existing projects and archived content from previously finished projects should be included by the new goldengenius_projects database. Multiple revisions of a document can be submitted by writers. And when the project is active, all types of the documents should be sustained. When a project is finished, the final version should be handed off to the customer.
The data in archived projects is available to writers and project managers so as to retrieve replications of documents that have already been handed off to customers.
Availability
The company regards the existing availability strategy for the goldengenius_biz database as sufficient, and the strategy should not be modified. However, a level of availability should be provided by the goldengenius_biz database so as to make sure the database will be completely available in the shortest time when a server or a storage array fails. Besides that, the company request to have the risk of the data loss cut to the least.
The company will not allow any new hardware purchase to implement the availability solution. Nevertheless, the presently server which is utilized to store project documents is named FP2. When the new application is implemented, FP2 will be decommissioned. And if it is necessary, the FP2 can be utilized.
The company has to insert a great number of data into the goldengenius_biz database incidentally through a custom load operation, and the custom load operation requests to place the database in single user mode. And during the operation process, the users should be enabled to retrieve project data with no failover to the warm standby server which is utilized for log shipping.
Recoverability
A combination of full, partial, and transaction log backups will be utilized to back up all system and user databases. Since you are the technical support, you are required to create a recovery plan to specify the steps which are essential to utilize the backups when recover from a server failure.
In the event of the corruption or destruction on the goldengenius_project database, the recovery strategy should be optimized so as to make sure of the following two points. First, the filegroups which present project data is included should be recovered.
Second, the database should be made available in the shortest time.
Besides the regularly backups, the goldengenius_biz database should be able to be recovered to its previous state in the event of the error during the manual bulk load process.
TECHNICAL REQUIREMENTS
Security
The logins in the goldengenius_biz database should be managed only by the database administrator.
The SQL Server logins and the access for database users to the new goldengenius_project database should be managed by the database administrator and the project managers.
The employees' salary information will be stored in the goldengenius_biz database. And the information should be prevented from unauthorized access.
The company wants to encrypt all traffic to and from the HTTP endpoint by utilizing SSL, and the HTTP endpoint is utilized by the goldengenius_project.
After the solution is implemented, you should make sure the principle of least privileges should be applied. In another word, only the permissions which are necessary will be granted to the users.
Maintainability
In order to cut the management overhead to the least, the company's database administrator intends to reduce the number of the separate database server to the least.
For improving availability, multiple servers can be utilized. However, when it is probable, the daily maintenance of the database should be primarily put on a single server.
The complete recovery model should be utilized by the planned goldengenius_projects database. And the three filegroups in the table listed below should be included.
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. Backups of all user databases are performed on Sunday nights. Backups of all system databases are performed on Saturday nights. All backups are stored in an off-site facility. SQL01 shuts down unexpectedly because of a power failure. The SQL Server service fails to start when SQL01 is brought back online. The SQL Server error log is shown in the exhibit below. Since you are the technical support, you have to return SQL01 to working order in a minimum possible time. What action should you perform first?
정답: D
정답:
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 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 administer a SQL Server 2005 computer named SQL01. A database named DB01 is hosted on SQL01. DB1 plays the role of backend database for an application that tracks issues. DB01 helps desk technicians receive and the associated trouble tickets. When installed, the help desk application loaded several stored procedures and views that are used for data manipulation and reporting purposes. There are more than 50 tables in DB01. The bulk of the data is stored within the Employees, Issues, Assets, and AssetTracker tables. The AssetTracker table in DB01 is deleted by an application developer carelessly. The AssetTracker table is referenced by several views and functions in the database. You must make sure that critical tables cannot be removed by users such as this that are referenced by views or functions. So what action should you perform to make sure of this?
정답: C
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 SQL Server 2005 computer is managed by you, and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement, rows which duplicate CustName values are included should be moved from the CustInfo table every year. However, the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates.
Since you are the technical support, you are required to think out a method to have potential duplicate rows identified for manual examination.
The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task?
You work as a database administrator for your company. A SQL Server 2005 computer is managed by you, and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement, rows which duplicate CustName values are included should be moved from the CustInfo table every year. However, the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates.
Since you are the technical support, you are required to think out a method to have potential duplicate rows identified for manual examination.
The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task?
정답: 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. In the company, a SQL Server 2005 database experiences frequent blocking. You are asked to minimize the impact that caused by the blocking. Therefore, the database needs to be modified. You must make sure that no dirty reads are allowed. So what action should you perform?
정답: A