Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 26
Which table function is used to view all errors encountered during a previous data load?
- A: VALIDATE
- B: INFER_SCHEMA
- C: GENERATOR
- D: QUERY_HISTORY
Question 27
What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?
- A: X-Small
- B: Small
- C: Medium
- D: Large
Question 28
Which role has the ability to create and manage users and roles?
- A: ORGADMIN
- B: USERADMIN
- C: SYSADMIN
- D: SECURITYADMIN
Question 29
What issues can be identified and troubleshooted using the Query Profile? (Choose two.)
- A: Full index scans
- B: Cartesian products
- C: Insufficient privileges
- D: Queries too large to fit in memory
- E: Virtual warehouse credit consumption
Question 30
What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?
- A: The objects are dropped.
- B: The objects enter the Fail-safe period.
- C: The objects enter the Time Travel period.
- D: The objects are immediately moved to the provider account.
Question 31
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
- A: FLATTEN
- B: GET_PATH
- C: CHECK_JSON
- D: PARSE_JSON
Question 32
What does Snowflake recommend when planning virtual warehouse usage for a data load?
- A: Load the fewest possible number of large files.
- B: Dedicate a separate warehouse for loading data.
- C: Increase the size of the warehouse used.
- D: Use several single-cluster warehouses.
Question 33
Which Snowflake database object can be used to track data changes made to table data?
- A: Tag
- B: Task
- C: Stream
- D: Stored procedure
Question 34
Who can activate and enforce a network policy for all users in a Snowflake account? (Choose two.)
- A: A user with an USERADMIN or higher role
- B: A user with a SECURITYADMIN or higher role
- C: A role that has been granted the ATTACH POLICY privilege
- D: A role that has the NETWORK_POLICY account parameter set
- E: A role that has the OWNERSHIP of the network policy
Question 35
How can a data provider share their Snowflake data? (Choose two.)
- A: External table
- B: Snowpark API
- C: Direct share
- D: External function
- E: Snowflake Marketplace listing
Question 36
When scaling up Virtual Warehouses by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
- A: Concurrency
- B: Performance
Question 37
What will prevent unauthorized access to a Snowflake account from an unknown source?
- A: Network policy
- B: End-to-end encryption
- C: Multi-Factor Authentication (MFA)
- D: Role-Based Access Control (RBAC)
Question 38
Which query type is supported for implementing the search optimization service?
- A: Queries with column concatenation
- B: Substring search queries on external tables
- C: String searches on columns using the COLLATE function
- D: Geography value column searches using geospatial functions
Question 39
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
- A: Data Replication
- B: Secure Data Sharing
- C: Data Exchange
- D: Snowflake Marketplace
Question 40
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
- A: PARSE_JSON
- B: CHECK_JSON
- C: JSON_EXTRACT_PATH_TEXT
- D: PARSE_XML
Question 41
Which Snowflake data types can be used to build nested hierarchical data? (Choose two.)
- A: INTEGER
- B: OBJECT
- C: VARIANT
- D: VARCHAR
- E: LIST
Question 42
Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)
- A: Bytes scanned
- B: Bytes written to result
- C: Partitions scanned
- D: Partitions total
- E: Percentage scanned from cache
Question 43
Which element in the Query Profile interface shows the relationship between the nodes in the execution of a query?
- A: Node List
- B: Steps
- C: Overview
- D: Operator Tree
Question 44
What will happen if a Snowflake user suspends the updates to a materialized view?
- A: The queries on that view will generate an error message.
- B: The queries on that view will return the last stored data.
- C: The queries on that view will return the data using Time Travel.
- D: The queries on that view will return the data with a warning message.
Question 45
Which Snowflake function will parse a JSON-null into a SQL-null?
- A: TO_CHAR
- B: TO_VARIANT
- C: TO_VARCHAR
- D: STRIP_NULL_VALUE
Question 46
Which Snowflake command can be used to unload the result of a query to a single file?
- A: Use COPY INTO [external stage] followed by a GET command to download the file.
- B: Use COPY INTO [internal stage] followed by a PUT command to download the file.
- C: Use COPY INTO [internal stage] with SINGLE = TRUE followed by a GET command to download the file.
- D: Use COPY INTO [external stage] with SINGLE = TRUE followed by a PUT command to download the file.
Question 47
As a best practice, clustering keys should only be defined on tables of which minimum size?
- A: Multi-Kilobyte (KB) Range
- B: Multi-Megabyte (MB) Range
- C: Multi-Gigabyte (GB) Range
- D: Multi-Terabyte (TB) Range
Question 48
How are micro-partitions enabled on Snowflake tables?
- A: Micro-partitioning requires a cluster key on a table.
- B: Micro-partitioning is automatically performed on a table.
- C: Micro-partitioning requires the use of the search optimization service.
- D: Micro-partitioning is defined by the user when a table is created.
Question 49
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
- A: Micro-partitions
- B: Clustering keys
- C: Equality searches
- D: Search access paths
Question 50
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
- A: OAuth
- B: Network policies
- C: Single Sign-On (SSO)
- D: Multi-Factor Authentication (MFA)
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!