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