Download Certified Snow Professional Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which core architectural principle enables Snowflake to scale compute resources independently from storage? A) Monolithic architecture B) Multi-cluster shared data architecture C) Master-slave architecture D) In-memory-only storage Answer: B Explanation: Snowflake's multi-cluster shared data architecture separates compute from storage, allowing each to scale independently for flexibility and performance.
Question 2. In Snowflake, which layer is responsible for query optimization, metadata management, and user authentication? A) Compute layer B) Storage layer C) Cloud services layer D) Network layer Answer: C
Explanation: The cloud services layer manages metadata, authentication, query parsing, and optimization, serving as the "brain" of Snowflake.
Question 3. Which Snowflake edition is designed for the highest security and compliance standards, such as PCI and HIPAA? A) Standard B) Enterprise C) Business Critical D) Virtual Private Snowflake (VPS) Answer: C Explanation: Business Critical edition offers advanced security and compliance features, including support for HIPAA and PCI.
Question 4. What is the main benefit of Snowflake’s elasticity? A) Fixed compute costs B) Automatic and instant scaling of resources C) No support for concurrent users
A) User authentication B) Data encryption C) Efficient data storage and query optimization D) Network management Answer: C Explanation: Micro-partitions divide data into small, contiguous units, optimizing storage and query performance.
Question 7. How does clustering improve query performance in Snowflake? A) By storing all data in a single file B) By organizing data to minimize the number of micro-partitions scanned C) By encrypting data faster D) By increasing result caching Answer: B Explanation: Clustering arranges similar data together, reducing the number of micro-partitions scanned and improving query efficiency.
Question 8. What does Snowflake’s Time Travel feature allow users to do? A) Schedule future queries B) Query historical data at previous points in time C) Accelerate data loading D) Clone virtual warehouses Answer: B Explanation: Time Travel enables users to access historical data, recover dropped tables, and undo mistakes by querying data at earlier states.
Question 9. What is the maximum retention period for Time Travel in the Enterprise Edition of Snowflake? A) 1 day B) 7 days C) 90 days D) 365 days
C) Encrypting data D) Reducing storage costs Answer: B Explanation: Fail-safe offers a 7-day period after Time Travel ends for recovering data, managed solely by Snowflake support.
Question 12. Which feature allows secure, real-time sharing of data between Snowflake accounts without moving or copying data? A) Replication B) Zero-copy cloning C) Secure Data Sharing D) Materialized views Answer: C Explanation: Secure Data Sharing lets Snowflake users share live data securely with other accounts or organizations without copying.
Question 13. What role does the Snowflake Marketplace play? A) Provides a platform for buying and selling cloud compute resources B) Allows users to find, acquire, and share third-party datasets C) Manages virtual warehouses D) Hosts Snowflake code repositories Answer: B Explanation: The Snowflake Marketplace enables organizations to share and access third-party datasets securely.
Question 14. Which data formats does Snowflake natively support for semi- structured data? A) Only CSV B) Only JSON C) JSON, Avro, Parquet, ORC, XML D) Only Parquet Answer: C Explanation: Snowflake supports multiple semi-structured formats: JSON, Avro, Parquet, ORC, and XML.
Answer: B Explanation: Snowsight is the web UI for Snowflake, offering dashboards, query editing, visualizations, and administrative controls.
Question 17. Which command-line client is provided by Snowflake for SQL-based interactions? A) SnowAdmin B) SnowSQL C) SnowCLI D) SnowTerminal Answer: B Explanation: SnowSQL is the official command-line client for submitting queries and managing Snowflake resources.
Question 18. Which connector would you use to connect Snowflake with a Java application? A) ODBC
B) JDBC
C) Python Connector D) SnowSQL Answer: B Explanation: JDBC is the standard connector for Java-based applications to connect with Snowflake.
Question 19. What is Snowpark primarily used for? A) Network configuration B) Data engineering and data science using familiar programming languages C) User authentication D) Billing management Answer: B Explanation: Snowpark allows developers to build data pipelines and applications using languages like Python, Java, and Scala within Snowflake.
Explanation: Snowflake automatically encrypts all data at rest using keys managed in the underlying cloud platform.
Question 22. What is the function of network policies in Snowflake? A) Restricting user roles B) Managing data encryption C) Controlling access to Snowflake based on IP address ranges D) Configuring virtual warehouses Answer: C Explanation: Network policies enforce allowed IP ranges for Snowflake account access, enhancing network security.
Question 23. How does Multi-Factor Authentication (MFA) enhance Snowflake account security? A) Encrypts all data B) Requires users to provide a second form of verification in addition to passwords
C) Enables faster queries D) Increases storage capacity Answer: B Explanation: MFA adds a layer of protection by requiring a second authentication factor (like a code from an app) beyond just a password.
Question 24. What is federated authentication in Snowflake? A) Using multiple passwords for one user B) Integrating Snowflake login with external identity providers (e.g., Okta, ADFS) C) Manual password resets D) Only supporting native Snowflake authentication Answer: B Explanation: Federated authentication lets users log in to Snowflake using enterprise identity providers, supporting SSO.
Question 27. In Snowflake, what is a role? A) A user account B) A set of privileges that can be assigned to users or other roles C) A server instance D) A data warehouse Answer: B Explanation: Roles are collections of privileges that control what actions users can perform in Snowflake.
Question 28. Which of the following is NOT a system-defined role in Snowflake? A) ACCOUNTADMIN B) SYSADMIN C) PUBLIC D) DATAOWNER
Answer: D Explanation: DATAOWNER is not a system-defined role; ACCOUNTADMIN, SYSADMIN, and PUBLIC are.
Question 29. How can privileges be granted in Snowflake? A) Only to users B) Only to roles C) To roles, which can be assigned to users or other roles D) Only to databases Answer: C Explanation: Privileges are granted to roles, not directly to users; users inherit privileges through assigned roles.
Question 30. What is privilege inheritance in Snowflake’s RBAC model? A) Users inherit privileges from their created databases B) Roles can inherit privileges from other roles assigned to them
Question 32. Which command is used to create a new user in Snowflake? A) ADD USER B) CREATE USER C) NEW USER D) REGISTER USER Answer: B Explanation: The CREATE USER command is used to add a new user account in Snowflake.
Question 33. How can user authentication methods be managed in Snowflake? A) By modifying the storage layer B) Through user properties such as PASSWORD, RSA public key, and MFA options C) Only via the command line D) Cannot be managed Answer: B
Explanation: User authentication is managed by setting properties like passwords, public keys, and MFA requirements on user objects.
Question 34. What is the purpose of Snowflake’s resource monitors? A) To encrypt data B) To control and monitor compute credit usage C) To manage network traffic D) To scale storage automatically Answer: B Explanation: Resource monitors help manage and limit the consumption of compute credits to avoid cost overruns.
Question 35. Which Snowflake feature provides proactive cost management and budget alerts? A) Time Travel B) Snowflake Budgets C) Zero-copy cloning
