- All Exams Instant Download
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....
Removing files from a stage after you are done loading the files improves performance when subsequently loading data
Removing files from a stage after you are done loading the files improves performance when subsequently loading dataA . TRUE B. FALSEView AnswerAnswer: A Explanation: Managing Unloaded Data Files Staged files can be deleted from a Snowflake stage using the REMOVE command to remove the files in the stage after...
When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary database
When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary databaseA . TRUE B. FALSEView AnswerAnswer: A Explanation: Replication of clone table replicates the data as well. This increases your data storage cost.
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practiceA . TRUE B. FALSEView AnswerAnswer: B Explanation: To help prevent account administrators from inadvertently using the ACCOUNTADMIN role to create objects, assign these users additional roles and designate one of these roles as their default (i.e....
