A2090-560 Exam Questions

Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)

How does the PureData System for Analytics utilize the distribution key to store records on disk?

What should be considered when you are asked to select the distribution key columns for a very large fact table?

What is the host Linux file that must be modified to adjust optimizer settings permanently?

Which statement is true about the groom feature?

Why is generating statistics on a table important to query performance?

Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?

Which statement is true?

On which component(s) does the UDX run?

Which procedural logic is NOT supported by NZPLSQL?

Which attribute CANNOT be defined for both users and groups?

Zone Maps provide what information about a table?

What is the maximum number of databases that can be created?

When working with sequences, which statement will always be true?

When creating a table, you can specify a column constraint for each individual column of either "NULL" or "NOT NULL". When column values are later evaluated within a query statemen...

To create a database table, at a minimum, what must be specified?

Which two statements are true about queries on the PureData System for Analytics Appliance? (Choose two.)

Which statement describes administrative privileges?

The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?