SnowPro Core Certification Exam
SnowPro Core Free Questions
When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.
A. The Pipe load history is reset to empty
B. The REFRESH parameter is set to TRUE
C. Previously loaded files will be ignored
D. All of the above
Select the different types of Internal Stages: (Choose three.)
A. Named Stage
B. User Stage
C. Table Stage
D. Schema Stage
Which statement best describes Snowflake tables?
A. Snowflake tables are logical representations of underlying physical data
B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake
C. Snowflake tables require that clustering keys be defined to perform optimally
D. Snowflake tables are owned by a user
What happens when a Data Provider revokes privileges to a Share on an object in their source
A. The object immediately becomes unavailable for all Data Consumers
B. Any additional data arriving after this point in time will not be visible to Data Consumers
C. The Data Consumers stop seeing data updates and become responsible for storage charges for the
D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers'
Which of the following statements about data sharing are true? choose 2 answers
A. New objects created by a Data Provider are automatically shared with existing Data Consumers &
B. All database objects can be included In a shared database
C. Reader Accounts are created and funded by Data Prowlers
D. Shared databases are read-only
Which of the following statements is true of Snowflake?
A. It was built specifically for the cloud
B. It was built as an on-premises solution and then ported to the cloud
C. It was designed as a hybrid database to allow customers to store data either on premises or in the
D. It was built for Hadoop architec