- All Exams Instant Download
What will you use?
In this scenarios, files are constantly getting ingested in an external stage, the files are between 1 and 4 MB. You want to load the data immediately into a table without any human intervention. What will you use?A . Create a materialize view on the external stage B. Use Snowpipe...
As of today snowflake supports replication for databases only
As of today snowflake supports replication for databases onlyA . TRUE B. FALSEView AnswerAnswer: A Explanation: Other Objects in an Account Currently, replication is supported for databases only. Other types of objects in an account cannot be replicated. This list includes: Users Roles Warehouses Resource monitors Shares
Snowflake data replication can be used to replicate data between cloud providers.
Snowflake data replication can be used to replicate data between cloud providers.A . TRUE B. FALSEView AnswerAnswer: A Explanation: DATABASE REPLICATION SOLUTIONS Snowflake has launched its public preview of a new feature: Database Replication. Customers using Snowflake Standard edition and above can rely on this feature for non-business continuity and...
You ran the below query and it took a long time to run
You ran the below query and it took a long time to run select itembarcode from checkouts where BIBNUMBER = '2213435'; The clustering information shows the below result. What can you derive from this information select system$clustering_information('checkouts','(BIBNUMBER)'); A . The data is not clustered well by BIBNUMBER and it is...
Who can provide permission to EXECUTE TASK?
Who can provide permission to EXECUTE TASK?A . ACCOUNTADMIN B. THE TASK OWNER C. SYSADMINView AnswerAnswer: A Explanation: If the role does not have the EXECUTE TASK privilege, assign the privilege as an account administrator (user with the ACCOUNTADMIN role), e.g.: use role accountadmin; grant execute task on account to...
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....
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULLA . An error is returned and no changes are applied to the column B. Snowflake automatically assigns a default value and let the change happen C. Snowflake drops the row and...
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...
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 conditions should be true for a table to consider search optimization
What conditions should be true for a table to consider search optimizationA . The table size is at least 100 GB B. The table is not clustered OR The table is frequently queried on columns other than the primary cluster key C. The table can be of any sizeView AnswerAnswer:...
