Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Free and Premium Teradata TDVCL2 Dumps Questions Answers

Page: 1 / 4
Total 51 questions

Associate VantageCloud Lake 2.0 Exam Questions and Answers

Question 1

Where should tables be stored when low latency is required for tight service level goals?

Options:

A.

Object File System

B.

Compute Worker Storage

C.

Native Object Store

D.

Native Disk Storage

Buy Now
Question 2

Which type of index defined the data distribution?

Options:

A.

Unique Secondary Index

B.

No Primary Index

C.

Non-unique Secondary Index

D.

Non-unique Primary Index

Question 3

Which Analytics Database component performs the work associated with generating an answer set?

Options:

A.

ARC

B.

AMP

C.

DSA

D.

PDE

Question 4

Only managers should be able to see salary information in the employee table, and then only if the employee reports to them.

Which feature supports this requirement?

Options:

A.

Secure Zones

B.

External Authentication

C.

Sparse Indexes

D.

Row Level Security

Question 5

Which statement is true for tables stored in Object File System?

Options:

A.

The tables should each have a Primary Index (PI) defined

B.

Space used will be taken from the user's permanent allocation

C.

Data is owned and managed outside the database

D.

Some indexing or partitioning is done automatically

Question 6

How would data supplied via cloud object storage be processed?

Options:

A.

Primary Compute nodes copy the data to Native Disk Store.

B.

Compute Workers or Compute Clusters access the data directly.

C.

Teradata Parallel Transporter is used to load the data to Object File System.

D.

Session Manager places the data in spool.

Question 7

Which Vantage object contains one or more SQL statements, always executed as a single request?

Options:

A.

Stored procedure

B.

Fallback

C.

Function

D.

Macro

Question 8

What does an external directory server do in relation to External Roles?

Options:

A.

Assigns system attributes

B.

Maps to Internal Roles

C.

Assigns database privileges

D.

Maps to users

Question 9

Which feature of VantageCloud Lake allows different departments to independently run their own compute-intensive workloads?

Options:

A.

Compute Workers

B.

Primary Cluster

C.

Object storage

D.

Compute Groups

Question 10

Which analytic language is supported in-database by ClearScape AnalyticsTM?

Options:

A.

IScala

B.

R

C.

Ruby

D.

Julia

Question 11

Which type of locking blocks only exclusive requests?

Options:

A.

Read

B.

Write

C.

Exclusive

D.

Access

Question 12

Which is a verification mechanism to access a Vantage system?

Options:

A.

Ownership privilege

B.

External authentication

C.

Secure Zone

D.

Profile

Question 13

Which is a use case for a data lake?

Options:

A.

Fixed-capacity pricing

B.

Self-service data exploration

C.

High-volume tactical workloads

D.

Benefit from automatically modeled data

Question 14

Which statement is true in a relational database?

Options:

A.

Each table must have at least one foreign key.

B.

Each table must have exactly one foreign key.

C.

Every foreign key must be the primary key of another table.

D.

Every primary key must be the foreign key of another table.

Question 15

Which component of VantageCloud Lake permits the administrator to manage users?

Options:

A.

Object File System

B.

Console

C.

Compute Group

D.

Session Manager

Page: 1 / 4
Total 51 questions