C1000-085試験無料問題集（62題）「IBM Netezza Performance Server V11.x Administrator 認定」

出題：1

Which statement regarding drive failure is true?

A. Queries and transactions are interrupted by drive failure because there is no drive mirroring for drives.

B. Running queries and transactions will finish, but new transactions will not be allowed till drive is changed.

C. Queries and transactions are not interrupted in the event of a drive failure.

D. Queries and transactions are not interrupted by drive failure if their data is not on the failed drive.

正解：D 解答を投票する

出題：2

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?

A. CREATE ORGANIZED view for FACT_SALES table

B. alter table fact_sales to organize on zip_code. followed by groom.

C. Create a copy of FACT_SALES table with zip_code as integer data type.

D. Create a view with a typecast to integer and use view for query purposes

正解：A 解答を投票する

出題：3

Which two external methods can IBM Netezza Performance Server use to authenticate database users?

A. Radius

B. PKI-Based

C. LDAP

D. Kerberos

E. SSH

正解：B,C 解答を投票する

出題：4

What are two primary purposes of UDX?

A. to accelerate analysis by processing data in-database

B. to force execution only on the SPU nodes

C. it is a required component of all Netezza SQL commands

D. to showcase one's capability to write UDX code to duplicate existing SQL functions

E. to offer new and unique types of analyses through customized code

正解：A,D 解答を投票する

出題：5

What ap cli command is used to disable a node?

A. ap node disable

B. ap node power off

C. ap stopnode

D. ap node set__personality fail

正解：A 解答を投票する

出題：6

Which two command line support tools are used to determine the order of data for a given table?

A. nz_zonemap

B. nz_physical_table_layout

C. nz_sort_order

D. nz_get

E. nz_pagemap

正解：A,E 解答を投票する

C1000-085試験無料問題集「IBM Netezza Performance Server V11.x Administrator 認定」