SnowPro Core Certification

The COPY command must specify a File Format in order to execute: True. False.

Which of the following commands sets the Virtual Warehouse for a session?. COPY WAREHOUSE FROM <<config file>. SET WAREHOUSE = <<warehouse_name>>. USE WAREHOUSE <<warehouse_name>>. USE VIRTUAL_WAREHOUSE <<warehouse name>>.

Which of the following objects can be cloned? Choose four. Tables. Named File Formats. Schemas. Shares. Databases. Users.

Which objects allows you to limit the number of credits consumed within a Snowflake account?. Resource Monitor. Account Usage Tracking. Warehouse Limit Parameter. Credit Consuption Tracker.

Snowflake is designed for the which type of workloads?. OLAP (Analytics) workloads. OLTP (Transactional) workloads. Concurrent Workloads. On-Premise workloads.

What are the three layers that make up Snowflake's architecture?. Compute. Tri-secret Secure. Storage. Cloud Services.

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?. To accomodate more queries. To accomodate more users. To acommodate fluctuations in workload. To accomodate a more complex workload.

Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes. True. False.

Which the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?. JDBC. SnowSQL. Snowflake Web Interface (UI). ODBC. Python.

Snowflake Charges a premium for storing semi-structured data. True. False.

Which of the following statements describes a benefit of Snowflake's separation of compute and storage?. Growth of storage and compute are tightly coupled together. Storage expands without the requirement to add more compute. Compute can be scaled up or down without the requirement to add more storage. Multiple compute clusters can access stored data without contention.

It is possible to unload structured data to semi-structured format such as JSON and PArquet. True. False.

In which layer of its architecture does Snowflake store its metadata stadistics?. Storage Layer. Compute Layer. Database Layer. Cloud Service Layer.

Data in Fail-Safe can be deleted by a user or the Snowflake team before it expires. True. False.

Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base. True. False.

Which of the following statements are true of Virtual Warehouses? (Choose all that apply). Customer can change the size of the Warehouse after creation. A Warehouse can be resized while running. A Warehouse can be configured to suspend after a period of inactivity. A Warehouse can be configured to auto-resume when new queries are submitted.

The PUT command: Automatically creates a File Format object. Automatically uses the last Stage created. Automatically compresses files using Gzip. Automatically encrypts files.

Which type of table corresponds to a single Snowflake session?. Temporary. Transient. Provisional. Permanent.

Which interfaces can be used to create and/or manage Virtual Warehouses?. The Snowflake Web Interface (UI). SQL commands. Data integration tools. All the above.

When a Pipe is recreated using the CREATE OR REPLACE PIPE command: The Pipe load history is reset to empty. The REFRESH parameter is set to TRUE. Previously loaded files will be ignored. All of the above.

What is the minomum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?. Standard. Premier. Enterprise. Business Critical Edition.

Select the three types of tables that exist within Snowflake. Temporary. Transient. Provisional. Permanent.

SnowPipe via REST API can only reference External Stages as sources. True. False.

A third-party tool that support standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake. True. False.

It is possible to load data into Snowflake without creating a named File Format object. True. False.

A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data. True. False.

Which of the following statements are true of Snowflake data loading?. VARIANT ג€nullג€ values are not the same as SQL NULL values. It is recommended to do frequent, single row DMLs. It is recommended to validate the data before loading into the Snowflake target table. It is recommended to use staging tables to manage MERGE statements.

Which statements are true of micro-partitions?. They are approximately 16 MB in size. They are stored compressed only if COMPRESS=TRUE on Table. They are immutable. They are encrypted in the Enterprise edition and above.

Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues. True. False.

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accesed within previous 24 hour period. The same exact query will return the precomputed result even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period. The ג€24 hourג€ timer on the precomputed results gets renewed every time the exact query is executed.

Whic statement best describes Snowflake tables?. Snowflake tables are logical representations of underlying physical data. Snowflake tables are the physical instantation of data loaded into Snowflake. Snowflake tables require that clustering keys be defined to perfomr optimally. Snowflake tables are owned by a user.

Which item in the Data Warehouse migration process does not apply in Snowflake. Migrate Users. Migrate Schemas. Migrate Indexes. Build the Data Pipeline.

Snowflake provides two mwchanism to reduce data storage costs for short-lived tables. These mechanism are: Temporary Tables. Transient Tables. Provisional Tables. Permanent Tables.

What is the maximun compressed row size in Snowflake?. 8 KB. 16 MB. 50 MB. 4000 GB.

Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI). Database. Tables. Warehouse. Worksheeta.

What is the recommended Snowflake data type to store semi-structured data like JSON?. VARCHAR. RAW. LOB. VARIANT.

Which of the following statements are true of Snowflake releases: They happen approximately weekly. They roll and release aproximately monthly, but customers can required early release application. During a release, new customer request/queries/connections transparently move over to the newer version. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be availabe and customer is upgraded.

Which of the following are common use cases for zero-copy cloning?. Quick provisioning of Dev and Test/QA enviroments. Data backups. Point in time snapshots. Performance optimization.

If a Small Warehouse is made up of 2 servers/clusters, how many servers/clusters make up a Medium Warehouse?. 4. 16. 32. 128.

When a data share is established between a Data provider and a Data Consumer, the Data Consumer can extend that data share to other Data Consumers. True. False.

Which is true of Snowflake network policies? A Snowflake network policy. Is available to all Snowflake Editions. Is only available to customers with Business Critical Edition. Restrict or enables access to specific IP addresses. Is activate using an ג€ALTER DATABASEג€ command.

Snowflake charges additional fees to Data Providers for each Share they create. True. False.

Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?. 1 hour. 3 hours. 12 hours. 24 hours.

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?. The tables are now orphaned. The user that deleted the role. SYSADMIN. The assumed role that dropped the role.

Which of the following connectors are available in the Downloads section of the Snowflake Web Interface(UI)?. SnowSQL. ODBC. R. Hive.

Which of the following DML commands isn't supported by Snowflake?. UPSERT. MERGE. UPDATE. TRUNCATE TABLE.

Which of the following statements is true of zero-copy cloning?. Zero-copy clones increase storage costs as cloning the table requires storing its data twice. All zero-copy clone obkects inherit the privileges of their original objects. Zero-copy cloning is licensed as an additional Snowflake feature. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared.

When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user. True. False.

The query History in the Snowflake Web Interface (UI) is kept for approximately: 60 minutes. 24 hours. 14 days. 30 days. 1 year.

To run a Multi-Cluster Warehouse in auto scale mode, a user would: Configure the Maximum Clusters setting to ג€Auto-Scaleג€. Set the Warehouse type to ג€Autoג€. Set the minimun Clusters and MAximun Clusters settings to the same value. Set the Minimum Clusters and Maximun Clusters settings to the different values.

Which of the following terms best describes Snowflake's database architecture?. Columnar shared nothing. Shared disk. Multi-Cluster shared data. Cloud-native shared memory.

Which of the following are options when creating a Virtual Warehouse?. Auto-drop. Auto-resize. Auto-resume. Auto-suspend.

A Virtual Warehouse's auto-suspend and auto-resume settings apply to: The primary cluster in the Virtual Warehouse. The entire Virtual Warehouse. The database the Virtual Warehouse resides in. The queries currently being run by the Virtual Warehouse.

Fail-safe is unavailable on which table types?. Temporary. Transient. Provisional. Permanent.

Which of the following objects is not covered by Time Travel?. Tables. Schemas. Databases. Stages.

Micro-partitions metadata enables some operations to be completed without requiring Compute. True. False.

Which of the following commands are not blocking operations?. UPDATE. INSERT. MERGE. COPY.

Which of the following is true of Snowpipe via REST API?. You can only use it on internal Stages. All COPY INTO options are available during pipe creation. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands. Snowpipe keeps track of which files it has loaded.

Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA). SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN. SECURITYADMIN, ACCOUNTADMIN, SYSADMIN. SECURITYADMIN, ACCOUNTADMIN. ACCOUNTADMIN.

When can a VIrtual Warehouse start running queries?. 12am-5am. Only during administrator defined time slots. When its provisioning is complete. After replication.

Users are able to see the result sets of queries executed by other users that share their same role. True. False.

The user has to specify which cluster a query will run on in a multi-cluster Warehouse. True. False.

Pipes can be suspended and resumed. True. False.

Which of the following languages can be used to implement Snowflake User defined Functions (UDFs)?. Java. JavaScript. SQL. Python.

When should you consider disabling auto-suspend for a Virtual Warehouse?. When users will be using at different times throughout a 24/7 period. When managing a steady workload. When the compute must be available with no delay or lag time. When you do not want to have to manually turn on the Warehouse each time a user needs it.

Which of the following are valid approaches to loading data into a Snowflake table?. Bulk copy from an External Stage. Continuous load using Snowpipe REST API. The Snowflake Web Interface (UI) data loading wizard. Bulk COPY from an internal Stage.

If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended when: All Snowflakes sessions using the Warehouse are terminated. The last query using the Warehouse completes. There are no users logged into Snowflake. The Warehouse is inactive for a specified period of time.

Multi-Factor Authentication (MFA) in Snowflake is only supported in conjuction with Single Sign-On (SSD). True. False.

The number of queries that a Virtual Warehouse can concurrently process is determined by. The complexity of each query. The CONCURRENT_QUERY_LIMIT parameter set on the Snowflake account. The size of the data required for each query. The tool that is executing the query.

Which of the following statements are true of VALIDATION_MODE in Snowflake?. The VALIDATION_MODE option is used when creating an Internal Stage. VALIDATION_MODE=RETURN_ALL_ERRORS is a parameter of the COPY command. The VALIDATION_MODE option will validate data to be loaded by the COPY statement while completing the load and will return the rows that could not be loaded without error. The VALIDATION_MODE option will validate data to be loaded by the COPY statement without completing the load and will return possible errors.

What privileges are required to create a task?. The GLOBAL privilege CREATE TASK is required to create a new task. Task are created at the Application level and can only be created by the Account Admin role. Many Snowflake DDLs are metadata operations only, and CREATE TASK DDL can be executed without virtual warehouse requirement or task specific grants. The role must have access to the target schema and the CREATE TASK privilege on the schema itself.

What are the three things customer want most from their enterprise data warehouse solution?. On-premise availability. Simplicity. Open source based. Concurrency. Performance.

Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse. True. False.

From the given options, select the cloud services provider supported by snowflake architecture. AWS. Google (GCP). HP Virtual Private Cloud. Cloud Foundry. Microsoft Azure.

Which of the following statements are true with respect to the Snowflake release process. Snowflake deploy new releases and/or patch releases every week. Snowflake deploys patch releases every week, but new feature releases happen once a month. There's minimal downtime associated with Snowflake depending upon the content of the release. It is possible for you as a user to request 24 hour early acces to the upcoming releases so that you can do additional release testing before the release is rolled out.

When opening a Snowflake account, what do you need to decide. Edition. Deployment Enviroment (Public Cloud or Private Cloud). Cloud Service Provider. Region. Availability Zone.

Select the correct example of a typical Snowflake URL from the options given below. https://xu42345.snowflakecomputing.com/. https://pv53924.ap-south-1.aws.snowflakecomputing.com/. https://er23455.us-east-1.snowflakecomputing.com/. https://er35324.us-east-1.azure.snowflakecomputing.com/. https://er35324.europe-west2.gcp.snowflakecomputing.com/.

What are the key considerations for choosing a specific region for your Snowflake account?. Cost. Proximity to the end users. Data sovereignty. Regulatory requirements.

Which of the following constraints are NOT enforced by Snowflake?. Primary Key. Foreign Key. NOT NULL. Unique. Check constraint.

Following programming languages/drivers support is available out-of-the-box (natively) in Snowflake. JDBC/ODBC driver. Google Flutter. GO, Node.js driver. Scala connector. Python connector. Spark connector.

In the context of a Snowflake virtual warehouses, an example of scaling out is.................. and an example of scaling up is............... example of scaling out is changing the size of compute from M to L, example of scaling up is adding a new virtual warehouse (VW). example of scaling out adding a new virtual warehouse (VW), example of scaling up is changing the size of compute from M to L. example of scaling out is adding a new data storage layer, example of scaling up is changing the size of storage layer from M to L. Both a and c. Both b and c.

Snowflake follows a 3 stage release process for .... All releases. Patch releases. New feature releases. None of the above.

History tab in the Snowflake Web Interface supports viewing of user queries submitted in the past............day(s). 24 hours or 1 day. 7 days. 14 days. 90 days.

Following are the key reasons that make Snowflake a "True SaaS" product. Snowflake completely runs on cloud infrastructure and is accessible over internet. There's no hardware or software to install, configure, maintain or upgrade at user's end. Snowflake supports key properties of as-a-service offering such as on demand and instance elasticity, unlimited scalability of compute and storage and pay-per-use. All of the above.

Which layer of the Snowflake architecture is referred to as " the brain" of the Snowflake data warehouse. Compute layer. Data Storage Layer. Cloud Services Layer. Query processing layer.

Identify the key features of Snowflake Micro-partition system. Each micro-partition contains 50-500MB of uncompressed data. Data stored in micro-partition are compressed and optimized. Groups of rows in tables are organized in columnar format in micro-partitions. Table rows are organized in micro partitions using the order of insertion. End users can directly access micro-partitions for their queries.

Informatica, Matillion, Azure data factory are examples of...........partners of Snowflake partner ecosystem. Data Management. Business Intelligence. Data Integration. Data Science.

To execute a query in Snowflake, you need to provide a context. The context consists of. Virtual Warehouse (VW). Database. Schema. Role. User. Session.

What is Snowflake architecture known as?. Shared disk architecture. Shared nothing architecture. Multi-cluster, shared data architecture. None of the above.

Identify system defined roles in Snowflake from the roles given below. AccountAdmin. SysAdmin. Auditor. RoleAdmin. SecurityAdmin. Public.

Select the correct object container hierarchy fot he objects given below. Schema>>Account>>Database>>Table. Account>>Database>>Schema>>Table. Table>>Account>>Schema>>Database. Account>>Schema>>Database>>Table.

Select the correct statements from the given set of statements that indicates differences between a view and a materialized view in Snowflake. A view is a named query; a materialized view is unnamed. A view does not store query results; a materialized view stores query results for later use. A view has slower performance a materialized view has faster performance. A view does not consume credit; a materialized view consumes credit.

As a Snowflake data engineer, your task is to ingest data generated by senseors located on electric poles. As more sensors are getting installed in the city, your system has started receiving new data files from the newly installed sensors. You have benn tasked to support the growth in data loading volume while optimizing cost of ingestion. Which best practices you would employ to increase performance of your data ingestion workload. Increase the size of virtual warehouse (S>>M>>L). Split input files into Small batches. Using SnowPipe as SnowPipe method is better in ingesting continuous microbatch workloads. Use SnowSql as SnowSQL method is better in ingesting continuous microbatch workloads.

Which of the following statements are true about Snowflake Query History Views. Snowflake query history view stores queries and profile information for 14 days. You can download query results from the query history view any time within a 24 hours period only after the query was executed. To download query results from query history view, you will need a running Snowflake virtual Warehouse. You can view other users'queries in query history view, but cannot download results (assume that order users have a different role than yours).

Which of the following statements about Cloning features in Snowflake are true. The cloned data is automatically updated to synchronise with original data. Zero-copy cloning in Snowflake allows users to have multiple copies of data without incurring additional cost of storage. All Snowflake objects can be cloned. Zero-copy cloning feature is available in Enterprise edition and above.

Which of the following statements are true about the Snowflake Cache feature. Snowflake Metadata cache contains object definitions and statistics. Snowflake results cache stores exact results from exact queries for 24 hours. Snowflake will return the resultset from the results cache if exact some query is executed by different users even when they have different roles. Snowflake warehouse cache is available only when the Snowflake warehouse is running.

Which of the following are valid context functions in Snowflake?. Select current_client(). Select current_account(). Select current_cloud(). Select current_user(). Select current_role().

Choose Snowflake interface that support multi-factor authentication based login. Snoeflake Web UI. SnowSQL. Snowflake JDBC and ODBC drivers. All of the above.

What opening a snowflake account what do you need decide?. Edition. Deployment Enviroment(Public cloud or Private Cloud). Cloud Service Provider. Region. Availability Zone.

Following are the key reasons that make Snowflake a "True SaaS" product. Snowflake supports key properties of as-a-service offering such as on demand and instance elasticity, unlimited scalability of compute and storage and pay-per-use. There's no hardware or software to install, configure, maintain or upgrade at user's end. Snowflake completely runs on cloud infrastructure and is accessible over internet. All of the above.