SnowPro-Core Practice Questions

A.  

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B.  

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C.  

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D.  

Users who are trying to use the warehouse will receive an error message until the resizing is complete

A.  

Snowflake parameters

B.  

Micro-partitions

C.  

Query history

D.  

Persisted query results

E.  

Standard and secure view results

A.  

Each Snowflake account can be hosted in a different cloud vendor and region.

B.  

Each Snowflake account must be hosted in a different cloud vendor and region

C.  

All Snowflake accounts must be hosted in the same cloud vendor and region

D.  

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

A.  

When dropping an external stage, the files are not removed and only the stage is dropped

B.  

When dropping an external stage, both the stage and the files within the stage are removed

C.  

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

D.  

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

E.  

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

A.  

Create the custom role using the SYSADMIN role.

B.  

Assign the custom role to the SYSADMIN role

C.  

Assign the custom role to the PUBLIC role

D.  

Add__CUSTOM to all custom role names

A.  

Configure the user to be initially disabled.

B.  

Force an immediate password change.

C.  

Set a default role for the user.

D.  

Set the number of minutes to unlock to 15 minutes.

E.  

Set the user's access to expire within a specified timeframe.

A.  

Yes, because a table owner has full control and can unset masking policies.

B.  

Yes, because masking policies only apply to cloned tables.

C.  

No, because masking policies must always reference specific access roles.

D.  

No, because ownership of a table does not include the ability to change masking policies

A.  

Gathering the hourly credit usage for an account

B.  

Compiling an account's average cloud services cost over the previous month

C.  

Summarizing the throughput of Snowpipe costs for an account

D.  

Calculating the funds left on an account's contract

A.  

Custom Edition

B.  

Virtual Private Snowflake

C.  

Business Critical Edition

D.  

Standard Edition

E.  

Enterprise Edition

A.  

STRIP_NULL_VALUES

B.  

SKIP_BYTE_ORDER_MARK

C.  

REPLACE_INVALID_CHARACTERS

D.  

VALIDATION_MODE