Snowpro Certification Exam; Questions with Verified Solutions

Snowpro Certification Exam; Questions with Verified
Solutions
What SQL extension did Snowflake add for use with the Time Travel feature Correct Ans-

AT, UNDROP, BEFORE




Data loading typically requires the use of a XXL Virtual Warehouse. True or False? Correct

Ans-False




On which version of Snowflake is Secure Data Sharing not available Correct Ans-Virtual

Private Snowflake (VPS)




Time Travel is not possible on transient tables. True or false Correct Ans-False




What are the snowflake editions Correct Ans-Enterprise, Standard, Business Critical

Edition, Virtual Private Snowflake (VPS)




If the PURGE copy option were set to TRUE what could happen to data files that are

successfully loaded into Snowflake from an external stage? Correct Ans-They would be

removed from the external stage.

, Snowpro Certification Exam; Questions with Verified
Solutions
The reuse the results cache which of the following requirements must be met? Correct

Ans-- The role executing the query must have the necessary access privileges for all the tables

used in the cached query when executing a SELECT


- The new query exactly matches the cached query




In which state is a Virtual Warehouse billable Correct Ans-STARTED




What level of cardinality is it recommended to a column have when selected in a query that

makes use of a GROUP BY Correct Ans-Low cardinality




What's the maximum number of days a user could set the table property

DATA_RETENTION_TIME_IN_DAYS to for a transient table on a business critical edition

Snowflake account? Choose one correct value Correct Ans-1




Which object does an external function make use of to hold security related information?

Choose one correct value Correct Ans-API Integration

, Snowpro Certification Exam; Questions with Verified
Solutions
Which object does an external function make use of to hold security related information?

Choose one correct value Correct Ans-- PARQUET


- AVRO


- XML


- ORC


- JSON




Snowflake uses the following access control schemas: role based access control (RBAC) and

_____ Correct Ans-Discretionary Access Control (DAC)




A Snowflake user creates a clone of a 'TABLE_A' and names it 'TABLE_B'. When new records

are inserted into 'TABLE A' what is expected to happen to 'TABLE B' Correct Ans-The

inserted records do not show at all in TABLE B




What is the behavior of the COPY INTO <table> command when the ON_ERROR option is set

to CONTINUE? Correct Ans-Load the file if errors are found

, Snowpro Certification Exam; Questions with Verified
Solutions
What is the behavior of the COPY INTO <table> command when the ON_ERROR option is set

to CONTINUE? Correct Ans-FALSE




Which system-defined role is it recommended to assign custom roles to Correct Ans-

SYSADMIN




What do you configure a SHARE object with Correct Ans-- Account identifiers


- Object privileges




Cloning a table copies the underlying data effectively doubling storage costs. True or false?

Correct Ans-False




What attributes make Snowflake a SaaS solution Correct Ans-- No hardware to manage


- Pay for what you use pricing plan




What is the function of the AUTO_SUSPEND property of Virtual Warehouse Correct Ans-

Specifies the number of seconds of inactivity after which a warehouse is automatically

suspended