ARA-C01 V3

Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)A . They can include ORDER BY clauses.B . They cannot include nested subqueries.C . They can include context functions, such as CURRENT_TIME().D . They can support MIN and MAX aggregates.E . They can support inner joins,...

Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)A . Changing the name of the organizationB . Creating an accountC . Viewing a list of organization accountsD . Changing the name of an accountE . Deleting an accountF . Enabling the replication of a databaseView AnswerAnswer: B,C,E

A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider. What is the MOST cost-effective way to bring this data into a...

A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period. What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose...

Which copy options are not supported by CREATE PIPE...AS COPY FROM command?A . FILES = ( 'file_name1' [ , 'file_name2', ... ] )B . FORCE = TRUE | FALSEC . ON_ERROR = ABORT_STATEMENTD . VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORSE . MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONEView AnswerAnswer:...

A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?A . Unmasked data will be loaded in the new column.B . Masked data will be loaded into...

You have created a table as below CREATE TABLE TEST_01 (NAME STRING(10)); What data type SNOWFLAKE will assign to column NAME?A . LONGCHARB . STRINGC . VARCHARView AnswerAnswer: C Explanation: Try it yourself Execute the below commands CREATE TABLE TEST_01 (NAME STRING(10)); DESCRIBE TABLE TEST_01;

You have create a task as below CREATE TASK mytask1 WAREHOUSE = mywh SCHEDULE = '5 minute' WHEN SYSTEM$STREAM_HAS_DATA('MYSTREAM') AS INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = 'INSERT'; Which statement is true below?A . If SYSTEM$STREAM_HAS_DATA returns false, the task will be skippedB . If SYSTEM$STREAM_HAS_DATA...

Which of the below operations are allowed on an inbound share data?A . MERGEB . CREATE/DROP/ALTER TABLEC . ALTER SCHEMAD . SELECT WITH JOINE . SELECT WITH GROUP BYF . INSERT INTOView AnswerAnswer: D,E Explanation: This is a trick question:) remember a share is read only, so you can only...

You have created a table as below CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); Which of the below select query will fail for this table?A . SELECT * from snowflake;B . SELECT * from Snowflake;C . SELECT * from "snowflake";D . SELECT * FROM "SNOWFLAKE";View AnswerAnswer: D Explanation: SQL identifiers...