CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. TDVAN5

Free TDVAN5 Exam Braindumps (page: 3)

Page 2 of 19
PDF with 72 Questions

What is a use case for Data Mover?

  1. Archiving data to a Hadoop system
  2. Copying data between Vantage systems for active-active replication
  3. Replicating data to a disaster recovery system
  4. Copying data between Hadoop systems

Answer(s): C

Explanation:

Teradata Data Mover is primarily designed to copy and replicate data between Teradata or Vantage systems. One of its common use cases is to move data to a disaster recovery system, ensuring that data is available in case of system failure or disaster, and making it a valuable tool for maintaining high availability and business continuity.
Archiving data to Hadoop and Copying data between Hadoop systems are more relevant to other tools such as Teradata QueryGrid, which integrates Vantage with Hadoop and other external systems. Copying data between Vantage systems for active-active replication might involve Data Mover, but active-active replication typically involves more sophisticated real-time synchronization technologies like Teradata's Unity or QueryGrid.



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?

  1. Offline
  2. Skip statistics
  3. Online
  4. Dictionary Only

Answer(s): C

Explanation:

An Online backup strategy allows the database to remain accessible and operational while the backup is taking place. This means that users can continue to modify data, and the system can remain available without requiring downtime. It is a common approach for mission-critical systems that need to maximize uptime.
Offline would require the system or certain tables to be unavailable during the backup process, which is not suitable for a system that needs to remain available. Skip statistics refers to skipping the backup of statistics on database objects and does not relate to whether the system can be updated during the backup.
Dictionary Only involves backing up only the system catalog or dictionary data, not the actual table data, and would not fulfill the requirement of a comprehensive backup while allowing updates.



A client is having many problems with a poorly written SQL. They have product joins running against large tables, and this is causing severe performance issues. The Administrator needs to help the client avoid the harm to the system that is being caused by running these queries.
Which action should be taken by the Administrator to assist this client?

  1. Use the Query Spotlight Viewpoint portlet to deprioritize the queries.
  2. Use the Flex Throttle option.
  3. Use a TASM system filter.
  4. Use the Query Log Viewpoint portlet to identity and abort the harmful queries.

Answer(s): C

Explanation:

Teradata Active System Management (TASM) allows the system administrator to control and manage query workload in real-time. A TASM system filter can be used to prevent or deprioritize certain types of queries, such as product joins or poorly written queries, that are consuming excessive resources. This approach ensures that problematic queries do not harm the overall system performance.
Query Spotlight Viewpoint portlet focuses on identifying and managing individual queries but does not provide the same level of proactive filtering and control as TASM system filters. Flex Throttle is useful for controlling the concurrency of queries, but it doesn't specifically address preventing or managing product joins in a way that would directly resolve the issue with poorly written SQL.
Query Log Viewpoint portlet would help in identifying and aborting harmful queries, but it's a reactive approach rather than a proactive solution like using TASM system filters.



The Administrator has dropped a profile which was associated with a group of users.
What will happen when one of the users from the group logs on to the database?

  1. The default profile setting for the user will be reset to NULL.
  2. Password attributes defined at the system level in DBCSecurityDefaultsV will apply
  3. The system will show a warning message.
  4. SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user.

Answer(s): B

Explanation:

When a profile is dropped, the users who were associated with that profile will no longer have the specific resource and configuration settings defined by that profile. Instead, the system-level default settings, such as those specified in DBC.SecurityDefaultsV, will apply to the users. This includes password attributes and other system-wide settings.
Option A (The default profile setting for the user will be reset to NULL) is not accurate, as the system will revert to the default settings rather than leaving values unset.

Option C (The system will show a warning message) does not typically occur when a profile is dropped. The system will manage the transition without user-facing warnings at login. Option D (SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user) is incorrect because once the profile is dropped, its settings no longer apply to the users who were associated with it.
Thus, the correct outcome is that system-level attributes defined in DBC.SecurityDefaultsV will govern the users' settings moving forward.






Post your Comments and Discuss TeraData TDVAN5 exam with other Community members:

TDVAN5 Discussions & Posts