Udemy Snowpro Core Certification - Practice Questions Test 1
Which of the following best describes "Bytes spilled to remote storage" shown in a query profile?
"Bytes Spilled to remote storage" indicates that the volume of data could not fit in either the memory or the temporary storage of the virtual warehouse and had to be spilled to temporary cloud storage.
Which of the following statements about Materialized Views is correct?
- A Snowflake service that is invisible to users automatically maintains materialized views in the background. - Materialized views are used to boost query performance. They pre-compute query results and physically store them - A materialized view can provide pre-computed answers, enabling some queries to be answered faster.
Which of the following statements is true regarding the SYSADMIN role?
- A user with the SYSADMIN role can create a new database - A user with the SYSADMIN role can create a new virtual warehouse
Which of the following could be used as a remote service for an external function?
- AWS Lambda Function - Node.js running on an EC2 instance - Microsoft Azure Function
Query Result Cache can be turned off at which levels? (USE_CACHED_RESULT)
- Account - User - Session
Which of the following privileges allows a user in a consumer account to create a database from a share?
- Account admin role - Import share privileges
Which of the following statements are true regarding External Tables?
- An external table can be joined with other tables. - You can query an external table just like a regular table. - The data for a external table is stored in cloud storage managed by the customer - An external table supports only external stages
Which of the following Snowflake editions support database failover and failback between Snowflake accounts, thus providing business continuity and disaster recovery?
- Business Critical - VPS
Which of the following statements is true regarding the ACCOUNTADMIN role?
- Can create & manage resource monitors - Full access rights and is the most powerful account
Which of the following statements about micro-partitions is correct?
- Column values may overlap across micro-partitions - Micro-partitions are created and added to a table in the order that new data arrives
Which of the following is true regarding data encryption when using PUT to upload data to a Snowflake internal stage?
- Data is stored encrypted in the Snowflake internal stage - Data is encrypted automatically at the client machine before being transmitted to the Snowflake internal stage
Snowflake is compliant with which of the following standards?
- FedRAMP - IRAP - Protected - PCI-DSS - HIPAA
Multi-factor authentication can be enabled for which of the following?
- JDBC - SnowSQL -Snowflake WebUI
Which of the following statement is true regarding key pair authentication in Snowflake?
- Key pari auth consists of a private key and one or two public keys - Key pair auth is an alternative to simple username/password auth
Which of the following are caching mechanisms in Snowflake?
- Metadata caching - Warehouse caching - Query result caching
Which of the following transformations are NOT supported by the COPY command?
- SUM - JOIN - GROUP BY
Snowflake UDFs can be broadly categorized into which two based on how they return data.
- Scalar UDFs (one row for each input row, with each output row containing a single column or value) - Table UDFs (return 0, 1, or several rows for reach input, with each result row containing multiple columns)
How does a secure UDF differ from a different typical UDF?
- Secure UDFs don't allow unauthorized users to see the UDF definition - Secure UDF does not use specific SQL
A stored procedure can return which type of results?
- Single Value - Tabular Data
Which of the following statement is correct regarding Snowflake billing?
- Snowflake billing is based on the actual used storage - If a virtual warehouse is suspended, it does not contribute to the cost
Which of the following statements accurately describes Snowflake's encryption for data at rest?
- Snowflake rekeys encrypted data after 1 year - Every 30 days, Snowflake rotates the keys used for encryption - Snowflake manages encryption keys by default
You are unloading data from a multi-gigabyte table to an external stage; which of the following statements regarding the exported file(s) are correct? Select all that apply.
- The data is exported to multiple files. - The exported file(s) are compressed. - Each exported file is 16MB in size.
Which of the following statement is true regarding the Query Processing Layer?
- The query processing layer can run multiple compute clusters (virtual warehouses) simultaneously - The query processing layer is responsible for executing queries
Which of the following correctly describes the query profile shown? QUERY RESULT REUSE[0] 1005
- The query profile indicates that results produced by a previous query were reused - The query profile indicates that an active virtual warehouse was NOT required for this query
Cloning a schema will clone which of the following.
- The schema itself - All other cloneable objects in the schema - All tables in the schema
Which of the following criteria must be met for Snowflake to reuse the query result cache for a query?
- The table micro-partitions have NOT altered as a result of reclustering or consolidation. - The query does not make use of runtime functions. - The underlying data that contributes to the query results has remained unchanged. - The query makes no use of user-defined or external functions. - A new query matches an old query.
Which query profile results indicate that a large table may not be well clustered?
- The value in the 'Partitions Total' qual 'Partitions Scanned' - A significant value for 'Partitions Scanned'
Which of the following statements are correct regarding Time Travel & fail-safe storage?
- There is no fail-safe storage for a transient table - The max allowed time travel duration for a transient table is 1 day
Snowflake provides which of the following drivers?
.NET driver for Snowflake JDBC driver for Snowflake PHP PDO driver Snowflake driver for the Go language ODBC driver for Snowflake Snowflake has several drivers and connectors that can be used to connect to your Snowflake instance.
For how long a query remains visible on the query history page in the Snowsight interface?
14 days
The usage data provided through the INFORMATION SCHEMA has a retention of how many days?
7 days - 6 months
What is a snowflake resource monitor?
A resource monitor can be used to monitor credit usage by virtual warehouses and the cloud services needed to support those warehouses. If desired, the warehouse can be suspended when it reaches a credit limit. The number of credits consumed depends on the size of the warehouse and how long it runs.
Which of the following Snowflake Editions support Time Travel?
All
Which of the following can create a new resource monitor?
An account administrator (i.e.,m a person with the ACCOUNTADMIN role)
Snowflake can load data staged in which of the following?
Azure Blob Storage Internal Stage Google Cloud Storage AWS S3
Which Snowflake layer manages the metadata related to micro-partitions, databases, and tables?
Cloud Services - Contains and manages a variety of metadata, details how the data is stored, information on the micro-partitions, metadata about databases and table, users, roles and security
You are the data modeler at a large retail organization that stores transactional data in a Snowflake table called "Transactions." The daily revenue reports are generated using the "Transactions" table, which calculates the revenue for the current day. The "Transactions" table originally had 500GB of data but has now grown to 5TB. You have noticed that over time the performance of the daily revenue reports has degraded. What is the most efficient & cost-effective way of optimizing performance?
Cluster the Transactions table on the transaction date column (Clustering a table on a specific column can optimize queries by eliminating unnecessary partitions from the query processing.)
Dynamic Data Masking provides what sort of security in Snowflake?
Column-level security Snowflake supports masking policies that may be applied to columns and enforced at the column level to provide column-level security. Column-level security is achieved by dynamic data masking or external Tokenization.
Which of the following scenarios is suitable for scaling up a virtual warehouse to a larger size?
Complex queries are executed on the system and are required to finish faster
You are required to share data from various tables in separate databases. What is the recommended approach to simplify the sharing process?
Create secure views in a single database to consolidate the data from various databases into a new database. Share the new database
Which of the following operations can be performed on a cloned table?
DROP, SELECT, DELETE, CLONE A cloned table is just like any other table
Which of the following Scaling Policy aims to preserve costs?
Economy
What is the best method to add a cluster key to an event table?
Execute ALTER statement on the table to add the clustering key ALTER TABLE events CLUSTER BY (Event_date)
Which of the following is an appropriate scenario for creating a Stored Procedure?
Execute one or more SQL statements that are assembled dynamically
True or False: After a table has been cloned, any updates to the data in the source table will automatically update the data in the cloned table.
False
True or False: An ACCOUNTADMIN can see the results of any query executed by any user in a Snowflake system.
False
True or False: In Snowsight (Snowflake web user interface), you can execute only one query at a given time.
False
True or False: Snowflake applies new software versions to all Snowflake customers at once?
False
True or False: Snowflake does not support the loading of semi-structured data.
False
True or False: To share data as a provider and consume data as a consumer, you must have two Snowflake accounts, one for sharing data and one for consuming shared data.
False
True or False: When defining a clustering key, you should choose columns that have very high cardinality.
False
True/False: If you create more than one virtual warehouse, they will share the memory and CPU resources.
False
True/False: It is possible to disable failsafe entirely for a Snowflake account.
False
A Snowflake share can only have one consumer account added to it.
False A Snowflake share can have zero, one, or multiple consumers added to it
True or False: When unloading data, each exported file is 16MB, and this configuration cannot be changed.
False - Default size of each output file is 16 MB but can be changed using the MAX_FILE_SIZE parameter
Failsafe is provided as an alternate means to access historical data once the Time Travel retention period has ended.
False - Only snowflake support team can restore data from here
Which of the following are Snowflake Data Integration partners?
IBM DataStage AbInitio Matillion Talend Informatica
What is Dynamic Data Masking?
Is a Column-level Security feature that uses masking policies to selectively mask plain-text data in table and view columns at query time.
Snowpark supports which of the following languages?
Java, Scala, Python
Large tables can have ___________ micro-partitions.
Millions or hundreds of millions
What type of virtual warehouse automatically lets you add or remove additional clusters as concurrency and demand change?
Multi-cluster virtual warehouse
Which one of the following objects can NOT be cloned?
Named Internal Stage
Snowflake database is based on the massively parallel shared nothing architecture used by databases like Teradata and Greenplum and data lakes like Hadoop.
No Snowflake implements a new hybrid architecture that combines the best features of shared-disk and shared-nothing architectures.
Snowflake can eliminate unneeded partitions while executing a query. What is the name given to this optimization technique? Retrieve needed data only (RNDO) Predicate optimization WHERE clause optimization Partition pruning (Correct)
Partition Pruning
Which one of the following is supported by Snowflake for the purpose of auto-provisioning users and group membership?
SCIM - SCIM is an open standard that provides automatic user provisioning and role synchronization based on identity provider information
Data Masking policies are ________ level objects
Schema which means a database and schema must exist in Snowflake before a masking policy can be applied to a column
Which of the following is a command line tool used to connect to Snowflake?
SnowSQL
Which of the following correctly describe Snowpipe?
Snowpipe is used to load a small volume of data that arrives frequently and continuously
Which object types can be recovered using the UNDROP command after they have been dropped?
Table, Schema, Database
A data consumer has created a read-only database on a Share object shared by a data provider. The data provider adds an object to the Share. Which of the following statement correctly describe what happens?
The data consumer can see and consume the new object immediately
Assume a share has been granted to a consumer, and the consumer has created a database on the Share. Which of the following correctly describes what occurs if a new object is added to the Share?
The new object becomes accessible to the consumer immediately
As part of a data processing pipeline, you are required to store data in an interim table. The subsequent processes then use the table in the pipeline. The data is deleted and reloaded every time the pipeline is executed. You are required to minimize data storage costs. Which type of table will you create?
Transient
Files already loaded from a stage to a table can be loaded again into a cloned table.
True
True / False: All Snowflake editions support data clustering
True
True or False. To create Snowflake instances in different regions, you must maintain a separate Snowflake account for each region.
True
True or False: A reader account can be used to share data with a non-Snowflake user or a non-Snowflake organization.
True
True or False: If an IP address is in a network policy's block list and the allowed list, Snowflake applies the blocked list first.
True
True or False: The ACCOUNT_USAGE views contain information on objects that have been deleted.
True
True or False: The COPY command in a Snowpipe definition supports the same transformation as provided by the typical COPY command.
True
True or False: The functions provided in INFORMATION_SCHEMA can be used to view account-level information.
True
True/False: Snowflake customers can control the format using which Snowflake stores the data for a table.
True
True/False: The storage capacity of your Snowflake-based data warehouse is virtually unlimited because it uses cloud storage as the underlying storage mechanism.
True
When defining a clustering key for a large table, consider using columns frequently used in WHERE clauses.
True
True or False: The data in the views in the ACCOUNT_USAGE schema can have a latency of up to 3 hours.
True - Data in these views are retained for up to 365 days
True/False: Once the Time Travel retention period has ended for a transient table, historical data for that table can not be recovered by Snowflake support.
True Transient and temp tables don't have fail-safe functionality
Which of the following Snowflake edition doesn't support Snowflake Marketplace?
VPS
What is the minimum Snowflake edition that supports a dedicated metadata store?
Virtual Private Snowflake
How frequently does Snowflake release new software?
Weekly
What is the minimum Snowflake edition required to browse Snowflake Marketplace?
You don't need a Snowflake edition to browse marketplace