Snowflake SnowPro Core SnowPro Core Certification Exam Online Training
Snowflake SnowPro Core Online Training
The questions for SnowPro Core were last updated at Jan 07,2025.
- Exam Code: SnowPro Core
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Jan 07,2025
What Snowflake role must be granted for a user to create and manage accounts?
- A . ACCOUNTADMIN
- B . ORGADMIN
- C . SECURITYADMIN
- D . SYSADMIN
A company strongly encourages all Snowflake users to self-enroll in Snowflake’s default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
- A . Okta Verify
- B . Duo Mobile
- C . Microsoft Authenticator
- D . Google Authenticator
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.
- A . True
- B . False
A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?
- A . Organize files into logical paths
- B . Store the files on the external stage to ensure caching is maintained
- C . Use pattern matching for regular expression execution
- D . Load the data in one large file
What SQL command would be used to view all roles that were granted to user.1?
- A . show grants to user USER1;
- B . show grants of user USER1;
- C . describe user USER1;
- D . show grants on user USER1;
How often are encryption keys automatically rotated by Snowflake?
- A . 30 Days
- B . 60 Days
- C . 90 Days
- D . 365 Days
The FLATEEN function is used to query which type of data in Snowflake?
- A . Structured data
- B . Semi-structured data
- C . Both of the above
- D . None of the above
Which of the following is true of Snowpipe via REST API? Choose 2 answers
- A . you can only use it on internal Stages
- B . All COPY INTO options are available fluting pipe creation
- C . Snowflake automatically manages the compute required to execute the Pipe’s copy into commands
- D . Snowpipe keeps track of which files it has loaded
Which statement about billing applies to Snowflake credits?
- A . Credits are billed per-minute with a 60-minute minimum
- B . Credits are used to pay for cloud data storage usage
- C . Credits are consumed based on the number of credits billed for each hour that a warehouse runs
- D . Credits are consumed based on the warehouse size and the time the warehouse is running
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A . Is available to all Snowflake Editions
- B . Is only available to customers with Business Critical Edition
- C . Restricts or enables access to specific IP addresses
- D . Is activated using an “ALTER DATABASE” command
Latest SnowPro Core Dumps Valid Version with 427 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
