Join the discussion
Question 1/109
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
Which Snowflake feature will support this?
Correct Answer: D
Add Comments
- Other Question (109q)
- Q1. A company needs to allow some users to see Personally Identifiable Information (PII) while...
- Q2. Which of the following statements describes a schema in Snowflake?...
- Q3. What is an advantage of using an explain plan instead of the query profiler to evaluate th...
- Q4. Which semi-structured file formats are supported when unloading data from a table? (Select...
- Q5. Select the different types of Internal Stages: (Choose three.)...
- Q6. A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend...
- Q7. True or False: When a new Snowflake object is created, it is automatically owned by the us...
- Q8. What privileges are required to create a task?...
- Q9. True or False: It is possible to load data into Snowflake without creating a named File Fo...
- Q10. What happens when a cloned table is replicated to a secondary database? (Select TWO)...
- Q11. Which is the MINIMUM required Snowflake edition that a user must have if they want to use ...
- Q12. In a Snowflake role hierarchy, what is the top-level role?...
- Q13. What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 ...
- Q14. Which of the following statements is true of Snowflake?...
- Q15. What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-parti...
- Q16. Which of the following are considerations when using a directory table when working with u...
- Q17. True or False: It is possible to query data from an Internal or named External stage witho...
- Q18. Snowflake supports the use of external stages with which cloud platforms? (Choose three.)...
- Q19. How does Snowflake allow a data provider with an Azure account in central Canada to share ...
- Q20. Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose...
- Q21. The fail-safe retention period is how many days?...
- Q22. A data provider wants to share data with a consumer who does not have a Snowflake account....
- Q23. Which privilege must be granted to a share to allow secure views the ability to reference ...
- Q24. Which formats does Snowflake store unstructured data in? (Choose two.)...
- Q25. Which statement describes how Snowflake supports reader accounts?...
- Q26. Which of the following statements would be used to export/unload data from Snowflake?...
- Q27. True or False: Snowpipe via REST API can only reference External Stages as source....
- Q28. What is the minimum Snowflake edition required for row level security?...
- Q29. What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake...
- Q30. True or False: Query ID's are unique across all Snowflake deployments and can be used in c...
- Q31. In which scenarios would a user have to pay Cloud Services costs? (Select TWO)....
- Q32. The number of queries that a Virtual Warehouse can concurrently process is determined by: ...
- Q33. Which Snowflake architectural layer is responsible for a query execution plan?...
- Q34. What is the minimum Snowflake edition that has column-level security enabled?...
- Q35. What features that are part of the Continuous Data Protection (CDP) feature set in Snowfla...
- Q36. A user has an application that writes a new Tile to a cloud storage location every 5 minut...
- Q37. What are common issues found by using the Query Profile? (Choose two.)...
- Q38. Which stage type can be altered and dropped?
- Q39. Which of the following indicates that it may be appropriate to use a clustering key for a ...
- Q40. True or False: Loading data into Snowflake requires that source data files be no larger th...
- Q41. Which of the following connectors allow Multi-Factor Authentication (MFA) authorization wh...
- Q42. True or False: Micro-partition metadata enables some operations to be completed without re...
- Q43. How long is Snowpipe data load history retained?...
- Q44. A developer is granted ownership of a table that has a masking policy. The developer's rol...
- Q45. What is the maximum Time Travel retention period for a temporary Snowflake table?...
- Q46. True or False: The COPY command must specify a File Format in order to execute....
- Q47. What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects wer...
- Q48. What do the terms scale up and scale out refer to in Snowflake? (Choose two.)...
- Q49. When unloading to a stage, which of the following is a recommended practice or approach?...
- Q50. Which command can be used to stage local files from which Snowflake interface?...
- Q51. Which of the following can be used when unloading data from Snowflake? (Choose two.)...
- Q52. The first user assigned to a new account, ACCOUNTADMIN, should create at least one additio...
- Q53. Will data cached in a warehouse be lost when the warehouse is resized?...
- Q54. What is true about sharing data in Snowflake? (Choose two.)...
- Q55. Which services does the Snowflake Cloud Services layer manage? (Choose two.)...
- Q56. Which data types are supported by Snowflake when using semi-structured data? (Choose two.)...
- Q57. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:...
- Q58. True or False: Fail-safe can be disabled within a Snowflake account....
- Q59. A role is created and owns 2 tables. This role is then dropped. Who will now own the two t...
- Q60. Which of the following statements are true of Snowflake releases: (Choose two.)...
- Q61. Which statement describes pruning?
- Q62. What are advantages clones have over tables created with CREATE TABLE AS SELECT statement?...
- Q63. What are supported file formats for unloading data from Snowflake? (Choose three.)...
- Q64. Which command sets the Virtual Warehouse for a session?...
- Q65. True or False: Snowflake's Global Services Layer gathers and maintains statistics on all c...
- Q66. What is a best practice after creating a custom role?...
- Q67. Which of the following are options when creating a Virtual Warehouse?...
- Q68. Which account__usage views are used to evaluate the details of dynamic data masking? (Sele...
- Q69. What is a responsibility of Snowflake's virtual warehouses?...
- Q70. What happens when a virtual warehouse is resized?...
- Q71. Which of the following objects is not covered by Time Travel?...
- Q72. Which of the following are handled by the cloud services layer of the Snowflake architectu...
- Q73. A running virtual warehouse is suspended. What is the MINIMUM amount of time that the ware...
- Q74. Which Snowflake object enables loading data from files as soon as they are available in a ...
- Q75. Which of the following commands cannot be used within a reader account?...
- Q76. What data is stored in the Snowflake storage layer? (Select TWO)....
- Q77. Which of the following describes external functions in Snowflake?...
- Q78. A user created a transient table and made several changes to it over the course of several...
- Q79. What COPY INTO SQL command should be used to unload data into multiple files?...
- Q80. Which of the following significantly improves the performance of selective point lookup qu...
- Q81. Which command should be used to download files from a Snowflake stage to a local folder on...
- Q82. How would a user run a multi-cluster warehouse in maximized mode?...
- Q83. Which of the following compute resources or features are managed by Snowflake? (Select TWO...
- Q84. Which TABLE function helps to convert semi-structured data to a relational representation?...
- Q85. What Snowflake role must be granted for a user to create and manage accounts?...
- Q86. True or False: Snowflake's data warehouse was built from the ground up for the cloud in li...
- Q87. A user has unloaded data from Snowflake to a stage Which SQL command should be used to val...
- Q88. Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)...
- Q89. Which stages are used with the Snowflake PUT command to upload files from a local file sys...
- Q90. A user is preparing to load data from an external stage Which practice will provide the MO...
- Q91. Which cache type is used to cache data output from SQL queries?...
- Q92. Which privilege is required for a role to be able to resume a suspended warehouse if auto-...
- Q93. What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise ...
- Q94. Which statement is true about running tasks in Snowflake?...
- Q95. Which of the following roles is recommended to be used to create and manage users and role...
- Q96. A table needs to be loaded. The input data is in JSON format and is a concatenation of mul...
- Q97. What tasks can be completed using the copy command? (Select TWO)...
- Q98. What is the recommended compressed file size range for continuous data loads using Snowpip...
- Q99. What feature can be used to reorganize a very large table on one or more columns?...
- Q100. Which Snowflake objects track DML changes made to tables, like inserts, updates, and delet...
- Q101. True or False: A customer using SnowSQL / native connectors will be unable be unable to ab...
- Q102. What is the minimum Snowflake edition that customers planning on storing protected informa...
- Q103. If a Snowflake user decides a table should be clustered, what should be used as the cluste...
- Q104. When can a Virtual Warehouse start running queries?...
- Q105. Which of the following practices are recommended when creating a user in Snowflake? (Choos...
- Q106. Credit charges for Snowflake virtual warehouses are calculated based on which of the follo...
- Q107. The following JSON is stored in a VARIANT column called src of the CAR_SALES table: (Exhib...
- Q108. Where is Snowflake metadata stored?
- Q109. The is the minimum Fail-safe retention time period for transient tables?...
