- All Exams Instant Download
Cloud services can help in pruning even if the columns are variant columns.
Cloud services can help in pruning even if the columns are variant columns.A . TRUE B. FALSEView AnswerAnswer: A Explanation: Snowflake stores internally variant (json) data, in a independent column like structure for the 100+ most common elements, and the remainder in a leftovers like column. Those virtual columns have...
Which command below will you choose?
You have created a table as below CREATE TABLE SNOWFLAKE_BLOG(BLOG_ID NUMBER, BLOG_CONTENT VARCHAR,BLOG_AUTHOR VARCHAR,BLOG_CREATE_DATE TIMESTAMP ); Now you want to cluster it by BLOG_AUTHOR and BLOG_CREATE_DATE. Which command below will you choose?A . ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR) B. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR, BLOG_CREATE_DATE); C. ALTER TABLE...
JSON and PARQUET files can be loaded to columns in the same table
JSON and PARQUET files can be loaded to columns in the same tableA . TRUE B. FALSEView AnswerAnswer: B Explanation: Let us try to answer some logical questions to arrive at the answer for this question
While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?
While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?A . Unlimited B. 3 to 4 C. Not more than 16 D. 32View AnswerAnswer: B Explanation: A single clustering key can contain one or more columns or...
Which alter command below may affect the availability of column with respect to time travel?
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
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...
What is the appropriate command to provide the access?
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...
What datatype Snowflake will use for EMPLOYEE_ID?
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 account
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?
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:...
