최신 SnowPro-Core 무료덤프 - Snowflake SnowPro Core Certification

A. The user should use federated authentication instead of a password

B. The ACCCUKTMKIN role should be set as tie user's default role.

C. There should be just one user with the ACCOUNTADMIN role in each Snowflake account.

D. The user should be required to use Multi-Factor Authentication (MFA).

A. Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

B. Per second multiplied by an automatic sizing for the job

C. Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

D. Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

A. RETURN ALL ERRORS

B. RETURN_-1_R0WS

C. RETURN_n_ROWS

D. RETURN_ERRORS

A. Pipe

B. Virtual warehouse

C. Resource monitor

D. Storage integration

E. File format

A. CREATE USER

B. OWNERSHIP

C. SELECT

D. MODIFY

E. GRANT

A. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

B. There is no need to have a Snowflake account in the target region, a share will be created for each user.

C. The listing is replicated into all selected regions automatically, the data is not.

D. Shares attached to listings in remote regions can be viewed from any account in an organization.

E. The user must have the ORGADMIN role available in at least one account to link accounts for replication.

A. Transient

B. User

C. Temporary

D. Local

A. The columns that are queried in the select clause.

B. The columns with very high cardinality.

C. The columns most actively used in the select filters.

D. The columns with many different values.

A. It converts null values to empty strings during loading.

B. It skips rows with null values during the loading process.

C. It removes null values from all columns in the data.

D. It removes object or array elements containing null values.

A. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

B. ALTER FILE FORMAT my_format SET TYPE=JSON;

C. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

D. REPLACE FILE FORMAT my format TYPE-JSON;

A. Clustering

B. Indexing

C. Using INDEX__HINTS

D. Fragmenting

A. All child objects with an explicit retention period will be overridden with the new retention period.

B. All explicit child object retention periods will remain unchanged.

C. All child objects will retain data for the new retention period.

D. All child objects that do not have an explicit retention period will automatically inherit the new retention period.