Free Practice Questions for IBM C1000-085 Exam

Which two file formats are valid for external tables?

• text-delimited
• fixed-length
• JSON
• HL7
• XML

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

• It reclaims space from deleted rows and does not re-order data
• Enough space is required for GROOM to make a complete copy of the table
• GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.
• It reclaims space from deleted rows and re-orders data.

Which date time format is used to capture history activities?

• system time
• local time
• EST
• GMT

Which statement is accurate regarding snippets?

• The number of snippets depends on query and complexity.
• Every query is always turned into four snippets.
• Every query is always turned into one snippet.
• The number of snippets is always based on the size of the system.

When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?

• as a client of the storage manager server
• as the primary storage manager server
• as the primary backup target
• as a cloud storage repository

Which two commands can be used to get a plan file for a query?

• nzsql -c 'show planfile '
• nzsql -c 'select plan_text from _v_plan'
• nzsql -c 'get planfile '
• nz_get
• nz_plan

What is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

• SUBORDINATE NODE
• MASTER NODE
• STANDBY NODE
• PRIMARY NODE

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char(5| They frequently restrict on this column, but the query is very inefficient.What is the correct way to optimize this query without modifying the column?

• Create a copy of FACT_SALES table with zip_code as integer data type.
• alter table fact_sales to organize on zip_code. followed by groom.
• CREATE ORGANIZED view for FACT_SALES table
• Create a view with a typecast to integer and use view for query purposes

Which two products or methods can be used for disaster recovery when using IBM Netezza Performance Servers?

• Cloud Pak for Data
• InfoSphere Data Replication
• Netezza Replication Services
• Data Serialization
• NPS Backup and Restore

What command is used to add an event?

• nzevent add
• nzevent insert
• nzevent load
• nzevent create