Single database partition, single processor
Single database partition, multiple processors
Multiple database partitions, single processor
Multiple database partitions, multiple processors
第1题:
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?()
第2题:
A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (servers, processors)? ()
第3题:
Company.com has a single pSeries server with two shared processor logical partitions. The first partition has peak resource requirements during weekdays. The second partition has peak resource requirements during weekends. During the peak times, the total workload between the partitions does NOT exceed the capacity of the server. However, the partitions are not able to utilize the full capacity of the system during peak times, because the necessary CPU and memory resources are not always allocated to the busiest partition. Which of the following options would best balance these resources?()
第4题:
In which two environments would intra-partition parallelism be used? ()
第5题:
Which two statements are correct regarding IS-IS?()
第6题:
Which statements are true about logical structures of the Oracle database()
第7题:
Which two statements are true regarding listeners()
第8题:
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?()
第9题:
one server having at least two processors
two servers having one processor and one logical database partition
one server having four processors and two logical database partitions
two servers each having four processors and two logical database partitions
第10题:
no single point of failure
trading database server location
redundant application servers location
deterministic response to all failures
determine which protocol to use
第11题:
All existing databases in the instance are expanded to the new database partition but data cannot be stored on the newpartition until it has been added to a partition group.
Database partition groups within existing databases will automatically include the new database partition and willredistribute their existing data to the new partition.
Any single partition databases within the instance will automatically become multi-partition databases once the newpartition is added to the instance.
A database administrator would need to modify the db2nodes.cfg file to complete the addition of the new partition tothe instance.
第12题:
set the SESSIONS to 1 in the parameter file
grant SINGLE SESSION privilege to all of the users
set the SESSIONS_PER_USER to 1 in the users’ profile
grant RESTRICTED SESSION privilege to all of the database users
create a role with SINGLE SESSION privilege and assign the role to the users
第13题:
A customer has two Power 770 systems with 4 enclosures each. Thirty two cores and 1TB of memory are activated on each system. Each system has 3 database partitions and each partition has 10 cores and 300GB of memory. Which solution will provide automated recovery of unplanned outages at least cost?()
第14题:
The database on a p5-570 Micro-Partition has grown and backups are not meeting the Service Level Agreement. There are several partitions using the Virtual I/O Server to access the storage array. The database backup has high CPU utilization while the others have low CPU utilization. What adjustment can the technical specialist make to ensure that the Service Level Agreement is achieved?()
第15题:
A customer would like to consolidate multiple database workloads to a single server to reduce TCO. What is the effect of PowerVM on TCO?()
第16题:
If the ADD DBPARTITIONNUM command is used to add a new database partition to an existing DB2 instance,which statement is correct? ()
第17题:
Which statements are true regarding listeners()
第18题:
In which situation would you use static database registration for a listener()
第19题:
Which three statements are true about logical structures of the Oracle database()
第20题:
local database installed on the MDM only
live local database installed on the BMDM only
single database on a clustered machine remote from the MDM and BMDM
live database installed on a single Fault Tolerant Agent within IBM Tivoli Workload Scheduler network
live database on MDM and High Availability Disaster Recovery/Data Guard standby database on BMDM
第21题:
Routers maintain a single link-state database per area.
Routers maintain a separate Level 1 link-state database.
Routers maintain a separate Level 2 link-state database.
Routers maintain a single Level 1 link-state database per area.
第22题:
Multiple application servers must be in a single resource group.
Multiple application servers per resource group may be monitored.
Multiple resource groups must each contain a single application server.
Multiple application servers in a cluster cannot use process monitoring.
第23题:
Routers maintain a single link-state database per area.
Routers maintain a separate Level 1 link-state database.
Routers maintain a separate Level 2 link-state database.
Routers maintain a single Level 1 link-state database across multiple areas.