True or False: You can resize a Virtual Warehouse while queries are running.
A.
True
B.
False
True
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
True or False: The COPY command must specify a File Format in order to execute.
A.
True
B.
False
True
Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-intosnowflake/
Which of the following languages can be used to implement Snowflake User Defined
Functions (UDFs)?
Choose 2 answers
A.
Java
B.
JavaScript
C.
SQL
D.
Python
JavaScript
SQL
Reference: https://docs.snowflake.com/en/sql-reference/user-defined-functions.html
What services does Snowflake automatically provide for customer that they may have been
responsible for with their on premise system? Select all the below that apply.
A.
Installing and configuring hardware
B.
Patching software
C.
Physical security
D.
Maintaining metadata and statists
Installing and configuring hardware
Patching software
Maintaining metadata and statists
True or False: A third-party tool that supports standard JDBC or ODBC but has no
Snowflake-specific driver will be unable to connect to Snowflake.
A.
True
B.
False
False
Reference: https://docs.snowflake.com/en/user-guide-connecting.html
A role is created and owns 2 tables. This role is then dropped. Who will now own the two
tables?
A.
The tables are now orphaned
B.
The user that deleted the role
C.
SYSADMIN
D.
The assumed role that dropped the role
The assumed role that dropped the role
Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html
True or False: Micro-partition metadata enables some operations to be completed without
requiring Compute.
A.
True
B.
False
True
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/
Which statement best describes '' clustering''?
A.
Clustering represents the way data is grouped together and stored within snowflake's
micro-partitions
B.
The database administrator must define the clustering methodology for each Snowflake
table.
C.
The clustering key must be included on the COPV command when loading data into
Snowflake.
D.
Clustering can be disabled within a Snowflake account.
Clustering represents the way data is grouped together and stored within snowflake's
micro-partitions
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
True or False: It is possible to load data into Snowflake without creating a named File
Format object.
A.
True
B.
False
True
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-
True or False: Fail-safe can be disabled within a Snowflake account.
A.
True
B.
False
True
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Which interfaces can be used to create and/or manage Virtual Warehouses?
A.
The Snowflake Web Interface (UI)
B.
SQL commands
C.
Data integration tools
D.
All of the above
All of the above
Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers
A.
Amazon Web Services
B.
Private Virtual Cloud
C.
Oracle Cloud
D.
Microsoft Azure Cloud
Amazon Web Services
Microsoft Azure Cloud
| Page 5 out of 14 Pages |
| 34567 |
| SnowPro-Core Practice Test Home |
Real-World Scenario Mastery: Our SnowPro-Core practice exam don't just test definitions. They present you with the same complex, scenario-based problems you'll encounter on the actual exam.
Strategic Weakness Identification: Each practice session reveals exactly where you stand. Discover which domains need more attention, before SnowPro Core Certification Exam exam day arrives.
Confidence Through Familiarity: There's no substitute for knowing what to expect. When you've worked through our comprehensive SnowPro-Core practice exam questions pool covering all topics, the real exam feels like just another practice session.
Copyright © All Rights Reserved