Which statement is true for database users and groups?
A. All users must belong to admin group.
B. Creation of users and groups is not allowed.
C. Users and groups are local and tied to a particular database.
D. Users and groups are global and not tied to a particular database.
What will prevent a GROOM TABLE command from running on a table named TableA?
A. If there are any materialized views on the table TableA.
B. If there are any active selects running against the table TableA.
C. If there are any active nzloads running against the table TableA.
D. If there are any active updates running against the table TableA.
What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)
A. The views on TableA.
B. The privileges on TableA.
C. The distribution key of TableB.
D. The materialized views on TableB.
E. The order of the data stored in TableB.
When a CREATE TABLE AS (CTAS) is performed on a table creating more than 1,000,000,000 rows, which statement is true?
A. Groom will be automatically invoked.
B. Primary key constraints will be checked.
C. Statistics will automatically be generated.
D. Materialized views will be automatically generated.
What is the host Linux file that must be modified to adjust optimizer settings permanently?
A. /nz/data/postgresql.conf
B. /nz/data/config/system.cfg
C. /nz/kit/sys/initTopology.cfg
D. /nz/kit/log/sysmgr/sysmgr.log
Which statement is true about the groom feature?
A. Groom allows the user to add row level security.
B. Groom validates primary key constraints on the table.
C. Groom reorders rows based on the DISTRIBUTE ON clause.
D. Groom allows the user to reorganize tables based on the ORGANIZE ON clause.
Why is generating statistics on a table important to query performance?
A. The table statistics are used to facilitate disk space reclamation of deleted rows.
B. The optimizer uses statistics to determine the optimal execution plan for queries.
C. The Zone Map information cross references the table statistics for each column to avoid scanning.
D. The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which row/columns to filter.
What is the only predefined database user, which is able to access all objects and perform all tasks against the database?
A. root
B. public
C. admin
D. system
What operating system runs on a PureData System for Analytics host?
A. AIX
B. SUSE Linux
C. Nucleus OS
D. Redhat Linux
What PureData System for Analytics component is responsible for controlling table storage?
A. S-Blade (Snippet-Blade)
B. SFI (Switching Fabric Interface)
C. FPGA (Field Programmable Gate Array)
D. DRBD (Distributed Replicated Block Device)
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-047 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.