FlashCopy
FlashCopy SE
Metro Mirror
Global Mirror
第1题:
A customer with a small IT budget has one data center. Their main application is a database running on an IBM System Storage DS8000. The database has a data change rate of 50% per day. Once a week, they must do a point-in-time backup from the database to tape. The time it takes to run the backup now exceeds the backup window allowed. The customer requests a proposal to reduce database downtime caused by running backups, with nearly no impact to production volumes. In addition to the tape backup, which DS8000 feature should a technical specialist propose()
第2题:
A customer has the following non-virtualized servers: - three Exchange servers, each with 2.8 TB database - five System i Domino servers, each with 2 TB database - 20 TB usable capacitySun/SAP cluster - 70 TB usable capacity of System p requirement - annual growth rate of 12 TB usable capacity per year What is the most cost-effective solution for three years()
第3题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第4题:
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation?()
第5题:
A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?()
第6题:
Shut down the database, restore the two data files and then start up the database.
Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online.
Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open.
Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
第7题:
Create the database by using a single data file and a single log file.
Create the database by using a single data file and multiple log files.
Create the database by using a single log file and multiple filegroups.
Create the database by using a single log file and a filegroup that has multiple data files.
第8题:
Restore all the data files and open the database
Create the data file and perform tablespace recovery
No need to restore any file, just recover the database
Restore only the system data file and recover the database
Restore only lost date file and performtablespacerecovery
第9题:
collect all support data
implement a current backup
update all firmware levels
shut down the storage system
第10题:
DS8700 with Easy Tier
XIV Storage System with SVC
XIV Storage System with CoD
DS5020 with Enhanced Remote Mirroring
第11题:
FlashCopy
FlashCopy SE
Metro Mirror
Global Mirror
第12题:
IBM System Storage DS8700 2 way
IBM System Storage DCS9900
IBM System Storage DS8700 4 way
IBM XIV Storage System
第13题:
A local manufacturing customer is looking for a highly scalable, easy to use disk storage system tosupport a new application they are bringing into the data center. The customer has an initialrequirement for 40 TB of high performance storage but they expect to more than double thecapacity needed once the application goes into full production. What IBM solution would be themost cost effective while meeting their initial requirements?()
第14题:
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()
第15题:
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible?()
第16题:
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?()
第17题:
A customer has determined they want to install an IBM x445 system in their company. They will be running a large database on the system. In order to determine how many CPUs will be needed to attain the optimum cost-effective solution, which TWO of the following questions should be asked?()
第18题:
The database has a subset of the tables in the production server database.
The database has a copy of selected data from the production database
The database logs changes for later propagation.
The database is accessed as read-only to prevent data corruption.
The database includes all user and order data for offline processing.
第19题:
Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
Back up the current transaction log. Restore the database to the point just before the data loss.
Restore the database from the existing backup files to a time just before the data loss.
Restore the database to the point of the last full backup.
第20题:
Restore the data file for the SYSTEM tablespace then open the database.
Restore all redo logs form last night's backup, then restart the database.
Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.
Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
第21题:
Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
Back up the current transaction log. Restore the database to the point just before the data loss.
Restore the database from the existing backup files to a time just before the data loss.
Restore the database to the point of the last full backup.
第22题:
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.
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.
Modify the format file to specify the same collation as the Dublin database. Import the table again.
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.
第23题:
The backup will consist of used data blocks only.
The database must be shut down to accomplish the backup.
The backup can be accomplished without shutting down the database.
The backup will contain all database files that have never been backed up
第24题:
RAID 3
RAID 5
RAID 6
RAID 10