Which condition will NOT fail or restart a running query on a PureData System for Analytics Appliance?
A. Disk resets or fails.
B. Host resets or fails.
C. S-Blade resets or fails.
D. Snippet Processing Unit (SPU) resets or fails.
Which condition will interrupt a query running on a fully operational PureDataSystem for Analytics?
A. One fan fails.
B. One disk fails.
C. Active host fails.
D. One power supply fails.
A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource groupeach execute 1 job at the same time, which statement is correct?
A. Each job gets 25% and both run at the same time.
B. Each job gets 50% but only one job runs at a time.
C. Each job gets 50% and both run at the same time.
D. You cannot set the job maximum per resource group.
When setting up a crontab entry, what must be done on a PureData Systemfor Analytics server?
A. Create an nzcron event.
B. nzstop/nzstart the database.
C. Stop and start the appliance.
D. Add entry to active host and standby host.
Which is a function of the Linux-HA heartbeat?
A. Performsregeneration of failed disks on the hosts.
B. Manages communication and processes on the S-Blades.
C. Performs disk partitioning and status of jobs on the S-Blades.
D. Manages communication and status of services on the hosts.
Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?
A. AIX-HA
B. Linux-HA
C. SuSE-HA
D. Solaris-HA
Which component failure does NOT trigger a HardwareServiceRequested event?
A. Fan
B. Disk
C. Host
D. S-Blade
Which statement describesadministrative privileges?
A. Provides audit functionality for the database.
B. Manages resource allocations for concurrent processing.
C. Gives permission to execute global operations and to create objects.
D. Gives additional storage to select members of the administrator group.
The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?
A. The typical or most common types of queries.
B. The longest and shortest running queries on the system.
C. The queries submitted by specific users or groups of users.
D. The rotational speed of the disk drives during query execution.
What is required to troubleshoot a query?
A. nzevents and the pg.log.
B. nzsql and the ODBC config.
C. nzinventory and the dbos.log.
D. nzdumpschema and the execution plan.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-050 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.