Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 101
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
- A: When using a paid listing on the Snowflake Marktetplace
- B: When using a private listing on the Snowflake Marketplace
- C: When using a personalized listing on the Snowflake Marketplace
- D: When using a Direct Share with another account
Question 102
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A: True
- B: False
Question 103
Which languages require that User-Defined Function (UDF) handlers be written inline? (Choose two.)
- A: Java
- B: Javascript
- C: Scala
- D: Python
- E: SQL
Question 104
Which task privilege does a Snowflake role need in order to suspend or resume a task?
- A: USAGE
- B: OPERATE
- C: MONITOR
- D: OWNERSHIP
Question 105
What is a directory table in Snowflake?
- A: A separate database object that is used to store file-level metadata.
- B: An object layered on a stage that is used to store file-level metadata.
- C: A database object with grantable privileges for unstructured data tasks.
- D: A Snowflake table specifically designed for storing unstructured files.
Question 106
What factors impact storage costs in Snowflake? (Choose two.)
- A: The account type
- B: The storage file format
- C: The cloud region used by the account
- D: The type of data being stored
- E: The cloud platform being used
Question 107
Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
- A: USAGE_VIEWER
- B: GOVERNANCE_VIEWER
- C: OBJECT_VIEWER
- D: SECURITY_VIEWER
Question 108
How should clustering be used to optimize the performance of queries that run on a very large table?
- A: Manually re-cluster the table regularly.
- B: Choose one high cardinality column as the clustering key.
- C: Use the column that is most-frequently used in query select clauses as the clustering key.
- D: Assess the average table depth to identify how clustering is impacting the query.
Question 109
Which privilege must be granted by one role to another role, and cannot be revoked?
- A: MONITOR
- B: OPERATE
- C: OWNERSHIP
- D: ALL
Question 110
How can performance be optimized for a query that returns a small amount of data from a very large base table?
- A: Use clustering keys
- B: Create materialized views
- C: Use the search optimization service
- D: Use the query acceleration service
Question 111
A column named “Data” contains VARIANT data and stores values as follows:
How will Snowflake extract the employee’s name from the column data?
- A: Data:employee.name
- B: DATA:employee.name
- C: data:Employee.name
- D: data:employee.name
Question 112
Use of which Snowflake function is recommended when unloading data from a relational table into a JSON file?
- A: TO_JSON
- B: TO_VARIANT
- C: OBJECT_INSERT
- D: OBJECT_CONSTRUCT
Question 113
True or False: The COPY command must specify a File Format in order to execute.
- A: True
- B: False
Question 114
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A: True
- B: False
Question 115
Which command should be used to generate a single file when unloading data from a Snowflake table into a file?
- A: PARTITION BY [expr]
- B: MAX_FILE_SIZE = 0
- C: SINGLE = TRUE
- D: OVERWRITE = TRUE
Question 116
Which function can be used to convert semi-structured data into rows and columns?
- A: TABLE
- B: FLATTEN
- C: PARSE_JSON
- D: JSON_EXTRACT_PATH_TEXT
Question 117
What user setting can be configured to disable Multi-Factor Authentication (MFA) for a Snowflake user? (Choose two.)
- A: DISABLE_MFA
- B: MINS_TO_BYPASS_MFA
- C: PASSWORD
- D: MINS_TO_UNLOCK
- E: MUST_CHANGE_PASSWORD
Question 118
Which table type has a Fail-safe period of 7 days?
- A: Temporary table
- B: Transient table
- C: Permanent table
- D: External table
Question 119
How does Snowflake enable OAuth?
- A: By creating an external integration
- B: By configuring a security integration
- C: By establishing IP allowed lists and IP blocked lists
- D: By using SnowSQL to enable an external OAuth using the Snowflake protocol
Question 120
Which type of workload traditionally benefits from the use of the query acceleration service?
- A: Workloads with a predictable data volume for each query
- B: Workloads that include on-demand data analyses
- C: Queries with small scans and non-selective filters
- D: Queries that do not have filters or aggregation
Question 121
Which Snowflake object is supported by both database replication and replication groups?
- A: Pipes
- B: Users
- C: Stages
- D: Materialized views
Question 122
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Choose two.)
- A: ESCAPE_UNENCLOSED_FIELD
- B: REPLACE_INVALID_CHARACTERS
- C: FIELD_OPTIONALLY_ENCLOSED_BY
- D: EMPTY_FIELD_AS_NULL
- E: SKIP_BLANK_LINES
Question 123
Which role must be used to create resource monitors?
- A: SECURITYADMIN
- B: ACCOUNTADMIN
- C: SYSADMIN
- D: ORGADMIN
Question 124
What step does Snowflake recommend when loading data from a stage?
- A: Use PURGE when using the COPY INTO [table] command.
- B: Use REMOVE when using the COPY INTO [table] command.
- C: Use the LOAD HISTORY function to view the status of loaded files.
- D: Use the COPY HISTORY function to update the status of loaded files.
Question 125
True or False: During data unloading, only JSON and CSV files can be compressed.
- A: True
- B: False
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!