Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Which type of data warehouse implementation maps multiple database platforms into a single coherent view?

A.

Transactional .

B.

Data marts

C.

Analytical

D.

Federated

Which database object contains a two-dimensional representation of a real world entity or relation?

A.

Row

B.

Tuple

C.

Schema

D.

Table

What is a dimensional view?

A.

A fallback schema view that is layered over detail data of a fallback table and is used to compare fallback data to the detail data of the associated base table

B.

A view that is layered over a dimension table and provides statistics on the data in the table

C.

A virtual star or snowflake schema layered over detail data maintained in fully-normalized base tables

D.

A virtual view that is layered over a metadata table and presents a view of a single attribute of the data

Which types of tables are included in a dimensional model?

A.

Metadata and Data

B.

Base and Detail

C.

Fact and Dimension

D.

Fallback and Primary

What is a use case for a Join Index?

A.

A one-time merge on a single table A table

B.

with multiple UDFs

C.

A frequent query with the same two tables

D.

A query that uses the Primary Index

In a data warehouse architecture, a Data Lake would serve which purpose?

A.

Run customer reports

B.

Store raw data at scale

C.

Provide cloud services

D.

Perform business intelligence

Which mechanism can be used to upgrade the severity of a lock?

A.

Locking Request Modifier

B.

Locking Protocol

C.

Two-Phase Commit

D.

Two-Phase Locking

Which type of index impacts data distribution?

A.

Secondary Index

B.

Global Index

C.

Primary Index

D.

Hash Index

What differentiates a database from a user?

A.

Only databases have spool allocation.

B.

Users have passwords.

C.

Users do not own tables.

D.

Databases own users, users cannot own databases.

Which tool provides SQL Query Builder which gives the user a list of valid SQL statements?

A.

Data Stream Architecture (DSA)

B.

Teradata Viewpoint

C.

Teradata Index Wizard

D.

Teradata Studio