网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
A customer is planning to implement a database server for their high volume online business. Downtime at any point represents a significant loss of revenue， so performance and high availability are extremely important.They requested a 4-way configuration with 8GB RAM and four gigabit Ethernet connections.Which of the following solutions is the most appropriate？（）
A
x445 4-way Xeon DP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two BroadCom Gigabit NICs
B
x366 4-way Xeon MP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two Intel Gigabit NICs
C
x445 4-way Xeon MP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two BroadCom Gigabit NICs
D
x445 4-way Xeon DP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two Intel Gigabit NICs
参考答案
参考解析
解析：
暂无解析
更多 “单选题A customer is planning to implement a database server for their high volume online business. Downtime at any point represents a significant loss of revenue， so performance and high availability are extremely important.They requested a 4-way configuration with 8GB RAM and four gigabit Ethernet connections.Which of the following solutions is the most appropriate？（）A x445 4-way Xeon DP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two BroadCom Gigabit NICsB x366 4-way Xeon MP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two Intel Gigabit NICsC x445 4-way Xeon MP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two BroadCom Gigabit NICsD x445 4-way Xeon DP machine using 16 x 512MB DIMMS， ServeRAID 6M adapter and Ultra320 15K Hard Disk drives in a RAID-1 set with an additional two Intel Gigabit NICs” 相关考题
考题
You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A．Implement merge replication.B．Implement snapshot replication.C．Implement transactional replication.D．Schedule replication to run continuously.E．Schedule replication to run during off-peak hours.
考题
A customer has two separate storage networks and is planning to implement an SVC to provide for FlashCopy between the two networks. What is the minimum number of ISL ports required?()
A.0B.1C.2D.4
考题
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.
考题
You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do？（）A、Implement a stored procedure that writes data about schema changes to a log table.B、Implement DDL AFTER triggers that write user and schema information to a log table.C、Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.D、Implement a DML AFTER trigger that writes data about schema changes to a log table.
考题
A customer has two separate storage networks and is planning to implement an SVC to provide for FlashCopy between the two networks. What is the minimum number of ISL ports required?（）A、0B、1C、2D、4
考题
A technical specialist has a requirement to implement a 4-way POWER5 server with a small Web server partition and a high performance database server partition. The Web server provides a client front-end to the database server. The most important concerns are speed of communication between the Web server and the database and I/O speed of the database. Which of the following virtualization features would be most appropriate？（）A、Virtual SCSIB、Virtual EthernetC、Virtual I/O ServerD、Micro-Partitioning
考题
A customer is planning on establishing a Global Mirror between two Storwize V7000 storagearrays. The customer is planning to lease an IP WAN connection between sites for the tasks andis running a SAP （database） application on Oracle. Which of the following planning considerationsis most important？（）A、the distance between sites needs to be less than 100 kilometersB、consistency groups should be created to maintain write order on the remote mirrorC、ensure sufficient bandwidth exists on the link based on average application workloadsD、ensuring a low round trip latency of less than 30ms on the WAN connection is required
考题
A customer’s current backup environment uses IBM Tivoli Storage Manager （TSM） over thecorporate LAN. A 500 GB Oracle database application was recently added to the SAN. Backupwindows are no longer being met. Which action should the storage specialist recommend？（）A、virtualize the storage with SVCB、implement TSM for space managementC、implement TSM for Storage Area NetworksD、add an additional Ethernet card to the TSM server
考题
A customer has two separate storage islands and is planning to implement an SVC to provide forFlashCopy between the two islands. What is the minimum number of inter-switch links （ISLs） thatare required？（）A、0B、1C、2D、4
考题
A customer currently has a large group of older 1U servers. Each dedicated to aunique application. Quick provisioning of the servers is important to the customer. Which of the following approaches addresses this situation？（）A、VirtualizationB、Replace each server with energy efficient serversC、Upgrade in place to improve performanceD、Implement BladeCenter
考题
A customer wants to implement a clustered database solution on their existing x445 servers. A minimum of four nodes must participate in the cluster， and the customer wishes to use open standards. Which of the following best satisfies their requirements？（）A、Novell NetWare Cluster ServicesB、Red Hat Enterprise Linux Cluster SuiteC、Microsoft Windows 2003 Server with MSCSD、Microsoft Windows 2003 Enterprise Edition
考题
A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）A、The application server，firewall，and database server on the same VLANB、The application server and firewall on one VLAN，and the database server on a second VLANC、The application server on one VLAN，and the database server and firewall on a second VLAND、The application server and firewall on one VLAN，and the firewall and database server on a second VLAN
考题
A customer needs to implement a Highly Available solution for JMS that has a primary data center and a backup. Which three steps would you perform when designing your solution?（）A、Store Transaction Logs in a database and use Database stores for JMS to make replication between sites easier.B、Use file based Transaction Logs and JMS stores and implement a separate replication solution for files in addition to database in case database replication fails.C、Implement Oracle RAC at each site to provide a highly available solution within each datacenter.D、Configure Whole Server Migration to migrate WebLogic Managed Servers from the primary to the secondary site.E、Configure Automatic Service Migration for JMS high availability within a datacenter.
考题
You have an Exchange Server 2010 organization. The network contains an Exchange Server 2010 Mailbox server named Server1. All mailboxes are stored on Server1. You perform a Typical installation of Exchange Server 2010 on a new server named Server2. You plan to implement redundancy for mailbox access. You need to recommend a solution that ensures that client computers can reconnect to their mailboxwithin five minutes if Server1 fails. What should you recommend？（）A、Configure cluster continuous replication （CCR）. Implement a file share witness.B、Configure a Network Load Balancing cluster that includes Server1 and Server2. Implement Active Directory-integrated DNS zones.C、Configure a database availability group （DAG） that includes Server1 and Server2. Set the time to live （TTL） for the DNS record.D、Configure a database availability group （DAG） that includes Server1 and Server2. Use the same certificate for both servers.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（） A、You should implement Differential backup B、You should implement Database snapshotsC、You should implement Primary filegroup backup D、You should implement Transaction log backup
考题
You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1，000 simultaneous users. This application must quickly display the results of calculation-intensive operations， such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do？（）A、Implement parameterized Transact-SQL queries in the application.B、Implement Transact-SQL stored procedures in the database.C、Implement CLR stored procedures in the database.D、Implement distributed Web services.
考题
You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure. You need to recommend an approach for ensuring that database connectivity does not degrade. Which two actions should you recommend？（）A、 Implement transactions for database queries.B、 Close database connections in the application.C、 Use Microsoft ADO.NET in the data access layer.D、 Implement a retry policy in the data access layer.
考题
Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）A、Implement horizontal partitioning.B、Implement vertical partitioning.C、Implement a raw partition.D、Implement distributed partitioning.
考题
单选题An administrator is planning a cluster running applications in 3 separate resource groups. RGA - Database 1 RGB - Web Server RGC - Database 2 Database 1 and Database 2 must be online before the Web Server. All resource groups have a Startup Policyof Online on Home Node Only. Which of the following will ensure that the resource groups are processed in the correct order？（）A
Set the Serial Acquisition OrderB
Set the Parallel Acquisition OrderC
Configure Online on the Same Node DependencyD
Configure Online on Different Nodes Dependency
考题
单选题A customer has two separate storage networks and is planning to implement an SVC to provide for FlashCopy between the two networks. What is the minimum number of ISL ports required?（）A
0B
1C
2D
4
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is an internal application which uses Analysis Services and Reporting Services. You use the application on the basis of SQL Server 2008. According to the requirement of company security policy, the surface area for all the deployed components of SQL Server 2008 should be configured. You have to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?（）A
You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured B
You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured C
You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured D
You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA
考题
单选题A customer has two separate storage islands and is planning to implement an SVC to provide forFlashCopy between the two islands. What is the minimum number of inter-switch links （ISLs） thatare required？（）A
0B
1C
2D
4
考题
单选题You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation. You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）A
Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.B
Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.C
Modify the format file to specify the same collation as the Dublin database. Import the table again.D
Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.
考题
单选题A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements？（）A
The application server，firewall，and database server on the same VLANB
The application server and firewall on one VLAN，and the database server on a second VLANC
The application server on one VLAN，and the database server and firewall on a second VLAND
The application server and firewall on one VLAN，and the firewall and database server on a second VLAN
考题
单选题A customer is building a database server， and the server does sequential write most of the time. They are planning to use an IBM x445 and a ServeRAID-6M adapter. Which of the following fault tolerant RAID levels will perform best for sequential write？（）A
RAID-5 with cache write backB
RAID-1E with cache write backC
RAID-10 with cache write thruD
RAID-50 with cache write thru
考题
单选题You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）A
Monitor thealert.logfileB
Enable server-side SQL tracing for user sessionsC
Enable fine-grained auditing for the customer tableD
Enable Fine-Grained Access Control （FGAC） for the customer tableE
Write a database trigger on the customer table on the SELECT event
考题
多选题A customer needs to implement a Highly Available solution for JMS that has a primary data center and a backup. Which three steps would you perform when designing your solution?（）AStore Transaction Logs in a database and use Database stores for JMS to make replication between sites easier.BUse file based Transaction Logs and JMS stores and implement a separate replication solution for files in addition to database in case database replication fails.CImplement Oracle RAC at each site to provide a highly available solution within each datacenter.DConfigure Whole Server Migration to migrate WebLogic Managed Servers from the primary to the secondary site.EConfigure Automatic Service Migration for JMS high availability within a datacenter.
考题
单选题You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）A
Implement parameterized Transact-SQL queries in the application. B
Implement Transact-SQL stored procedures in the database. C
Implement CLR stored procedures in the database. D
Implement distributed Web services.
热门标签
最新试卷
