- All Exams Instant Download
Which of the below are securable objects?
Which of the below are securable objects?A . USER B. ROLE C. PRIVILEDGE D. TABLE E. DATABASEView AnswerAnswer: A,B,D,E Explanation: Securable object is an entity to which access can be granted. Unless allowed by a grant, access will be denied Every securable object resides within a logical container in a...
Which command below will only copy the table structure from the existing table to the new table?
Which command below will only copy the table structure from the existing table to the new table?A . CREATE TABLE … AS SELECT B. CREATE TABLE … LIKE C. CREATE TABLE … CLONEView AnswerAnswer: B Explanation: CREATE TABLE … LIKE Creates a new table with the same column definitions as...
What will the below query return
What will the below query return SELECT TOP 10 GRADES FROM STUDENT;A . The top 10 highest grades B. The 10 lowest grades C. Non-deterministic list of 10 gradesView AnswerAnswer: C Explanation: An ORDER BY clause is not required; however, without an ORDER BY clause, the results are non-deterministic because...
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.A . TRUE B. FALSEView AnswerAnswer: A Explanation: All files stored in internal stages (for data loading/unloading) automatically encrypted (using either AES 128 standard or 256 strong encryption). https://docs.snowflake.com/en/user-guide/admin-security.html Please note if using external...
It is recommended to assign ACCOUNTADMIN role to atleast two user
It is recommended to assign ACCOUNTADMIN role to atleast two userA . TRUE B. FALSEView AnswerAnswer: A Explanation: Control the Assignment of the ACCOUNTADMIN Role to Users We strongly recommend the following precautions when assigning the ACCOUNTADMIN role to users: Assign this role only to a select/limited number of people...
Snowflake supports the following query performance optimizing methods
Snowflake supports the following query performance optimizing methodsA . Caching techniques B. Retrieving results of previous query from cache C. B-tree type indexesView AnswerAnswer: A,B Explanation: Snowflake does not have any support for indexes yet.
Which mode will you use for the warehouse?
You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly. Which mode will you use for the warehouse?A . Maximized B. Auto-Scale C. MinimizedView AnswerAnswer:...
Which of the below objects cannot be replicated from one region to the other?
Which of the below objects cannot be replicated from one region to the other?A . File Formats B. Sequences C. Pipes D. Views E. Materialized views F. StreamsView AnswerAnswer: C,F Explanation: As of today(27-Nov-2020), below objects cannot be replicated
Multi-cluster warehouses are best utilized for
Multi-cluster warehouses are best utilized forA . Scaling resources to improve concurrency for users/queries B. Improving the performance of slow-running queries C. Improving the performance of data loadingView AnswerAnswer: A Explanation: Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries. They are not as beneficial for...
Which of the two are limitations of the insertReport API of SnowPipe?
Which of the two are limitations of the insertReport API of SnowPipe?A . The 10,000 most recent events are retained B. Events are retained for a maximum of 10 minutes C. Events are retained for a maximum of 24 hoursView AnswerAnswer: A,B Explanation: Endpoint: insertReport Retrieves a report of files...
