The 'Dovetail Phase 2 (All Topics)' quiz assesses knowledge across various database topics, including multidimensional clusters, node partitioning, block indexes, data prefetching, and statistics updates. It is designed to test and reinforce understanding of core database management principles.
Success
Failure
Error
None
Rate this question:
True
False
Rate this question:
Fact
Attributes
Both the facts and attributes
None
Rate this question:
Ds directory
D:
C:
None
Rate this question:
Yes
No
Rate this question:
Use standard terminologies
Mandatory elements must not be missed
Support archiving
All
Rate this question:
Accuracy
Consistency
Integrity
Volume
Rate this question:
Creation
Validatio
Updation
Deletion
All
Rate this question:
True
False
Rate this question:
Audit Data
Filter Data
Correct Data
All
Rate this question:
Business
Product
Customer
None of the above
Rate this question:
Name Match
Fuzzy Match
Spelling Match
Like Match
Rate this question:
True
False
Rate this question:
Links
Stages
Both
None
Rate this question:
True
False
Rate this question:
Star schema
Snowflake schema
None
Both
Rate this question:
True
False
Rate this question:
Fetching data from hard disk to buffer pool
Fetching data from page to buffer pool
None
Rate this question:
It is the Communication buffer between the local application and its associated Agent.
Error Agent
Local Error Handler
Rate this question:
Compound attribute
Multiple attribute
Common Attribute
Rate this question:
Stop and start microstatergy intelligence server
Disconnect and reconnect to the project source
All
Manually update the schema
Rate this question:
True
False
Rate this question:
2
5
7
No Limit
Rate this question:
Simple Metric
Compound Metric
Nested Metric
Rate this question:
Abort
Compiled
Reset
None
Rate this question:
Conversion
Mark-Up
Extraction
None
Rate this question:
Implicit expression
Derived expression
Simple expression
Heterogeneous mapping
Rate this question:
Leaf
Node
Root
Rate this question:
Data from the buffer pool is written to the disk
No Buffer
Data from the buffer pool is written to the page
Rate this question:
In Logical Partition
In Primary Partition
In Secondary Partition
Rate this question:
Facts, Attributes
Hierarchies
Transformation
Partition mapping
All
Rate this question:
Server Level Partitioning
Application Level Partitioning
Both
Rate this question:
Ds job
Ds/job
None
Rate this question:
True
False
Rate this question:
1
5
2
Many
Rate this question:
Stage variable-> Constraints-> Derivations
Stage variable->Derivations-> Constraints
Derivations-> Constraints->Stage variable
None
Rate this question:
Reporting Tool
ETL tool
Analysis Tool
MetadataTool
Rate this question:
True
False
Rate this question:
CPU
User
Memory
Rate this question:
Report objects
View filters
Derived metrics
All
Rate this question:
2
4
3
1
Rate this question:
Latest row is retained.
First row is retained.
No row is retained.
Rate this question:
DSSTART
../univ
./univ
None
Rate this question:
Not compiled state
Aborted state
State while exported
None
Rate this question:
Metadata must merge together
Metadata must not merge together
Duplication
None
Rate this question:
Data masking and mask pattern analysis are used in string substitution.
Postal department contains Residential address.
Global data router is used to scan specific address.
Router is to determine the country to which the addresses belong.
Only USA has detailed address level
Evaluate data quality before building a fully fledged data ware house.
Rate this question:
Yes, it is possible in case of PX jobs
It is not possible in case of server jobs
Not possible
Yes, if they exist in different category
Rate this question:
Massively Parallel Processing
Maximum Parallel Processing
Minimum Parallel Processing
Marginal Parallel Processing
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.