A2090-560 Exam Questions

When is the ToplogyImbalance event triggered?

Which component failure does NOT trigger a HardwareServiceRequested event?

Which User Defined Function (UDF) statement is true?

When setting up a crontab entry, what must be done on a PureData System for Analytics server?

Which is a function of the Linux-HA heartbeat?

Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?

Which condition will NOT fail or restart a running query on a PureData System for Analytics Appliance?

Which condition will interrupt a query running on a fully operational PureData System for Analytics?

A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource group each execute 1 job at the same time, which statement is corre...

Which option does NOT trigger a HardwareNeedsAttention event?

In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)

OLE-DB based applications on UNIX requires which PureData System for Analytics software?

In order for an ODBC application running on Microsoft Windows to connect to PureData System for Analytics, which two steps must be performed? (Choose two.)

Which command is used to display operational statistics about system capacity, faults, and performance?

Which command is used to abort a user's SQL transaction?

Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from t...

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

What operating system runs on a PureData System for Analytics host?

What PureData System for Analytics component is responsible for controlling table storage?

Click on the exhibit. Given the following query: SELECT * FROM TableA, TableB WHERE TableA.c_custkey = TableB.o_custkey; What type of join processing will occur when the query is e...

Why should you avoid using Boolean data types as a distribution key for a table ?

What will prevent a GROOM TABLE command from running on a table named TableA?

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)

When a CREATE TABLE AS (CTAS) is performed on a table creating more than 1,000,000,000 rows, which statement is true?

What is a characteristic of a column that is based on the TIMESTAMP datatype?

Which will result in support for zonemaps on the LastName column?

What is the maximum number of columns you can choose as organizing keys for clustered base table?

Which statement is true regarding any database user?

What is the function of the Distributed Replicated Block Device (DRBD)?

Which statement is true about a simple load using external tables?

What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?

nzload is invoked with the "allowReplay" option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is t...

What is the naming convention for system views?

What is the maximum number of columns that can participate in a distribution key?

If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?

What two conditions must be met to achieve a collocated join between two tables? (Choose two.)

Which statement is true regarding the compress engine?

The PureData System for Analytics implements which level of transaction isolation?

The simplest query execution plan file must have the following minimum nodes?

Short Query Bias (SQB) allows for reserved resources to be used for which type of query?

What is true about queries submitted on the PureData System for Analytics Appliance?

What two types of notification can be configured for an event? (Choose two.)

If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?

Which statement regarding temporary tables is true?

What is the fastest join utilized by PureData System for Analytics?

In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)

OLE-DB based applications requires which PureData System for Analytics software?

Which statement is NOT true regarding the nzload utility?

When unloading data via an external table, where can the SQL be submitted?