Snowflake SnowPro Core SnowPro Core Certification Exam Online Training
Snowflake SnowPro Core Online Training
The questions for SnowPro Core were last updated at Jan 06,2025.
- Exam Code: SnowPro Core
- Exam Name: SnowPro Core Certification Exam
- Certification Provider: Snowflake
- Latest update: Jan 06,2025
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A . True
- B . False
Which are true of Snowflake roles?
- A . All grants to objects are given to roles, and never to users
- B . In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
- C . The public role controls at other roles
- D . Roles are a subset of users and users own objects In Snowflake
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
- A . 1 Hour
- B . 3 Hours
- C . 12 hours
- D . 24 hours
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A . Pipe
- B . External stage
- C . Task
- D . Stream
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers
- A . Their default role should be set to SYSTEMADMIN (the lower of the two)
- B . They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
- C . They should only access and ‘step into’ the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
- D . They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
- E . They should use the SYSADMIN role to perform administrative work on database objects
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
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the
data.
- A . True
- B . False
What is the MOST performant file format for loading data in Snowflake?
- A . CSV (Unzipped)
- B . Parquet
- C . CSV (Gzipped)
- D . ORC
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A . True
- B . False
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
- A . True
- B . False
Latest SnowPro Core Dumps Valid Version with 427 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
