TDVAN5 practice question 14 of 15
An Administrator manages a Vantage system that is continually updated. The system is critical to the business and must be available as much as possible. The Administrator decides to use a backup strategy that will allow changes to tables while a backup is in progress. Which backup strategy should be used?
Full set: 72 questionsAn online backup strategy is specifically designed for high-availability systems where continuous operation is critical. This method allows backup operations to run concurrently with user transactions, including DML changes (inserts, updates, deletes) to the tables being backed up. The system achieves this by placing read locks on the data blocks, which prevents structural changes (DDL) but permits ongoing data modifications. This ensures the database remains accessible and operational for business users during the backup process, directly meeting the administrator's requirements for a continually updated, business-critical system.
A. Offline: An offline backup requires the database or tables to be taken offline or placed under an exclusive lock, preventing any user access or modifications during the backup.
B. Skip statistics: This is a backup job option that excludes collected statistics from the archive. It is not a backup strategy that defines the availability of the system during the process.
D. Dictionary Only: This specifies the scope of the backup, limiting it to the Data Dictionary (DBC) tables. It does not back up user data tables or define the online/offline nature of the operation.
1. Teradata Vantage™ Data Stream Architecture User Guide, Release 17.20, B035-3150-0222K. In Chapter 4: Backup Jobs, the section "Online Archive" states, "Online archive allows you to back up databases and tables while they are being accessed and updated by other users. Online archive is the default." This directly supports the use of an online strategy for systems with concurrent updates.
2. Teradata® Archive/Recovery Utility Reference, Release 16.20, B035-2412-057K. In Chapter 2: ARCHIVE, the description of the LOGGING ONLINE ARCHIVE option explains, "When you specify ONLINE, Archive places a read lock on objects as they are being archived. This allows other users to have read and write access to the objects during the archive." This confirms that online backups permit changes.
3. Teradata Vantage™ Database Administration, Release 17.20, B035-1093-0322K. In Chapter 13: Archiving Data, the section "Archive and Recovery Concepts" discusses the importance of backup strategies for business continuity. It implicitly supports online backups by detailing how Teradata utilities are designed to work on active systems to minimize downtime, a core principle of online operations.
Keep practicing
Take the free TDVAN5 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other TDVAN5 practice questions
- Question 1Which description accurately characterizes the use of external authentication for Vantage?
- Question 2An Administrator needs to provide end users access to data in a Native Object Store using…
- Question 3There is corruption in a table in the DBC database. Which action should the Administrator…
- Question 4A Vantage customer is using the Hive Connector in QueryGrid to access a foreign server an…
- Question 5A Vantage instance includes the following four databases: Tables Database contains base t…
- Question 6Which benefit is achieved by creating profiles?
