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.
When is the ToplogyImbalance event triggered?
A. When a SAS switch has failed.
B. When the path the path between an S-Blade and its disks has failed.
C. When a disk enclosure's voltage sensor is reading outside the nominal range.
D. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).
Which piece of information is NOT gathered as part of the statistical information when generate statistics is run on a table?
A. The number of rows in the table.
B. The number of updated rows in the table.
C. The minimum and maximum value in each column.
D. The number of unique or distinct values in each column.
Which option does NOT trigger a HardwareNeedsAttention event?
A. A power supply has failed.
B. A switch has been rebooted.
C. A SAS cable fails or is disconnected.
D. A chassis or fabric switch port is in a down state for longer than the defined threshold.
What is nzconvert used for?
A. To convert compressed external tables into ASCII text.
B. To convert between character encodings before loading data.
C. To translate stored procedures into NZPLSQL compatible syntax.
D. To upgrade/downgrade the database to a different software version.
Given a plan ID, how would you obtain the query execution plan? (Choose two.)
A. Turn ODBC tracing ON.
B. Issue "SELECT * FROM _V_SESSION;"
C. Go to the query history within the Windows NzAdmin GUI tool.
D. Run EXECUTION PLAN before the query has been submitted.
E. Issue "SHOW PLANFILE
The primary copy of a dataslice is spread across how many disks?
A. 1.
B. 2.
C. 4.
D. 12.
Which is NOT a function of the Field Programmable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?
A. Projects
B. Restricts
C. Aggregates
D. Decompresses
Which is NOT a way to check if the database is online?
A. nzstate
B. cat /proc/database
C. nzsystem showState
D. nzsql -c "select * from _v_system_info;"
All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?
A. GUEST
B. USERS
C. PUBLIC
D. GLOBAL
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.