Ask Question
Snowflake SnowPro Core Practice Test - Questions Answers, Page 20
List of questions
Question 191
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
The SQL statementSHOW GRANTS TO ROLE MY_ROLEis used to determine which users and roles have access to a role called MY_ROLE. This statement lists all the privileges granted to the role, including which roles and users can assume MY_ROLE.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 192
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
The minimum edition of Snowflake required to use a SCIM security integration is the Enterprise Edition. SCIM integrations are used for automated management of user identities and groups, and this feature is available starting from the Enterprise Edition of Snowflake.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 193
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
To go back to the first version of a transient table created three days prior, one can use Time Travel if theDATA_RETENTION_TIME_IN_DAYSwas set to at least 3 days. This allows the user to access historical data within the specified retention period.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 194
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
The SQL commandSelect * from table(validate(t1, job_id => '_last'));is used to return errors from the last executed COPY command into table t1 in the current session.It checks the results of the most recent data load operation and provides details on any errors that occurred during that process1.
Question 195
Which file formats are supported for unloading data from Snowflake? (Choose two.)
Snowflake supports unloading data in JSON and delimited file formats such as CSV and TSV.These formats are commonly used for data interchange and are supported by Snowflake for unloading operations
Question 196
The Snowflake Search Optimization Services supports improved performance of which kind of query?
The Snowflake Search Optimization Service is designed to support improved performance for selective point lookup queries.These are queries that retrieve specific records from a database, often based on a unique identifier or a small set of criteria3.
Question 197
What are common issues found by using the Query Profile? (Choose two.)
The Query Profile in Snowflake is used to identify performance issues with queries. Common issues that can be found using the Query Profile include identifying inefficient micro-partition pruning (D) and data spilling to a local or remote disk (E).Micro-partition pruning is related to the efficiency of query execution, and data spilling occurs when the memory is insufficient, causing the query to write data to disk, which can slow down the query performance1.
Question 198
What happens to historical data when the retention period for an object ends?
When the retention period for an object ends in Snowflake, Time Travel on the historical data is dropped .This means that the ability to access historical data via Time Travel is no longer available once the retention period has expired2.
Question 199
By default, which Snowflake role is required to create a share?
By default, the Snowflake role required to create a share is ACCOUNTADMIN (D).This role has the necessary privileges to perform administrative tasks, including creating shares for data sharing purposes
Question 200
In a Snowflake role hierarchy, what is the top-level role?
In a Snowflake role hierarchy, the top-level role is ACCOUNTADMIN.This role has the highest level of privileges and is capable of performing all administrative functions within the Snowflake account
Related questions
Export
If you didn't receive an email within 5 minutes, you should submit a support request to [email protected].
|
BASIC - 1 Month
$
10
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PLUS - 2 Months
$
15
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PRO - 6 Months
$
40
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Selling illegal goods, money scams etc.
Serious attack on a group.
Harassing an individual (including doxing)
Threatening or glorifying violence or serious harm, including self-harm
Nudity/Sexual content
Sexually explicit or suggestive imagery or writing involving minors
Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans
Reusing content without attribution (link and blockquotes)
Not in English or has very bad formatting, grammar, and spelling
Author's credential is offensive, spam, or impersonation
Ex. Illegal content, incomplete question...
Question