QUESTION: 341

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

In the metadata of the target table for 14 days
In the metadata of the pipe for 14 days
In the metadata of the target table for 64 days
In the metadata of the pipe for 64 days

Answer(s): C

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

SHOW GRANTS ON ROLE DATA_SCIENCE
SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
SHOW GRANTS TO USER INQUISITIVE_PERSON
SHOW GRANTS OF ROLE DATA_SCIENCE

Answer(s): B

Reveal Solution Next Question

QUESTION: 343

Which of the following are characteristics of security in Snowflake?

Account and user authentication is only available with the Snowflake Business Critical edition.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Answer(s): C

Reveal Solution Next Question

QUESTION: 344

Which of the following objects can be shared through secure data sharing?

Masking policy
Stored procedure
Task
External table

Answer(s): D

Reveal Solution Next Question

Free SnowPro Core Exam Braindumps (page: 86)

QUESTION: 341

QUESTION: 342

QUESTION: 343

QUESTION: 344