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

質問 1

What ap cli command is used to disable a node?

（A）ap node power off

（B）ap node disable

（C）ap node set__personality fail

（D）ap stopnode

正解：B 解答を投票する

質問 2

What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

（A）nzsqa progress

（B）nzsqa responders

（C）nzsqa schedqueues -sys

（D）nzsqa wlm

正解：B 解答を投票する

質問 3

By default, when are the postgres logs rotated on an IBM Netezza Performance Server?

（A）daily or greater than 1 GB

（B）weekly or greater than 5 GB

（C）hourly or greater than 100 MB

（D）monthly or greater than 10 GB

正解：C 解答を投票する

質問 4

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 a copy of FACT_SALES table with zip_code as integer data type.

（B）CREATE ORGANIZED view for FACT_SALES table

（C）alter table fact_sales to organize on zip_code. followed by groom.

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

正解：B 解答を投票する

質問 5

What command is used to verify the release of IBM Netezza Performance Server Analytics installed?

（A）nzinza

（B）inzarev

（C）nzcm -inza

（D）nzrev --inza

正解：C 解答を投票する

質問 6

When choosing a distribution key for a large fact table, what is a valid choice?

（A）any column with low cardinality

（B）any column used in table constraints

（C）a technical or surrogate key

（D）any date column commonly used in queries

正解：B 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験