
Snowflake SnowPro Core - Practice Exam 3
What is the default value for the Time Travel functionality?
In which different ways can we query historical data?
How many warehouse credits will consume the following command?
SELECT COUNT(*)
FROM MYTABLE;
Can the cost of computing and storage vary depending on some characteristics like the account location or the capacity options of your account (on-demand or pre-paid)?
Do micro-partitions change after being created?
What is SnowSQL?
Can we consider Snowflake an OLAP or OLTP service?
What would be the output if you create a sequence with a starting value of 1 and an increment of 4?
Which types of users can use the query profile functionality in the Snowflake UI?
Do transient tables support fail-safe?
How can we select the maximized mode for multi-cluster warehouses?
Is the ACCOUNTADMIN role forced to enable MFA in its account?
Which command can we use to restore a deleted table on Snowflake?
Does SnowSQL support multi-factor authentication-based login?
In which type of Cloud Computing Type can we classify Snowflake?
Which Snowflake objects are automatically created by default every time you create a database?
What is the main function of Business Intelligence tools (e.g., Tableau or Quicksight)?
Is scaling up a virtual warehouse an automatic process?
Does Snowflake support direct querying on data that is stored in AWS?
What is the main function of Data Integration tools (e.g., Fivetran or Stitch)?
Which of these features is NOT supported by Snowflake?
Does Snowflake support data unloading in external stages?
Which property helps us control the credits consumed by a multi-cluster warehouse?
What are the two main differences between views and materialized views?
What of the following file formats can we use to load semi-structured data on Snowflake?
Should the ACCOUNTADMIN roles be associated with an actual person’s email address?
Which planned/scheduled release does Snowflake deploy every week?
Can we use streams to track changes in materialized views?
Can worksheets of the Snowflake UI have a different role, warehouse, and database?
Can we use Multi-factor Authentication to connect to Snowflake via the Snowflake JDBC driver?
Can a Store Procedure not return anything?
Does every user in Snowflake get the ‘PUBLIC’ role by default?
Are we forced to run the ALTER WAREHOUSE … RESUME command before doing any query?
Which of the following file formats is not supported by Snowflake?
What types of releases can we find in Snowflake?
Can we load files into Snowflake using the UI?
Which of these conditions must be met to be able to upload our datasets to the Snowflake Marketplace?
Is the Snowflake warehouse cache available after suspending the warehouse?
Which of the following object types are stored within a schema?
You have all your data in AWS S3, but you’ve created your Snowflake account using Azure. Are you able to query the data from AWS S3?
Which of the following file formats are supported by Snowflake?
What are the two major cost categories in Snowflake? (SELECT TWO)
What are the two types of partners in the Snowflake ecosystem?
Are UDFs, UDTFs, and Stored Procedures account or schema-level objects in Snowflake?
Which cache can also be referred to as SSD or local cache?
Can a UDF not return anything?
Is scaling out a virtual warehouse an automatic process?
Must all tasks in a tree of tasks be in the same schema?
Is auto-resume enabled by default in Snowflake data warehouses?
In which editions can we configure MFA Authentication?
Which of these reasons make Snowflake a “SaaS” product?
What different ways do we have to connect to Snowflake?
What options do you have if you want to connect an application to Snowflake that doesn’t appear in the Snowflake partner products ecosystem?
What types of constraints from the ANSI SQL Standard does Snowflake provide?
Which cache is never dumped, and it’s always up-to-date?
Which Snowflake object stores DML change made to tables and metadata about each change?
Which of the following objects are inside a Database?
What is the function of the PUBLIC schema in Snowflake?
How can we restart a warehouse that has been suspended because of a Resource Monitor action?
Are Snowflake transactions BASE compliant?
In which Programming Languages can we extend the Snowflake functionality by creating User-Defined Functions?
When is effective the maximized mode for multi-cluster warehouses?
Can Snowflake transactions span across multiple user sessions?
Does the SAMPLE_DATA share incur storage charges for your account?
You have the following data in a variant column called “person_data” from the table “myTable”. How can you query the second hobby of Gonzalo (“music”)?
{
"name": "Gonzalo",
"country": "Spain",
"favouriteTechnology": Snowflake,
"hobbies":[
{"name": "soccer"},
{"name": "music"},
{"name": "hiking"}
]}
What is the minimum billing charge for a virtual warehouse?
Which roles can create, alter or drop network policies?
What statements are true about the Snowflake History Page?
Can you share a non-secure view in an outbound share?
Does Snowflake support SSO (Single Sign-On)?
What are the two models that Snowflake combines as an approach to access control?
In which Snowflake edition(s) are the Snowflake Marketplace available?
What are the different types of listings in the Snowflake Data Marketplace?
What are the supported values for the Resource Monitor Interval?
What is the maximum size supported by the VARIANT column?
Snowflake's approach to access control combines aspects of two different models. One model remarks, "access privileges are assigned to roles, which are in turn assigned to users". What is the name of this model?
Which command can we use to access sequences in queries as expressions?
Are the running warehouses suspended immediately when a Resouce Monitor triggers the “Notify and Suspend” event?
Which file formats are supported by Snowflake to unload data?
Which factors influence the cost of a Snowflake Credit and data storage?
A task is still being executed before the next scheduled task. What is going to happen with the new scheduled task?
What do you need to take into account to open a Snowflake account?
What is the maximum number of clusters in a multi-cluster warehouse?
What is the Snowflake network policy by default?
Are Multi-cluster warehouses effective in improving individual queries’ performance?
What types of functionalities can a Full release include?
What types of constraints from the ANSI SQL Standard does Snowflake enforce?
When is effective the auto-scale mode for multi-cluster warehouses?
Is Federated authentication compliant with SAML2.0 in Snowflake?
In which Snowflake edition(s) is the Snowflake Data Exchange available?
By default, how many inbound share(s) have every Snowflake account?
Which of these statements are correct?
Is query load calculated by dividing the execution time (in seconds) of all queries in an interval by the total time (in seconds) for the interval?
How many cluster keys can we create for a Snowflake table?
What data can we infer from the following Snowflake URL?
https://ab12345.us-east-1.snowflakecomputing.com
Which best practices would you do to increase the performance of a data ingestion workload?
Will a user created using the following syntax be able to access the tables that are only available for the SYSADMIN role?
CREATE ROLE MYROLE;
GRANT ROLE MYROLE TO ROLE SYSADMIN;
CREATE USER MYUSER PASSWORD=’ABC123’ DEFAULT_ROLE=MYROLE
MUST_CHANGE_PASSWORD=TRUE;
Which privileges does a role need to clone a table?
Changes in the size of a warehouse will impact the following ways for large, complex, and long-running queries:
Which command can we use to query the table <my_table> as it was 15 minutes ago?