Join the discussion
Question 1/100
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Correct Answer: B
Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556
Add Comments
- Other Question (100q)
- Q1. Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Da...
- Q2. How many shares can be consumed by single Data Consumer?...
- Q3. True or False: Micro-partition metadata enables some operations to be completed without re...
- Q4. Which formats are supported for unloading data from Snowflake? Choose 2 answers...
- Q5. Which of the following statements describes a benefit of Snowflake's separation of compute...
- Q6. Which interfaces can be used to create and/or manage Virtual Warehouses?...
- Q7. What is the default file size when unloading data from Snowflake using the COPY command?...
- Q8. When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scalin...
- Q9. What is a limitation of a Materialized View?
- Q10. Which statement best describes '' clustering''?...
- Q11. Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two...
- Q12. True or False: Snowpipe via REST API can only reference External Stages as source....
- Q13. True or False: It is possible to unload structured data to semi-structured formats such as...
- Q14. True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake...
- Q15. True or False: You can query the files in an External Stage directly without having to loa...
- Q16. True or False: Snowflake charges additional fees to Data providers for each share they cre...
- Q17. Which of the following features, associated with Continuous Data Protection (CDP), require...
- Q18. The FLATEEN function is used to query which type of data in Snowflake?...
- Q19. True or false: it is best practice to define a clustering key on every table....
- Q20. Which of the following Snowflake capabilities are available in all Snowflake editions? (Se...
- Q21. Which of the following significantly improves the performance of selective point lookup qu...
- Q22. The Snowflake cloud services layer is responsible for which tasks? (Choose two.)...
- Q23. Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally resul...
- Q24. What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 ...
- Q25. What is the purpose of multi-cluster virtual warehouses?...
- Q26. What internal stages are available in Snowflake? (Choose three.)...
- Q27. What is the minimum Snowflake edition that provides data sharing?...
- Q28. What is the recommended Snowflake data type to store semi-structured data like JSON?...
- Q29. True or False: Snowflake's Global Services Layer gathers and maintains statistics on all c...
- Q30. Which command can be used to stage local files from which Snowflake interface?...
- Q31. True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it ...
- Q32. Which statements are true of micro-partitions? Choose 2 answers...
- Q33. Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)...
- Q34. Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)...
- Q35. A user is preparing to load data from an external stage Which practice will provide the MO...
- Q36. How would you determine the size of the virtual warehouse used for a task?...
- Q37. A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend...
- Q38. Which privilege must be granted to a share to allow secure views the ability to reference ...
- Q39. Which of the following roles is recommended to be used to create and manage users and role...
- Q40. True or False: Reader Accounts incur no additional Compute costs to the Data Provider sinc...
- Q41. Why would a customer size a Virtual Warehouse from an X-Small to a Medium?...
- Q42. Query results are stored in the Result Cache for how long after they are last accessed, as...
- Q43. A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of...
- Q44. What command is used to load files into an Internal Stage within Snowflake? Select one....
- Q45. Which object allows you to limit the number of credits consumed within a Snowflake account...
- Q46. What affects whether the query results cache can be used?...
- Q47. A Virtual Warehouse's auto-suspend and auto-resume settings apply to:...
- Q48. What is the maximum compressed row size in Snowflake?...
- Q49. What is cached during a query on a virtual warehouse?...
- Q50. Which of the following activities consume virtual warehouse credits in the Snowflake envir...
- Q51. Snowflake supports the use of external stages with which cloud platforms? (Choose three.)...
- Q52. Which of the following describes how multiple Snowflake accounts in a single organization ...
- Q53. Which of the following can be used when unloading data from Snowflake? (Choose two.)...
- Q54. True or False: Fail-safe can be disabled within a Snowflake account....
- Q55. What impacts the credit consumption of maintaining a materialized view? (Choose two.)...
- Q56. Which object allows you to limit the number of credits consumed within a Snowflake account...
- Q57. True or false: Snowflake enforces unique, primary key, and foreign key constraints during ...
- Q58. What are the three things customers want most from their enterprise data warehouse solutio...
- Q59. What is an advantage of using an explain plan instead of the query profiler to evaluate th...
- Q60. True or False: Reader Accounts are able to extract data from shared data objects for use o...
- Q61. A company's security audit requires generating a report listing all Snowflake logins (e.g....
- Q62. True or False: It is possible to query data from an Internal or named External stage witho...
- Q63. Which of the following are benefits of micro-partitioning? (Select TWO)...
- Q64. Which of the following statements are true of Snowflake releases: (Choose two.)...
- Q65. Which type of table corresponds to a single Snowflake session?...
- Q66. Which of the following objects can be shared through secure data sharing?...
- Q67. True or False: When a new Snowflake object is created, it is automatically owned by the us...
- Q68. Which of the following statements are true of Snowflake data loading? Choose 3 answers...
- Q69. Which of the following statements describe features of Snowflake data caching? (Choose two...
- Q70. What is the minimum Snowflake edition needed for database failover and fail-back between S...
- Q71. Which copy INTO command outputs the data into one file?...
- Q72. A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements w...
- Q73. If 3 size Small virtual warehouse is made up of two servers, how many servers make up a La...
- Q74. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:...
- Q75. True or False: The user has to specify which cluster a query will run on in multi-clusteri...
- Q76. What actions will prevent leveraging of the ResultSet cache? (Choose two.)...
- Q77. True or False: The COPY command must specify a File Format in order to execute....
- Q78. Which of the following commands sets the Virtual Warehouse for a session?...
- Q79. True or False: Reader Accounts are able to extract data from shared data objects for use o...
- Q80. Which stage type can be altered and dropped?
- Q81. Which type of table corresponds to a single Snowflake session?...
- Q82. In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONO...
- Q83. What features that are part of the Continuous Data Protection (CDP) feature set in Snowfla...
- Q84. Which of the following statements is true of zero-copy cloning?...
- Q85. A virtual warehouse's auto-suspend and auto-resume settings apply to which of the followin...
- Q86. True or False: Loading data into Snowflake requires that source data files be no larger th...
- Q87. True or False: It is possible to unload structured data to semi-structured formats such as...
- Q88. In which scenarios would a user have to pay Cloud Services costs? (Select TWO)....
- Q89. Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)...
- Q90. What services does Snowflake automatically provide for customer that they may have been re...
- Q91. What is the default character set used when loading CSV files into Snowflake?...
- Q92. Snowflake is designed for which type of workloads? (Choose two.)...
- Q93. When can a Virtual Warehouse start running queries?...
- Q94. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:...
- Q95. A sales table FCT_SALES has 100 million records. The following Query was executed SELECT C...
- Q96. A developer is granted ownership of a table that has a masking policy. The developer's rol...
- Q97. True or False: An active warehouse is required to run a COPY INTO statement....
- Q98. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:...
- Q99. How would a user run a multi-cluster warehouse in maximized mode?...
- Q100. When a Pipe is recreated using the CREATE OR REPLACE PIPE command:...
[×]
Download PDF File
Enter your email address to download Snowflake.SnowPro-Core.v2023-05-03.q100.pdf