Free SnowPro-Core – SnowPro Core Certification Exam Practice Test Question

Select all that apply, then click Submit answer.

• ○

  When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

• ○

  When the data cache is full, the least-recently used data will be cleared to make room.

• ○

  A user can only access their own queries from the query result cache.

• ○

  A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

• ○

  The RESULT_SCAN table function can access and filter the contents of the query result cache.

Select all that apply, then click Submit answer.

• ○

  Installing and configuring hardware

• ○

  Patching software

• ○

  Physical security

• ○

  Maintaining metadata and statistics
  
  

Select all that apply, then click Submit answer.

• ○

  Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

• ○

  Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

• ○

  Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

• ○

  Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

• ○

  All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

• ○

  Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Select all that apply, then click Submit answer.

• ○

  TSV

• ○

  JSON

• ○

  PDF

• ○

  Avro

• ○

  Parquet

• ○

  JPEG

Select all that apply, then click Submit answer.

• ○

  JDBC

• ○

  SnowSQL

• ○

  Snowflake Web Interface (UI)

• ○

  ODBC

• ○

  Python
  D18912E1457D5D1DDCBD40AB3BF70D5D

Select all that apply, then click Submit answer.

• ○

  Automatically creates a File Format object

• ○

  Automatically uses the last Stage created

• ○

  Automatically compresses files using Gzip

• ○

  Automatically encrypts files
  
  

Select all that apply, then click Submit answer.

• ○

  A directory table is a separate database object.

• ○

  Directory tables store data file metadata.

• ○

  A directory table will be automatically added to a stage.

• ○

  Directory tables do not have their own grantable privileges.

• ○

  Directory table data can not be refreshed manually.

Select all that apply, then click Submit answer.

• ○

  The ability to scale up warehouses

• ○

  The use of warehouse auto scaling

• ○

  The ability to resize warehouses

• ○

  Use of multi-clustered warehouses

• ○

  The use of warehouse indexing

Select all that apply, then click Submit answer.

• ○

  Database replication and failover

• ○

  Automated index management

• ○

  Customer managed keys (Tri-secret secure)

• ○

  Extended time travel

• ○

  Native support for geospatial data

Select all that apply, then click Submit answer.

• ○

  Load files that are approximately 25 MB or smaller.

• ○

  Remove all dates and timestamps.

• ○

  Load files that are approximately 100-250 MB (or larger)

• ○

  Avoid using embedded characters such as commas for numeric data types

• ○

  Remove semi-structured data types

Select an option, then click Submit answer.

• ○

  Standard

• ○

  Premier

• ○

  Enterprise

• ○

  Business Critical Edition
  
  

Select an option, then click Submit answer.

• ○

  The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

• ○

  Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

• ○

  The clustering key must be included in the COPY command when loading data into Snowflake.

• ○

  Clustering can be disabled within a Snowflake account.

Select an option, then click Submit answer.

• ○

  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
  
  

Select an option, then click Submit answer.

• ○

  USERADMIN

• ○

  PUBLIC

• ○

  ORGADMIN

• ○

  SYSADMIN

Select an option, then click Submit answer.

• ○

  Shared-disk

• ○

  Shared-nothing

• ○

  Multi-cluster shared data

• ○

  Serverless query engine

Select an option, then click Submit answer.

• ○

  A User Defined Function (UDF)

• ○

  A stored procedure

• ○

  A single copy_into statement

• ○

  A single insert__into statement

Select an option, then click Submit answer.

• ○

  CREATE_SHARE on the account

• ○

  SHARE on databases and schemas

• ○

  SELECT on tables used by the secure view

• ○

  REFERENCE_USAGE on databases

Select an option, then click Submit answer.

• ○

  select src:dealership from car_sales;

• ○

  select src.dealership from car_sales;

• ○

  select src:Dealership from car_sales;

• ○

  select dealership from car_sales;

Select an option, then click Submit answer.

• ○

  A compressed file size greater than 100 MB, and up to 250 MB

• ○

  A compressed file size greater than 100 GB, and up to 250 GB

• ○

  A compressed file size greater than 10 MB, and up to 100 MB

• ○

  A compressed file size greater than 1 GB, and up to 2 GB

Select an option, then click Submit answer.

• ○

  COPY WAREHOUSE FROM <>;

• ○

  SET WAREHOUSE = <>;

• ○

  USE WAREHOUSE <>;

• ○

  USE VIRTUAL_WAREHOUSE <>;