- All Exams Instant Download
Schema owner can grant object privileges in a regular schema
Schema owner can grant object privileges in a regular schemaA . TRUE B. FALSEView AnswerAnswer: B Explanation: Another important topic to remember. Please also go through the difference between a managed schema and a regular schema https://docs.snowflake.com/en/user-guide/security-access-control-configure.html#creating-managed-acc ess-schemas
The insertReport endpoint can be thought of like the UNIX command tail
The insertReport endpoint can be thought of like the UNIX command tailA . TRUE B. FALSEView AnswerAnswer: A Explanation: An event occurs when data from a file submitted via insertFiles has been committed to the table and is available to queries. The insertReport endpoint can be thought of like the...
How do you refresh a materialized view?
How do you refresh a materialized view?A . ALTER VIEW <MV_NAME> REFRESH B. REFRESH MATERIALIZED VIEW <MV_NAME> C. Materialized views are automatically refreshed by snowflake and does not require manual interventionView AnswerAnswer: C Explanation: Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view...
While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.
While using joins, non-equality join predicates might result in significantly slower processing speeds and should be avoided if possible.A . TRUE B. FALSEView AnswerAnswer: A Explanation: non-equality JOINS are usually slower compared to equality joins. This is a very important thing to remember when you work on snowflake.
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 are those additional columns?
A stream stores data with the same columns as the source data but with additional columns. What are those additional columns?A . METADATA$ACTION B. METADATA$ISUPDATE C. METADATA$ROW_ID D. METADATA$DELETEView AnswerAnswer: A,B,C Explanation: https://docs.snowflake.com/en/user-guide/streams.html#stream-columns Stream Columns A stream stores data in the same shape as the source table (i.e. the same...
Which of the below objects cannot be replicated?
Which of the below objects cannot be replicated?A . Resource Monitors B. Warehouses C. Users D. Databases E. Shares F. RolesView AnswerAnswer: A,B,C,E,F Explanation: As of today(28-Nov-2020), only database replication is supported for an account. Other objects in the account cannot be replicated
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
Where can you define the file format settings?
Where can you define the file format settings?A . While creating named file formats B. In the table definition C. In the named stage definition D. Directly in the COPY INTO TABLE statement when loading dataView AnswerAnswer: A,B,C,D Explanation: Snowflake supports creating named file formats, which are database objects that...
What will be the impact on the table data?
You have set time-travel retention to 10 days. You now increase the retention period by 10 more days to make it 20 days. What will be the impact on the table data?A . Any data that is 10 days older and moved to fail-safe will not have any impact B....
