Join the discussion
Add Comments
- Other Question (76q)
- Q1. EXECUTE TASK privilege can be granted by whom
- Q2. A company's daily Snowflake workload consists of a huge number of concurrent queries trigg...
- Q3. What built-in Snowflake features make use of the change tracking metadata for a table? (Ch...
- Q4. Please select the correct hierarchy from below (Exhibit)...
- Q5. How do you refresh a materialized view?
- Q6. A table contains five columns and it has millions of records. The cardinality distribution...
- Q7. Which command will you run to list all privileges and roles granted to the role...
- Q8. You are running a large join on snowflake. You ran it on a medium warehouse and it took al...
- Q9. Snowflake includes administration settings for resource consumption in order to...
- Q10. SNOWPIPE_AUTO_INGEST is supported for external stages only...
- Q11. You have created a TASK in snowflake. How will you resume it?...
- Q12. You need to choose a high cardinality column for the clustering key...
- Q13. To increase performance, materialized views can be created on external table without any a...
- Q14. You have created a table as below CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE V...
- Q15. Arrange in order of performance(least to high) 1. External Table 2. External Table with pa...
- Q16. Who can provide permission to EXECUTE TASK?
- Q17. Which privilege grants ability to set a Column-level Security masking policy on a table or...
- Q18. Dynamic data masking is supported in which editions of snowflake...
- Q19. What is a valid object hierarchy when building a Snowflake environment?...
- Q20. Snowflake recommends starting slowly with SEARCH OPTIMIZATION(i.e. adding search optimizat...
- Q21. If your role does not own the share, but owns the objects in the share, how can you block ...
- Q22. Which of the following are characteristics of how row access policies can be applied to ex...
- Q23. An Architect is designing a pipeline to stream event data into Snowflake using the Snowfla...
- Q24. Which of the below commands will use warehouse credits?...
- Q25. Snowflake has row level security
- Q26. Which statement is not true about shared database?...
- Q27. Removing files from a stage after you are done loading the files improves performance when...
- Q28. A company has several sites in different regions from which the company wants to ingest da...
- Q29. A user can change object parameters using which of the following roles?...
- Q30. Assigning ACCOUNTADMIN as the default role for the account administrators is a best practi...
- Q31. An Architect has chosen to separate their Snowflake Production and QA environments using t...
- Q32. The insertReport endpoint can be thought of like the UNIX command tail...
- Q33. How do Snowflake databases that are created from shares differ from standard databases tha...
- Q34. If a multi-cluster warehouse is resized, the new size applies to...
- Q35. You ran the below query and it took a long time to run select itembarcode from checkouts w...
- Q36. A DevOps team has a requirement for recovery of staging tables used in a complex set of da...
- Q37. A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stor...
- Q38. Which of the below privileges are required for search optimization?...
- Q39. You have created a table as below CREATE TABLE EMPLOYEE(EMPLOYEE_ID NUMBER, EMPLOYEE_NAME ...
- Q40. You have a large warehouse with auto suspend configured for 10 minutes. You submitted a qu...
- Q41. At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY...
- Q42. Search optimization does not support Materialized views and External Tables...
- Q43. Data sharing is supported only between provider and consumer accounts in same region...
- Q44. Create a task and a stream following the below steps. So, when the system$stream_has_data(...
- Q45. A Data Engineer is designing a near real-time ingestion pipeline for a retail company to i...
- Q46. With default settings for multi cluster warehouse, how does snowflake determines when to s...
- Q47. If you run the below commands in your worksheet, what will happen? CREATE TEMP TABLE STUDE...
- Q48. You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. Af...
- Q49. Which feature provides the capability to define an alternate cluster key for a table with ...
- Q50. Which semi-structured data function returns an OBJECT constructed from the arguments....
- Q51. One of your joins is taking a lot of time. The query profile view looks like this. What ma...
- Q52. Where can you define the file format settings?...
- Q53. By default, the maximum file size that can be unloaded to a single file in snowflake is...
- Q54. COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE ...
- Q55. Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Ch...
- Q56. What is the recommended strategy to choose the right sized warehouse to achieve best perfo...
- Q57. You have a view. How will you list all the object references of the view?...
- Q58. It is recommended to assign ACCOUNTADMIN role to atleast two user...
- Q59. You have create a table in snowflake as below CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, ...
- Q60. There are two databases in an account, named fin_db and hr_db which contain payroll and em...
- Q61. You are creating a TASK to query a table streams created on the raw table and insert subse...
- Q62. select metadata$filename, metadata$file_row_number from @filestage/data1.json.gz; Please s...
- Q63. Cloud services can help in pruning even if the columns are variant columns....
- Q64. The IT Security team has identified that there is an ongoing credential stuffing attack on...
- Q65. Which statement is true about clustering key?
- Q66. Which command do you run to remove files from stage?...
- Q67. Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT...
- Q68. Which copy options are not supported by CREATE PIPE...AS COPY FROM command?...
- Q69. A large manufacturing company runs a dozen individual Snowflake accounts across its busine...
- Q70. You have an inventory table. You created two views on this table. The views look like as b...
- Q71. You have a need to make external file data available to your users with the lowest latency...
- Q72. An Architect needs to allow a user to create a database from an inbound share. To meet thi...
- Q73. You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in th...
- Q74. During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COP...
- Q75. One of your query is taking a long time to finish, when you open the query profiler you se...
- Q76. A company has an inbound share set up with eight tables and five secure views. The company...
