Snowflake SnowPro Core - Practice Exam 1
The SnowPro ™ Core Certification demonstrates an individual's knowledge to apply specific core expertise in implementing and migrating to Snowflake. A SnowPro ™ Core Certified individual has a thorough understanding of the Snowflake Cloud Data Platform and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives.
PDF Exam Questions
Cheat Sheet
Q1
Is re-clustering in Snowflake only triggered if the table would benefit from the operation?
Q2
What are the usual data loading steps in Snowflake?
Q3
How will you store JSON data in Snowflake?
Q4
Do tables with Fail-Safe turned on incurs additional storage costs compared to tables where Fail-Safe is turned off?
Q5
In which of the below scenarios is Snowpipe recommended to load data?
Q6
What technique does Snowflake use to limit the number of micro-partitions retrieved as part of a query?
Q7
Which command will we use to download the files from the stage/location loaded through the COPY INTO <LOCATION> command?
Q8
Can virtual warehouses be resized while they are running?
Q9
For which activities does Snowflake have administration settings to help with resource consumption?
Q10
Does GET support downloading files from external stages?
Q11
A query executed a couple of hours ago, which spent more than 5 minutes to run, is executed again, and it returned the results in less than a second. What might have happened?
Q12
Which table function allows you to convert semi-structured data to a relational representation?
Q13
What are the different stages available in Snowflake?
Q14
Compute cost in Snowflake depends on…
Q15
Can you resize the warehouse once you have selected the size?
Q16
Do UDFs support both SQL & JavaScript in Snowflake?
Q17
You have two virtual warehouses in your Snowflake account. If one of them updates the data in the storage layer, when will the other one see it?
Q18
Select the term that is associated with the compute layer:
Q19
What property from the Resource Monitors lets you specify whether you want to control the credit usage of your entire account or a specific set of warehouses?
Q20
You have two types of named stages, one is an external stage, and the other one is an internal stage. Will external stages always require a cloud storage provider?
Q21
Is clustering generally more cost-effective for tables that are queried frequently and do not change often?
Q22
Which cloud provider is not supported by Snowflake?
Q23
Is shared data always available to Consumer Accounts?
Q24
Which function returns the name of the warehouse of the current session?
Q25
How is query processing done in Snowflake?
Q26
Can two different virtual warehouses from the same account access the same data simultaneously without any contention issue?
Q27
What are the names of the three main Snowflake layers?
Q28
Which Snowflake cache runs for 24 hours?
Q29
Which is the minimum Snowflake edition that allows until 90 days of Time Travel?
Q30
What is the name of Snowflake’s Command Line Interface tool?
Q31
Does data stored in a temporary table not contribute to Snowflake’s storage cost?
Q32
What should be the first option to restore data into a table?
Q33
Does Snowflake support Nested Transactions?
Q34
Is Snowflake available on-premise?
Q35
Which of the below APIs are Snowpipe REST APIs?
Q36
Can a Warehouse be assigned to more than one Resource Monitor?
Q37
What are the two types of data consumer accounts available in Snowflake?
Q38
Do you need to contact Snowflake Support to retrieve data from Fail-Safe?
Q39
What types of views are available in Snowflake?
Q40
When staging uncompressed files in a Snowflake stage, are the files automatically compressed using gzip unless compression is explicitly disabled?
Q41
A medium (M) warehouse has auto-suspend configured after 15 minutes. You have noticed that all of the queries that run on this warehouse finish within a minute. What will you do to optimize compute costs?
Q42
Is Snowpipe serverless?
Q43
Are Snowflake caches automatically invalidated if the underlying data changes?
Q44
Which of the following roles are System-Defined Roles in Snowflake?
Q45
What are the different caching mechanisms available in Snowflake?
Q46
Which Snowflake object stores a generated identity and access management (IAM) entity for your external cloud storage and an optional set of allowed or blocked storage locations (such as Amazon S3, Google Cloud Storage, or Microsoft Azure)?
Q47
What statements are true about streams in Snowflake?
Q48
Can you load data using the PUT command through worksheets in the Snowflake UI?
Q49
What types of tables are available in Snowflake?
Q50
In which layer of Snowflake architecture is stored all security-related information?
Q51
Can a Reader Account become a Provider of Listings in the Snowflake Marketplace?
Q52
Select two limitations with materialized views:
Q53
What statement is true about Snowflake’s unique architecture?
Q54
Which certifications are compliant with Snowflake?
Q55
Which of the following statements about micro-partitions in Snowflake are correct?
Q56
What happens to the incoming queries when a warehouse does not have enough resources to process them?
Q57
Which of the following roles can create shares and resource monitors?
Q58
What actions can the resource monitor associated with a Warehouse take when it reaches (or is about to) hit the limit?
Q59
Which are the additional columns that the streams create?
Q60
Which character identifies a table stage?
Q61
Which of the following services are provided by the Cloud Services Layer?
Q62
What can you easily check to see if a large table will benefit from explicitly defining a clustering key?
Q63
Select the statements that are true about Fail-Safe:
Q64
What different types of streams exist in Snowflake?
Q65
Which data-loading method requires a user-specified warehouse to execute COPY statements?
Q66
Which type of data incurs in Snowflake storage costs?
Q67
Does Snowflake automatically stores data in encrypted form in all editions?
Q68
What will happen to the child task if you remove its predecessor?
Q69
Which of the following properties of a Resource Monitor can be modified?
Q70
Queries in Snowflake are getting queued on the warehouses and delaying the ETL processes of the company. What are the possible solution options you can think of, considering we have the Snowflake Enterprise addition?
Q71
Which factors influence the unit cost of snowflake credits and data storage?
Q72
Which are the two metadata columns for staged files?
Q73
If you want to create a multi-cluster warehouse, which is the lowest Snowflake edition that you should opt for?
Q74
Which Snowflake object returns a set of rows instead of a single, scalar value, and can be accessed in the FROM clause of a query?
Q75
If you want a dedicated virtual warehouse, which is the lowest Snowflake edition you should opt for?
Q76
Can we query data stored in Amazon S3 without loading it on a Snowflake table?
Q77
Which system functions are available in Snowflake to view/monitor the clustering metadata for a table?
Q78
After how many days does the load history of Snowpipe expire?
Q79
What influences Snowflake pricing? (SELECT ONLY ONE)
Q80
Select the true statements about Snowflake tasks:
Q81
Which database objects can be shared using Snowflake Secure Data Sharing?
Q82
After how many days does the COPY INTO load metadata expire?
Q83
Does Snowpipe guarantee that files are loaded in the same order they are staged?
Q84
Which of the following commands cannot be executed from the Snowflake UI?
Q85
Which character identifies a user stage?
Q86
To improve the performance, which of the below techniques can be used in Snowflake?
Q87
While loading data through the COPY command, you can transform the data. Which of the below transformations are allowed?
Q88
We need to temporarily store intermediate data, which an ETL process will only use. We don't need the data outside the ETL process. If you want to optimize storage cost, what type of table will you create to store this data?
Q89
Which service does Snowflake use to provide the Zero-Copy cloning functionality?
Q90
What actions can a Resource Monitor perform when it hits the limit?
Q91
Which of the following options are true about roles in Snowflake?
Q92
What option will you specify to delete the stage files after a successful load into a Snowflake table with the COPY INTO command?
Q93
What techniques would you consider to improve the performance of a query that takes a lot of time to return any result?
Q94
How is the data storage cost computed for Snowflake?
Q95
In which of the below scenarios will you use an external table?
Q96
Which command will you run to list all users and roles to which a role has been granted?
Q97
A warehouse ran for 62 seconds, and it was suspended. After some time, it ran for another 20 seconds. For how many seconds will you be billed?
Q98
Which of the following clustering metadata for the micro-partitions is maintained by Snowflake in a table?
Q99
If a transaction disconnects and goes into a detached state, which cannot be committed or rolled back, how long will Snowflake take to abort the transaction?
Q100
Which Snowflake edition supports private communication between Snowflake and your other VPCs through AWS PrivateLink?