A2090-560 Exam Questions
120 real A2090-560 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
When is the ToplogyImbalance event triggered?
- Question #2
Which component failure does NOT trigger a HardwareServiceRequested event?
- Question #4
Which User Defined Function (UDF) statement is true?
- Question #5
When setting up a crontab entry, what must be done on a PureData System for Analytics server?
- Question #6
Which is a function of the Linux-HA heartbeat?
- Question #7
Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?
- Question #8
Which condition will NOT fail or restart a running query on a PureData System for Analytics Appliance?
- Question #9
Which condition will interrupt a query running on a fully operational PureData System for Analytics?
- Question #10
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...
- Question #11
Which option does NOT trigger a HardwareNeedsAttention event?
- Question #13
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.)
- Question #15
OLE-DB based applications on UNIX requires which PureData System for Analytics software?
- Question #16
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.)
- Question #17
Which command is used to display operational statistics about system capacity, faults, and performance?
- Question #18
Which command is used to abort a user's SQL transaction?
- Question #19
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...
- Question #20
What is the only predefined database user, which is able to access all objects and perform all tasks against the database?
- Question #21
What operating system runs on a PureData System for Analytics host?
- Question #22
What PureData System for Analytics component is responsible for controlling table storage?
- Question #23
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...
- Question #24
Why should you avoid using Boolean data types as a distribution key for a table ?
- Question #25
What will prevent a GROOM TABLE command from running on a table named TableA?
- Question #26
What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)
- Question #27
When a CREATE TABLE AS (CTAS) is performed on a table creating more than 1,000,000,000 rows, which statement is true?
- Question #28
What is a characteristic of a column that is based on the TIMESTAMP datatype?
- Question #29
Which will result in support for zonemaps on the LastName column?
- Question #30
What is the maximum number of columns you can choose as organizing keys for clustered base table?
- Question #33
Which statement is true regarding any database user?
- Question #34
What is the function of the Distributed Replicated Block Device (DRBD)?
- Question #35
Which statement is true about a simple load using external tables?
- Question #36
What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?
- Question #37
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...
- Question #38
What is the naming convention for system views?
- Question #39
What is the maximum number of columns that can participate in a distribution key?
- Question #40
If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?
- Question #41
What two conditions must be met to achieve a collocated join between two tables? (Choose two.)
- Question #42
Which statement is true regarding the compress engine?
- Question #43
The PureData System for Analytics implements which level of transaction isolation?
- Question #44
The simplest query execution plan file must have the following minimum nodes?
- Question #45
Short Query Bias (SQB) allows for reserved resources to be used for which type of query?
- Question #46
What is true about queries submitted on the PureData System for Analytics Appliance?
- Question #47
What two types of notification can be configured for an event? (Choose two.)
- Question #49
If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?
- Question #50
Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?
- Question #51
Which statement regarding temporary tables is true?
- Question #52
What is the fastest join utilized by PureData System for Analytics?
- Question #53
In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)
- Question #54
OLE-DB based applications requires which PureData System for Analytics software?
- Question #55
Which statement is NOT true regarding the nzload utility?
- Question #56
When unloading data via an external table, where can the SQL be submitted?