How can staged files be removed during data loading once the files have loaded successfully?
Use the DROP command
Use the purge copy option.
Use the FORCE = TRUE parameter
Use the LOAD UNCERTAIN FILES copy option.
To remove staged files during data loading after they have been successfully loaded, thePURGEcopy option is used in Snowflake.
PURGE Option: This option automatically deletes files from the stage after they have been successfully copied into the target table.
Usage:
FROM @my_stage
FILE_FORMAT = (type = ' csv ' )
PURGE = TRUE;
Snowflake Documentation on COPY INTO
By default, which role is required to change the refresh frequency for an auto-fulfilled application package?
ACCOUNTADMIN
SYSADMIN
GLOBALORGADMIN
SECURITYADMIN
The correct answer is C. GLOBALORGADMIN .
Corrected typos:
The original options contain typing errors:
A. ACCOUNT AUXIN should be ACCOUNTADMIN
B. SYSAEMIN should be SYSADMIN
C. CLOBALORGADMIN should be GLOBALORGADMIN
D. HECURITYADMIH should be SECURITYADMIN
Auto-fulfillment is an organization-level capability related to Snowflake Native Apps and listings across regions or accounts. Because refresh frequency for auto-fulfilled application packages is managed at the organization/global level, the required role is GLOBALORGADMIN.
Why C is correct:
GLOBALORGADMIN is the organization-level administrative role used for managing organization-wide features. Changing the refresh frequency for an auto-fulfilled application package requires this higher-level administrative authority.
Why the other options are incorrect:
A. ACCOUNTADMIN is the highest administrative role within a Snowflake account, but auto-fulfillment refresh frequency is an organization-level setting.
B. SYSADMIN manages account objects such as warehouses, databases, schemas, and tables, but it does not manage organization-level auto-fulfillment settings by default.
D. SECURITYADMIN manages users, roles, and grants, but it is not the default role for managing auto-fulfillment refresh frequency.
Official Snowflake documentation reference:
Snowflake documentation for auto-fulfillment and organization-level administration identifies GLOBALORGADMIN as the role used for managing organization-level Snowflake features.
Which typos of charts does Snowsight support? (Select TWO).
Area charts
Bar charts
Column charts
Radar charts
Scorecards
Snowsight, Snowflake’s user interface for executing and analyzing queries, supports various types of visualizations to help users understand their data better. Among the supported types, area charts and bar charts are two common options. Area charts are useful for representing quantities through the use of filled areas on the graph, often useful for showing volume changes over time. Bar charts, on the other hand, are versatile for comparing different groups or categories of data. Both chart types are integral to data analysis, enabling users to visualize trends, patterns, and differences in their data effectively.
Which COPY INTO < table > parameter is used to avoid loading a partial dataset?
FORCE = FALSE
RETURN_FAILED_ONLY = FALSE
LOAD_UNCERTAIN_FILES = FALSE
ON_ERROR = ABORT_STATEMENT
The correct answer is D. ON_ERROR = ABORT_STATEMENT .
ON_ERROR = ABORT_STATEMENT stops the load operation if an error is encountered. This helps avoid loading only part of a dataset when a file or row error occurs.
Why D is correct:
If the goal is to avoid a partial dataset, the load should fail rather than continue after errors. ABORT_STATEMENT prevents Snowflake from loading only the valid rows while skipping invalid ones.
Why the other options are incorrect:
A. FORCE = FALSE prevents reloading files that were already loaded, but it does not prevent partial loads caused by data errors.
B. RETURN_FAILED_ONLY affects command output reporting. It does not control whether partial data is loaded.
C. LOAD_UNCERTAIN_FILES = FALSE controls loading files with uncertain load status, but it is not the primary parameter for avoiding partial datasets caused by load errors.
D. ON_ERROR = ABORT_STATEMENT is the correct parameter because it stops the load when an error occurs.
Official Snowflake documentation reference:
Snowflake documentation for COPY INTO < table > describes ON_ERROR = ABORT_STATEMENT as the option that aborts the load operation when an error is encountered.
