Practice Free SnowPro Core Exam Online Questions
What role is required to use Partner Connect?
- A . ACCOUNTADMIN
- B . ORGADMIN
- C . SECURITYADMIN
- D . SYSADMIN
Which stream type can be used for tracking the records in external tables?
- A . Append-only
- B . External
- C . Insert-only
- D . Standard
What can a Snowflake user do in the Activity section in Snowsight?
- A . Create dashboards.
- B . Write and run SQL queries.
- C . Explore databases and objects.
- D . Explore executed query performance.
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
- A . Gathering the hourly credit usage for an account
- B . Compiling an account’s average cloud services cost over the previous month
- C . Summarizing the throughput of Snowpipe costs for an account
- D . Calculating the funds left on an account’s contract
What can be used to view warehouse usage over time? (Select Two).
- A . The load HISTORY view
- B . The Query history view
- C . The show warehouses command
- D . The WAREHOUSE_METERING__HISTORY View
- E . The billing and usage tab in the Snowflake web Ul
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A . True
- B . False
Which of the following significantly improves the performance of selective point lookup queries on a table?
- A . Clustering
- B . Materialized Views
- C . Zero-copy Cloning
- D . Search Optimization Service
What data is stored in the Snowflake storage layer? (Select TWO).
- A . Snowflake parameters
- B . Micro-partitions
- C . Query history
- D . Persisted query results
- E . Standard and secure view results
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A . True
- B . False
Network policies can be set at which Snowflake levels? (Choose two.)
- A . Role
- B . Schema
- C . User
- D . Database
- E . Account
- F . Tables