DumpsFiles
 Request Exam  Contact
  • Home
  • PRACTICE EXAMS
    Oracle
    Fortinet
    IBM
    Juniper
    Microsoft
    Cisco
    Citrix
    CompTIA
    VMware
    ISC
    SAP
    EMC
    PMI
    HP
    Salesforce
    Other
  • View All Exams
  • New Dumps Files
  • Upload
  • Oracle
    Oracle
  • Fortinet
    Fortinet
  • IBM
    IBM
  • Juniper
    Juniper
  • Microsoft
    Microsoft
  • Cisco
    Cisco
  • Citrix
    Citrix
  • CompTIA
    CompTIA
  • VMware
    VMware
  • ISC
    ISC
  • SAP
    SAP
  • EMC
    EMC
  • PMI
    PMI
  • HP
    HP
  • Salesforce
    Salesforce
  1. Home
  2. Snowflake
  3. Snowflake Certified SnowPro Associate - Platform Certification
  4. Snowflake.SOL-C01.v2026-04-25.q125
  5. Question 4

Join the discussion

Question 4/125

What types of privileges can be granted to a role in Snowflake?

Correct Answer: D
Snowflake usesrole-based access control (RBAC), where privileges are assigned to roles rather than individual users. All of the listed privileges (SELECT, INSERT, MONITOR) can be granted to a role.
* SELECTallows reading data from tables, views, or materialized views.
* INSERTallows adding new rows into a table.
* MONITORallows viewing query history, warehouse status, and resource usage.
In addition, roles can receive privileges such as CREATE TABLE, USAGE, MODIFY, OPERATE, OWNERSHIP, and many others. Users inherit all privileges assigned to the roles they possess, enabling scalable security design.
Thus, all listed privileges can be granted to Snowflake roles.

Add Comments

Your email address will not be published. Required fields are marked *

insert code
Type the characters from the picture.
Rating:
Other Question (125q)
Q1. What types of worksheets can be created in Snowsight? (Select TWO)....
Q2. You need to create a database named 'SALES DB' that is only accessible to users with the '...
Q3. You have created a virtual warehouse in Snowflake and loaded data into several tables. You...
Q4. What types of privileges can be granted to a role in Snowflake?...
Q5. You are using the Snowsight user interface to monitor the performance of a Snowflake wareh...
Q6. Consider the following scenario: A Snowflake database `SALES DB contains a table 'CUSTOMER...
Q7. You are working with a semi-structured JSON dataset containing information about products....
Q8. You are using the Snowflake web interface to execute SQL queries. You want to save a speci...
Q9. You are using Snowflake Notebooks to create a visualization based on data retrieved from a...
Q10. You have a Snowflake environment with several databases and schemas. You need to identify ...
Q11. A data engineer wants to transfer ownership of a database named 'SALES DATA' to a role nam...
Q12. What information can be accessed using the Snowsight Monitoring tab?...
Q13. You have a Snowflake environment with a database named 'ANALYTICS DB'. You need to load da...
Q14. You have a Snowflake table named 'products' with columns 'product id', 'product_name', and...
Q15. Which of the following are examples of system-defined roles in Snowflake? (Choose any 3 op...
Q16. A financial institution needs to maintain a record of all changes made to its customer dat...
Q17. You are developing a Snowflake Notebook to analyze sales data. You need to connect to a Sn...
Q18. What does "warehouse scaling in/out" refer to in Snowflake?...
Q19. You are designing a data ingestion pipeline in Snowflake using Snowsight to load JSON data...
Q20. You have enabled directory tables on an external stage pointing to an AWS S3 bucket. The S...
Q21. A data engineering team is tasked with building a data pipeline that ingests semi-structur...
Q22. Which statement is true about Snowflake Data Exchange? (Choose any 2 options)...
Q23. What is Snowflake Data Exchange used for?
Q24. You are tasked with deploying a new data application to Snowflake. This application requir...
Q25. A Snowflake administrator wants to ensure that a specific virtual warehouse used for data ...
Q26. Which of the following statements correctly describes the benefits of Snowflake's Data Clo...
Q27. Within a Snowflake Notebook, you have defined a Python variable named 'warehouse_size' wit...
Q28. You have a virtual warehouse named `REPORTING that you want to resize from 'MEDIUM' to 'LA...
Q29. You are a data provider and want to share a table 'SALES DATA with two different consumer ...
Q30. A data engineer needs to create a table in Snowflake to store JSON data from an external A...
Q31. Which SQL command is used to create a new database in Snowflake?...
Q32. A Snowflake administrator needs to audit all grants and revocations performed on a specifi...
Q33. Which SQL clause is used to query historical data in Snowflake using Time Travel?...
Q34. What are the key benefits of the Snowflake multi-cluster shared data architecture? (Select...
Q35. A Snowflake administrator observes slow query performance when querying data loaded from a...
Q36. How can Snowsight be used to monitor the performance of a virtual warehouse?...
Q37. Which two actions are possible within a single Snowflake Notebook session? (Choose two)...
Q38. You are creating a table 'ORDERS' to store customer orders and need to include an 'ORDER I...
Q39. A data engineer is tasked with loading JSON data representing customer interactions into S...
Q40. What is the Snowsight object browser used for?...
Q41. A Snowflake environment has two databases, 'DEV DB' and 'PROD DB'. A table 'EMPLOYEES' exi...
Q42. How can users integrate Streamlit with Snowflake notebooks?...
Q43. A data team is using a Snowflake virtual warehouse for both ETL processes and ad-hoc repor...
Q44. A Snowflake user reports that their worksheet intermittently freezes or becomes unresponsi...
Q45. A data scientist is working on a machine learning project using Snowflake Notebooks. They ...
Q46. Which data type in Snowflake is best suited for storing semi-structured data like JSON or ...
Q47. A Snowflake administrator needs to determine the default collation setting for a newly cre...
Q48. What is a key characteristic of the Snowflake architecture's Cloud Services Layer?...
Q49. You're building a Snowflake Notebook to automate data quality checks on a daily basis. You...
Q50. Which SQL command is commonly used to load structured data from a stage into a Snowflake t...
Q51. A data engineer is loading data into Snowflake from an external stage. They need to transf...
Q52. In a Snowflake Notebook, you're attempting to read data from a Snowflake table named 'CUST...
Q53. What is the purpose of using the SHOW GRANTS ON SQL command for a specific object?...
Q54. Which of the following are examples of semi-structured data formats? (Choose any 3 options...
Q55. You have a table 'CUSTOMER REVIEWS' with a column 'REVIEW TEXT containing unstructured cus...
Q56. What is the CREATE FILE FORMAT command used for in Snowflake?...
Q57. A data engineer is tasked with migrating a legacy data warehouse to Snowflake. They need t...
Q58. A data engineer needs to transfer ownership of a database named 'SALES DATA' to a role nam...
Q59. You are using PARSE DOCUMENT on documents stored in an external stage. You notice that som...
Q60. A Snowflake administrator needs to load data from multiple compressed (gzip) CSV files loc...
Q61. Consider the following SQL code snippet intended to insert data into a Snowflake table nam...
Q62. A Snowflake table 'ORDERS' contains a 'ORDER DATE' column of data type DATE. You need to w...
Q63. What is the purpose of the COMPLETE function in Snowflake Cortex?...
Q64. Which command can be used to query the Information Schema in Snowflake to retrieve a list ...
Q65. Which types of stages are supported in Snowflake for data loading and unloading? (Select T...
Q66. A data analyst needs to create a view named that aggregates sales data by month. The base ...
Q67. A company stores unstructured text data (PDFs, DOCX) in an external stage (AWS S3). They w...
Q68. You are tasked with loading data from a set of CSV files located in an Amazon S3 bucket in...
Q69. A data warehouse contains a table named 'ORDERS in schema `SALES'. The current owner of th...
Q70. Which function would you use to determine the sentiment of a customer review in Snowflake ...
Q71. A Snowflake data engineer is tasked with optimizing the performance of daily data loads in...
Q72. You are loading data from a CSV file stored in an AWS S3 bucket into a Snowflake table. Th...
Q73. Your team has set up an automated data pipeline to load data into Snowflake using the *COP...
Q74. Which of the following Snowflake functions is used to generate pre-signed URLs for accessi...
Q75. You are tasked with creating a table `EMPLOYEES in Snowflake to store employee data. The t...
Q76. Which layer of Snowflake's architecture provides security features like encryption and aut...
Q77. In the Snowsight Query History, what attribute uniquely identifies each query?...
Q78. A team is developing a data pipeline to load data from various sources into Snowflake. The...
Q79. You are using Snowsight to monitor the performance of several queries. You notice a query ...
Q80. What file extension is commonly used for Snowflake notebooks?...
Q81. Which of the following is a potential use case for the CLASSIFY_TEXT function?...
Q82. A user is trying to transfer ownership of a view from role `role_a' to The user executes t...
Q83. Which of the following is a key feature of Snowflake's Data Storage Layer? (Select 2 optio...
Q84. What is the purpose of a role hierarchy in Snowflake?...
Q85. You have a Snowflake table named 'SALES DATA' that you load data into daily from a CSV fil...
Q86. You're developing a Snowflake Notebook to automate data loading from an external stage. Yo...
Q87. Which of the following statements are true regarding schemas in Snowflake? (Select TWO)...
Q88. A data science team needs to access data from several databases and schemas for model trai...
Q89. How do you enable a Directory Table for an external stage in Snowflake?...
Q90. What syntax will enable the use of a Python string variable named myvar in a SQL cell with...
Q91. Using Snowsight, you observe a query with the following SQL: FROM LARGE_TABLE WHERE ID IN ...
Q92. A Snowflake user is attempting to query a table named 'CUSTOMERS within the `SALES DB.PUBL...
Q93. A user executes the following SQL command in Snowflake: `SELECT CURRENT DATABASE(), CURREN...
Q94. What are Snowflake notebooks primarily used for?...
Q95. A Snowflake table 'ORDERS' contains order data, including a `ORDER DATE' column of type DA...
Q96. What is the PRIMARY purpose for using the PARSE_DOCUMENT function when using a Cortex LLM?...
Q97. You are working with Snowflake Cortex and the COMPLETE function to generate marketing copy...
Q98. Which Snowflake Cortex LLM function allows a user to specify which model will be used?...
Q99. A data engineer is tasked with designing a Snowflake solution for a financial services com...
Q100. What a Database in Snowflake cant contain?
Q101. You are working with a Snowflake database that contains sensitive personal data. You need ...
Q102. You are designing a data warehouse in Snowflake and need to load data from various sources...
Q103. You have a Python script that uses Snowpark to connect to Snowflake. You want to ensure th...
Q104. A Snowflake administrator is tasked with managing storage costs. They notice that several ...
Q105. You have a table named 'SALES DATA' in your Snowflake account. You want to create a clone ...
Q106. You are developing a Snowflake Notebook to perform data transformations using Snowpark. As...
Q107. Which of the following statements are true regarding considerations when working with VARI...
Q108. What is a key feature of Snowflake notebooks?
Q109. A Snowflake table named 'ORDERS' contains columns: `ORDER ID (NUMBERY, `CUSTOMER ID (NUMBE...
Q110. You are designing a data warehouse in Snowflake and need to implement a role-based access ...
Q111. A data team is designing a data pipeline that loads data from S3 into Snowflake. The raw d...
Q112. What is the primary purpose of the COPY INTO command in Snowflake for data loading?...
Q113. Which of the following can be cloned using Snowflake's Cloning feature? (Choose any 3 opti...
Q114. Which of the following statements are true about Cortex functions?...
Q115. You have a large CSV file stored in AWS S3 that you need to load into a Snowflake table ca...
Q116. You have a role hierarchy where 'ROLE A' has been granted to 'ROLE B', and 'ROLE B" has be...
Q117. Where is unstructured data stored in Snowflake?...
Q118. A data engineer, Bob, created a table 'CUSTOMER DATA' in schema 'SALES SCHEMA' within the ...
Q119. Which of the following parameters can be used with the COPY INTO <TABLE> command to ...
Q120. What are virtual warehouses in Snowflake?
Q121. A Snowflake account has multiple custom roles, including `DATA ADMIN', 'ANALYST , and 'REP...
Q122. How can you search for listings on Snowflake Marketplace? (Choose any 2 options)...
Q123. A large e-commerce company is experiencing seasonal spikes in sales traffic, leading to si...
Q124. You are using the 'SNOWFLAKE.ML.COMPLETE function in Snowflake Cortex to generate creative...
Q125. What is a key feature of custom roles in Snowflake? (Choose any 2 options)...
[×]

Download PDF File

Enter your email address to download Snowflake.SOL-C01.v2026-04-25.q125.pdf

Email:

DumpsFiles

Our website provides the Largest and the most Latest vendors Certification Exam materials around the world.

Using dumps we provide to Pass the Exam, we has the Valid Dumps with passing guranteed just which you need.

  • DMCA
  • About
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
©2026 DumpsFiles

www.dumpsfiles.com materials do not contain actual questions and answers from Cisco's certification exams.