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.
Is re-clustering in Snowflake only triggered if the table would benefit from the operation?
What are the usual data loading steps in Snowflake?
How will you store JSON data in Snowflake?
Do tables with Fail-Safe turned on incurs additional storage costs compared to tables where Fail-Safe is turned off?
In which of the below scenarios is Snowpipe recommended to load data?
What technique does Snowflake use to limit the number of micro-partitions retrieved as part of a query?
Which command will we use to download the files from the stage/location loaded through the COPY INTO <LOCATION> command?
Can virtual warehouses be resized while they are running?
For which activities does Snowflake have administration settings to help with resource consumption?
Does GET support downloading files from external stages?
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?
Which table function allows you to convert semi-structured data to a relational representation?
What are the different stages available in Snowflake?
Compute cost in Snowflake depends on…
Can you resize the warehouse once you have selected the size?
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?
Select the term that is associated with the compute layer:
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?
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?
Is clustering generally more cost-effective for tables that are queried frequently and do not change often?
Which cloud provider is not supported by Snowflake?
Is shared data always available to Consumer Accounts?
Which function returns the name of the warehouse of the current session?
How is query processing done in Snowflake?
Can two different virtual warehouses from the same account access the same data simultaneously without any contention issue?
The three main Snowflake layers are…
Which cache runs for 24 hours?
Which Snowflake edition (and above) allows until 90 days of Time Travel?
What is the name of Snowflake’s Command Line Interface tool?
Does data stored in a temporary table not contribute to Snowflake’s storage cost?
What should be the first option to restore data into a table?
Does Snowflake support Nested Transactions?
Is Snowflake available on-premise?
Which of the below APIs are Snowpipe REST APIs?
Can a Warehouse be assigned to more than one Resource Monitor?
What are the two types of data consumer accounts available in Snowflake?
Do you need to contact Snowflake Support to retrieve data from Fail-Safe?
What types of views are available in Snowflake?
When staging uncompressed files in a Snowflake stage, are the files automatically compressed using gzip unless compression is explicitly disabled?
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?
Is Snowpipe Serverless?
Are Snowflake caches automatically invalidated if the underlying data changes?
Which of the following roles are System-Defined Roles in Snowflake?
What are the different caching mechanisms available in Snowflake?
Which Snowflake object stores a generated identity and access management (IAM) entity for your external cloud storage, along with an optional set of allowed or blocked storage locations (Amazon S3, Google Cloud Storage, or Microsoft Azure)?
What statements are true about streams?
Can you load data using the PUT command through worksheets in the Snowflake UI?
What types of tables are available in Snowflake?
In which layer of Snowflake architecture is stored all security-related information?
Can a Reader Account become a Provider of Listings in the Snowflake Marketplace?
Select two limitations with materialized views:
What statement is true about Snowflake’s unique architecture?
Which certifications are compliant with Snowflake?
Which statements are correct about micro-partitions in Snowflake?
What happens to the incoming queries when a warehouse does not have enough resources to process them?
Which roles can create shares and resource monitors?
What actions can the resource monitor associated with a Warehouse take when it reaches (or is about to) hit the limit?
Which are the additional columns that the streams create?
Which character identifies a table stage?
Which of the following services are provided by the Cloud Services Layer?
What can you easily check to see if a large table will benefit from explicitly defining a clustering key?
Select the statements that are true about Fail-Safe:
What different types of streams exist in Snowflake?
Which data-loading method requires a user-specified warehouse to execute COPY statements?
Which type of data incurs in Snowflake storage costs?
Does Snowflake automatically stores data in encrypted form in all editions?
What will happen to the child task if you remove its predecessor?
Which properties of a Resource Monitor can be modified?
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?
Which factors influence the unit cost of snowflake credits and data storage?
Which are the two metadata columns for staged files?
If you want a multi-cluster warehouse, which is the lowest Snowflake edition that you should opt for?
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?
If you want a dedicated virtual warehouse, which is the lowest Snowflake edition you should opt for?
Can we query data stored in AWS S3 without loading it on a Snowflake table?
Which system functions are available in Snowflake to view/monitor the clustering metadata for a table?
After how many days does the load history of Snowpipe expire?
What influences Snowflake pricing? (SELECT ONLY ONE)
Select the true statements about Snowflake tasks:
Which database objects can be shared using Snowflake Secure Data Sharing?
After how many days does the COPY INTO load metadata expire?
Does Snowpipe guarantee that files are loaded in the same order they are staged?
Which of the following commands cannot be executed from the Snowflake UI?
Which character identifies a user stage?
To improve the performance, which of the below techniques can be used in Snowflake?
While loading data through the COPY command, you can transform the data. Which of the below transformations are allowed?
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?
Which service does Snowflake use to provide the Zero-Copy cloning functionality?
What actions can a Resource Monitor perform when it hits the limit?
Which of the following options are true about roles in Snowflake?
What option will you specify to delete the stage files after a successful load into a Snowflake table with the COPY INTO command?
What techniques would you consider to improve the performance of a query that takes a lot of time to return any result?
How is the data storage cost computed for Snowflake?
In which of the below scenarios will you use an external table?
Which command will you run to list all users and roles to which a role has been granted?
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?
Which of the following clustering metadata for the micro-partitions is maintained by Snowflake in a table?
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?
Which Snowflake edition supports private communication between Snowflake and your other VPCs through AWS PrivateLink?