ARA-C01 SnowPro Advanced Architect Certification exam is a hot Snowflake certification exam, Exam4Training offers you the latest free online ARA-C01 dumps to practice. You can get online training in the following questions, all these questions are verified by Snowflake experts. If this exam changed, we will share new update questions.
Which command can be run to list all shares that have been created in your account or are available to consume by your account A . SHOW SHARES
B. LIST SHARES
C. DESCRIBE SHARES
Lists all shares available in the system:
Outbound shares (to consumers) that have been created in your account (as a provider). Inbound shares (from providers) that are available for your account to consume. https://docs.snowflake.com/en/sql-reference/sql/show-shares.html#show-shares
COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV A . GZIP
Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use BROTLI instead of AUTO. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#type-csv
You need to choose a high cardinality column for the clustering key A . TRUE
A column with very low cardinality (e.g. a column that indicates only whether a person is male or female) might yield only minimal pruning. At the other extreme, a column with very high cardinality (e.g. a column containing UUID or nanosecond timestamp values) is also typically not a good candidate to use as a clustering key directly.
Which alter command below may affect the availability of column with respect to time travel? A . ALTER TABLE…DROP COLUMN
B. ALTER TABLE…SET DATA TYPE
C. ALTER TABLE…SET DEFAULT
If the precision of a column is decreased below the maximum precision of any column data retained in Time Travel, you will not be able to restore the table without first increasing the precision. The precision of a column data can only be altered using the ALTER TABLE …SET DATA TYPE command.
Hence, ALTER TABLE…SET DATA TYPE is the most appropriate answer https://docs.snowflake.com/en/sql-reference/sql/alter-table-column.html#alter-table-alter-column