P2090-050 Exam Questions

When is the ToplogyImbalance event triggered?

Which component failure does NOT trigger a HardwareServiceRequested event?

Which statement describes administrative privileges?

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

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...

Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?

TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

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

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.)

Where are the database log files located?

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?

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 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?

You have created a group GroupA with JOB MAXIMUM of 4, which statement is true?

Which CREATE DATABASE attributes are required?

Which statement is true for database users and groups?

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 characteristics describe materialized views. (Choose two.)

What is a benefit of Clustered Base Tables?

When are zonemaps initially created for a table?

Which of the following is a valid datatype definition?

When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

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?