How does the SKEW factor affect the user’s Perm space, assuming the total space consumed is under the specified perm space limit?

Given a user creation request on a 10-AMP system:

CREATE USER hr_user AS PERM = 100e9 SKEW = 10 PERCENT, SPOOL = 100e9 SKEW = 20 PERCENT;

How does the SKEW factor affect the user’s Perm space, assuming the total space consumed is under the specified perm space limit?
A . The per AMP limit of any AMP can reach 20 GB.
B . The per AMP limit of 100 GB can be breached up to 10 percent.
C . The per AMP limit of 10 GB can be breached to any percent.
D . The per AMP limit of any AMP can reach 11 GET

View Answer

Answer: D

Explanation:

In the given CREATE USER statement, the SKEW = 10 PERCENT parameter applies to Perm space and allows some AMPs (Access Module Processors) to use up to 10% more space than the average allocation across the AMPs.

The user is allocated 100 GB of Perm space across a 10-AMP system, meaning the average space per AMP is 10 GB.

With a 10% skew allowed, this means that an AMP can use up to 10% more than the average allocation, which is 10 GB + 1 GB = 11 GB.