NWEA Fund Day 4 Review

Which are true about FORMATS?

• File formats store data of a particular type
• A file format stores information needed to parse input files for loading
• You must specify a file format as part of every COPY INTO command
• The default file format is CSV

Which are true about STAGES?

• A stage is a cloud file respository
• A stage can be internal or external
• Stages disappear as soon as all files are loaded
• You can manually create named stages, user stages, or table stages

What type of stage does this command use? COPY INTO mytable FROM @mystage

• EXTERNAL
• INTERNAL NAMED
• Either INTERNAL NAMED or EXTERNAL
• TABLE
• USER

Using AUTO_INGEST, Snowpipe can load files from both internal and external stages

• True
• False

Which can run with either owner's rights or caller's rights?

• VIEW
• Stored Procedure
• UDF

Which must return a value?

• UDF
• Stored Procedure

Which can contain DML and DDL statements?

• UDF
• Stored Procedure

How do you invoke a stored procedure?

• RUN
• CALL
• EXEC
• GOTO

What type of function is being called in this statement: SELECT SUM(c1) FROM t1

• Aggregate
• Window
• Scalar
• Table

Where is Snowflake responsible for encrypting data?

• Tables
• Materialized Views
• External Stages
• Internal Stages