ARA-C01 exam

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 DEFAULTView AnswerAnswer: B Explanation: If the precision of a column is decreased below the maximum precision of any column data retained in Time...

You have an inventory table. You created two views on this table. The views look like as below CREATE VIEW NON_SECURE_INVENTORY AS SELECT BIBNUMBER, TITLE, AUTHOR,ISBN FROM INVENTORY WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063); CREATE SECURE VIEW SECURE_INVENTORY AS SELECT BIBNUMBER, TITLE, AUTHOR,ISBN FROM INVENTORY WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063); You ran the below queries...

A user needs access to create materialized view on a shema mydb.myschema. What is the appropriate command to provide the access?A . GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE; B. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1; C. GRANT...

You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME VARCHAR); What datatype Snowflake will use for EMPLOYEE_ID?A . FIXED B. INTEGER C. NUMBERView AnswerAnswer: A Explanation: Please try this for yourself. Note that this advanced certification requires working experience, so some of these hands-on will help in...

You have created a reader account for sharing data. who will pay for the compute usage of the accountA . Provider B. ConsumerView AnswerAnswer: A Explanation: Reader account is a way to share data with stakeholders who do not have any snowflake account. They will use providers warehouse for compute.

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

Databases created from shares cannot be replicatedA . TRUE B. FALSEView AnswerAnswer: A Explanation: Current Limitations of Replication Refreshing a secondary database is blocked if an external table exists in the primary database. Databases created from shares cannot be replicated. https://docs.snowflake.com/en/user-guide/database-replication-intro.html#current-limitations-of-replicatio n

You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required. What type of table you will...

By executing the 'SHOW TABLES' command, we can list all the tables in all the schemas even if we do not have access to all the tablesA . TRUE B. FALSEView AnswerAnswer: B Explanation: SHOW TABLES Lists the tables for which you have access privileges, including dropped tables that are...

Shares are first-class objects in Snowflake for which Snowflake provides a set of DDL commands for creating and managing sharesA . TRUE B. FALSEView AnswerAnswer: A Explanation: The first step in sharing data is to specify what database objects to share with specified consumers. This is done via a data...