{"id":13477,"date":"2026-09-16T09:14:38","date_gmt":"2026-09-16T09:14:38","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=13477"},"modified":"2026-09-16T09:14:38","modified_gmt":"2026-09-16T09:14:38","slug":"snowflake-snowpro-core-practice-test-questions-and-exam-dumps-part7-q121-140","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/snowflake-snowpro-core-practice-test-questions-and-exam-dumps-part7-q121-140\/","title":{"rendered":"Snowflake SnowPro Core Practice Test Questions and Exam Dumps Part7 Q121-140"},"content":{"rendered":"

<\/h1>\n

View Full <\/b>Snowflake SnowPro Core Exam Dumps<\/b><\/a> and Practice Test Dumps.<\/b><\/h2>\n

 <\/p>\n

Question 121<\/b><\/h3>\n

Which Snowflake feature allows a user to create a copy of a table without immediately duplicating all of its underlying storage?<\/b><\/p>\n

    \n
  1. Snowpipe<\/span><\/li>\n
  2. Zero-copy cloning<\/span><\/li>\n
  3. Time Travel<\/span><\/li>\n
  4. Resource Monitor<\/span><\/li>\n<\/ol>\n

    Correct Answer: 2<\/b><\/p>\n

    Explanation:<\/b><\/p>\n

    Zero-copy cloning allows supported Snowflake objects to be cloned without immediately creating a complete physical copy of the underlying data. Initially, the clone can reference the same micro-partitions as the source. When changes are made, Snowflake manages the affected storage separately. This makes the feature particularly useful for development, testing, and temporary environments where users need a copy of existing data quickly. Snowpipe is designed for continuous ingestion, Time Travel provides historical access, and Resource Monitors help manage credit consumption. Zero-copy cloning therefore provides a fast and storage-efficient way to create object copies.<\/span><\/p>\n

    Question 122<\/b><\/h3>\n

    Which Snowflake feature is used to access historical data within the configured retention period?<\/b><\/p>\n

      \n
    1. Resource Monitor<\/span><\/li>\n
    2. Snowpipe<\/span><\/li>\n
    3. Time Travel<\/span><\/li>\n
    4. Secure Data Sharing<\/span><\/li>\n<\/ol>\n

      Correct Answer: 3<\/b><\/p>\n

      Explanation:<\/b><\/p>\n

      Time Travel enables users to access historical versions of supported Snowflake data within the configured retention period. It can help investigate accidental updates, deletes, or other unwanted changes by allowing users to examine data as it existed at an earlier point in time. Time Travel is different from Fail-safe, which provides a separate Snowflake-managed recovery mechanism. Resource Monitors manage credit consumption, Snowpipe handles continuous ingestion, and Secure Data Sharing provides governed data sharing. Time Travel is therefore the appropriate capability for historical data access and recovery from recent changes.<\/span><\/p>\n

      Question 123<\/b><\/h3>\n

      Which Snowflake feature is designed for continuous ingestion of newly arrived files?<\/b><\/p>\n

        \n
      1. Snowpipe<\/span><\/li>\n
      2. Fail-safe<\/span><\/li>\n
      3. Time Travel<\/span><\/li>\n
      4. Zero-copy cloning<\/span><\/li>\n<\/ol>\n

        Correct Answer: 1<\/b><\/p>\n

        Explanation:<\/b><\/p>\n

        Snowpipe is designed to continuously or near-continuously ingest newly arrived files into Snowflake tables. It can process files from supported cloud storage locations as they become available, reducing the need for manually triggered loading operations. This makes Snowpipe useful for event-driven pipelines and workloads where new data should become available shortly after arrival. Fail-safe is related to recovery, Time Travel provides historical access, and zero-copy cloning creates logical copies of objects. Snowpipe therefore specifically addresses continuous file-based data ingestion.<\/span><\/p>\n

        Question 124<\/b><\/h3>\n

        What is the primary purpose of a Snowflake virtual warehouse?<\/b><\/p>\n

          \n
        1. Store historical table versions<\/span><\/li>\n
        2. Provide compute resources<\/span><\/li>\n
        3. Organize database objects<\/span><\/li>\n
        4. Manage data-sharing permissions<\/span><\/li>\n<\/ol>\n

          Correct Answer: 2<\/b><\/p>\n

          Explanation:<\/b><\/p>\n

          A virtual warehouse provides the compute resources required to execute SQL queries and perform data-processing workloads. Snowflake separates compute from storage, allowing warehouses to be resized, suspended, resumed, and configured independently of the underlying data. Databases and schemas organize objects, while security and sharing mechanisms manage access. A warehouse is therefore part of Snowflake’s compute layer rather than its storage or access-control layer. This separation allows organizations to use different warehouses for different workloads and scale processing resources according to demand.<\/span><\/p>\n

          Question 125<\/b><\/h3>\n

          Which Snowflake feature helps control credit consumption by automatically suspending an idle warehouse?<\/b><\/p>\n

            \n
          1. Time Travel<\/span><\/li>\n
          2. Auto-suspend<\/span><\/li>\n
          3. Snowpipe<\/span><\/li>\n
          4. Fail-safe<\/span><\/li>\n<\/ol>\n

            Correct Answer: 2<\/b><\/p>\n

            Explanation:<\/b><\/p>\n

            Auto-suspend automatically stops a virtual warehouse after it has remained idle for the configured amount of time. Since an active warehouse consumes compute credits, suspending unused warehouses can help reduce unnecessary costs. Organizations can choose an inactivity period that matches the workload’s behavior. Auto-resume can also be configured to restart a suspended warehouse when new work arrives. Time Travel handles historical data, Snowpipe handles continuous ingestion, and Fail-safe provides a recovery mechanism. Auto-suspend is therefore specifically associated with managing warehouse activity and compute costs.<\/span><\/p>\n

            Question 126<\/b><\/h3>\n

            Which Snowflake capability allows data to be shared with another Snowflake account without creating a traditional physical copy?<\/b><\/p>\n

              \n
            1. Secure Data Sharing<\/span><\/li>\n
            2. Snowpipe<\/span><\/li>\n
            3. Search Optimization Service<\/span><\/li>\n
            4. Time Travel<\/span><\/li>\n<\/ol>\n

              Correct Answer: 1<\/b><\/p>\n

              Explanation:<\/b><\/p>\n

              Secure Data Sharing allows supported Snowflake data to be shared with another Snowflake account without requiring the provider to create and transfer a traditional physical copy. The provider can control which objects are shared while the consumer accesses the data according to the configured sharing arrangement. This is useful for collaboration between organizations, customers, partners, and internal business units. Snowpipe focuses on data ingestion, Search Optimization Service improves certain query patterns, and Time Travel provides historical data access. Secure Data Sharing is therefore the appropriate feature for governed cross-account data sharing.<\/span><\/p>\n

              Question 127<\/b><\/h3>\n

              Which Snowflake storage structure is automatically created as table data is loaded?<\/b><\/p>\n

                \n
              1. Micro-partitions<\/span><\/li>\n
              2. Virtual warehouses<\/span><\/li>\n
              3. Stages<\/span><\/li>\n
              4. Roles<\/span><\/li>\n<\/ol>\n

                Correct Answer: 1<\/b><\/p>\n

                Explanation:<\/b><\/p>\n

                Snowflake automatically organizes table data into micro-partitions as data is loaded. These are compressed storage units containing subsets of rows and metadata describing the stored data. Snowflake can use the metadata to eliminate micro-partitions that are unlikely to contain relevant rows during query processing. Users do not normally create or maintain individual micro-partitions manually. Virtual warehouses provide compute, stages handle file-based data movement, and roles manage access privileges. Micro-partitions are therefore a fundamental part of Snowflake’s automatic storage architecture and query-processing model.<\/span><\/p>\n

                Question 128<\/b><\/h3>\n

                Which Snowflake feature provides an additional Snowflake-managed recovery mechanism after the applicable Time Travel period?<\/b><\/p>\n

                  \n
                1. Search Optimization Service<\/span><\/li>\n
                2. Fail-safe<\/span><\/li>\n
                3. Snowpipe<\/span><\/li>\n
                4. Secure Data Sharing<\/span><\/li>\n<\/ol>\n

                  Correct Answer: 2<\/b><\/p>\n

                  Explanation:<\/b><\/p>\n

                  Fail-safe provides a Snowflake-managed recovery mechanism after the applicable Time Travel retention period has ended. It is intended for certain recovery scenarios and should not be treated as a normal historical-query feature. Time Travel is designed for user-accessible historical data operations during its retention period, whereas Fail-safe is managed by Snowflake. Search Optimization Service improves specific query patterns, Snowpipe handles continuous ingestion, and Secure Data Sharing enables cross-account data access. Understanding the distinction between Time Travel and Fail-safe is important for proper recovery planning.<\/span><\/p>\n

                  Question 129<\/b><\/h3>\n

                  Which Snowflake feature is designed to improve performance for certain selective searches on large tables?<\/b><\/p>\n

                    \n
                  1. Search Optimization Service<\/span><\/li>\n
                  2. Snowpipe<\/span><\/li>\n
                  3. Resource Monitor<\/span><\/li>\n
                  4. Fail-safe<\/span><\/li>\n<\/ol>\n

                    Correct Answer: 1<\/b><\/p>\n

                    Explanation:<\/b><\/p>\n

                    Search Optimization Service can improve query performance for certain selective search patterns, particularly when queries frequently search for specific values within large tables. Snowflake maintains additional search access structures that can help locate relevant data more efficiently. This feature is different from increasing warehouse size because it focuses on data-access efficiency for supported workloads. Snowpipe handles continuous ingestion, Resource Monitors track credit usage, and Fail-safe provides recovery capabilities. Search Optimization Service is therefore useful when workload analysis shows that selective lookups are an important performance requirement.<\/span><\/p>\n

                    Question 130<\/b><\/h3>\n

                    Which command is commonly used to load staged files into a Snowflake table?<\/b><\/p>\n

                      \n
                    1. CREATE TABLE<\/span><\/li>\n
                    2. COPY INTO<\/span><\/li>\n
                    3. SHOW DATABASES<\/span><\/li>\n
                    4. ALTER ROLE<\/span><\/li>\n<\/ol>\n

                      Correct Answer: 2<\/b><\/p>\n

                      Explanation:<\/b><\/p>\n

                      COPY INTO is commonly used to load data from staged files into Snowflake tables. It supports multiple file formats and loading options and can work with internal or external stages. A typical workflow involves placing files in a stage and then using COPY INTO to load their contents into a target table. CREATE TABLE creates a table, SHOW DATABASES displays database information, and ALTER ROLE modifies role properties. COPY INTO is therefore the command most directly associated with file-based loading into Snowflake tables.<\/span><\/p>\n

                      Question 131<\/b><\/h3>\n

                      Which Snowflake feature allows users to create a fast logical copy of a database or schema for testing?<\/b><\/p>\n

                        \n
                      1. Zero-copy cloning<\/span><\/li>\n
                      2. Time Travel<\/span><\/li>\n
                      3. Snowpipe<\/span><\/li>\n
                      4. Resource Monitor<\/span><\/li>\n<\/ol>\n

                        Correct Answer: 1<\/b><\/p>\n

                        Explanation:<\/b><\/p>\n

                        Zero-copy cloning allows supported Snowflake objects, including databases, schemas, and tables, to be cloned without immediately duplicating all underlying storage. The clone can initially reference the same micro-partitions as the source. When modifications occur, Snowflake manages the affected storage separately. This makes zero-copy cloning useful for development, testing, quality assurance, and temporary environments. Time Travel provides historical data access, Snowpipe handles continuous ingestion, and Resource Monitors manage credit usage. Zero-copy cloning therefore provides a fast and efficient method for creating test environments.<\/span><\/p>\n

                        Question 132<\/b><\/h3>\n

                        Which Snowflake capability allows multiple virtual warehouses to access the same underlying data?<\/b><\/p>\n

                          \n
                        1. Time Travel<\/span><\/li>\n
                        2. Separation of compute and storage<\/span><\/li>\n
                        3. Fail-safe<\/span><\/li>\n
                        4. Internal stages<\/span><\/li>\n<\/ol>\n

                          Correct Answer: 2<\/b><\/p>\n

                          Explanation:<\/b><\/p>\n

                          Snowflake separates compute resources from the storage layer, allowing multiple virtual warehouses to access the same underlying data. Each warehouse can provide independent processing capacity for a specific workload without requiring a separate physical copy of the data. This helps organizations isolate reporting, engineering, transformation, and analytical workloads. Time Travel and Fail-safe are recovery features, while internal stages support file storage and data movement. The separation of compute and storage is therefore central to Snowflake’s ability to provide independent and scalable compute resources.<\/span><\/p>\n

                          Question 133<\/b><\/h3>\n

                          Which Snowflake feature can be used to monitor credit usage and establish consumption thresholds?<\/b><\/p>\n

                            \n
                          1. Resource Monitor<\/span><\/li>\n
                          2. Snowpipe<\/span><\/li>\n
                          3. Time Travel<\/span><\/li>\n
                          4. Zero-copy cloning<\/span><\/li>\n<\/ol>\n

                            Correct Answer: 1<\/b><\/p>\n

                            Explanation:<\/b><\/p>\n

                            Resource Monitors allow administrators to monitor Snowflake credit consumption and establish usage thresholds. Depending on configuration, they can provide notifications or perform supported actions when consumption reaches specified limits. This makes Resource Monitors useful for cost governance and preventing unexpected compute usage. Snowpipe is designed for continuous data ingestion, Time Travel provides historical access, and zero-copy cloning creates logical copies of supported objects. Resource Monitors therefore specifically address Snowflake resource and credit consumption rather than data loading, recovery, or object cloning.<\/span><\/p>\n

                            Question 134<\/b><\/h3>\n

                            Which Snowflake object provides a location for files used during data loading and unloading?<\/b><\/p>\n

                              \n
                            1. Schema<\/span><\/li>\n
                            2. Stage<\/span><\/li>\n
                            3. Warehouse<\/span><\/li>\n
                            4. Role<\/span><\/li>\n<\/ol>\n

                              Correct Answer: 2<\/b><\/p>\n

                              Explanation:<\/b><\/p>\n

                              A stage provides a location for files involved in Snowflake data loading and unloading operations. Internal stages use Snowflake-managed storage, while external stages can reference supported cloud storage locations. Files can be placed in a stage before being loaded into tables, or Snowflake data can be unloaded into staged files. A schema organizes database objects, a warehouse provides compute resources, and a role manages privileges. Stages are therefore a key part of file-based data movement and ingestion workflows in Snowflake.<\/span><\/p>\n

                              Question 135<\/b><\/h3>\n

                              Which Snowflake feature allows users to examine data as it existed before an accidental DELETE?<\/b><\/p>\n

                                \n
                              1. Time Travel<\/span><\/li>\n
                              2. Snowpipe<\/span><\/li>\n
                              3. Resource Monitor<\/span><\/li>\n
                              4. Search Optimization Service<\/span><\/li>\n<\/ol>\n

                                Correct Answer: 1<\/b><\/p>\n

                                Explanation:<\/b><\/p>\n

                                Time Travel allows users to access historical versions of supported Snowflake data within the applicable retention period. If rows are accidentally deleted, users can use historical querying to examine the table as it existed before the deletion and support recovery operations. Snowpipe is used for continuous data ingestion, Resource Monitors manage credit consumption, and Search Optimization Service improves certain selective query patterns. Time Travel is therefore the most appropriate feature for investigating or recovering from recent accidental data changes.<\/span><\/p>\n

                                Question 136<\/b><\/h3>\n

                                Which Snowflake feature is designed to continuously process files arriving in supported cloud storage?<\/b><\/p>\n

                                  \n
                                1. Snowpipe<\/span><\/li>\n
                                2. Fail-safe<\/span><\/li>\n
                                3. Time Travel<\/span><\/li>\n
                                4. Secure Data Sharing<\/span><\/li>\n<\/ol>\n

                                  Correct Answer: 1<\/b><\/p>\n

                                  Explanation:<\/b><\/p>\n

                                  Snowpipe provides continuous or near-continuous file ingestion into Snowflake tables. It can process newly available files from supported cloud storage locations and reduce the need for users to repeatedly initiate batch-loading operations. This is useful for event-driven pipelines and workloads where data needs to become available soon after arrival. Fail-safe provides recovery capabilities, Time Travel enables historical access, and Secure Data Sharing allows governed data sharing between accounts. Snowpipe is therefore the Snowflake service specifically intended for automated ongoing file ingestion.<\/span><\/p>\n

                                  Question 137<\/b><\/h3>\n

                                  Which Snowflake feature allows organizations to share data with consumers in other Snowflake accounts without physically copying the underlying data?<\/b><\/p>\n

                                    \n
                                  1. Secure Data Sharing<\/span><\/li>\n
                                  2. Snowpipe<\/span><\/li>\n
                                  3. Time Travel<\/span><\/li>\n
                                  4. Auto-suspend<\/span><\/li>\n<\/ol>\n

                                    Correct Answer: 1<\/b><\/p>\n

                                    Explanation:<\/b><\/p>\n

                                    Secure Data Sharing enables providers to share supported Snowflake data with other Snowflake accounts without creating traditional physical copies of the underlying data. Providers can control which data is shared, while consumers receive access according to the sharing configuration. This approach can simplify collaboration and reduce unnecessary data duplication. Snowpipe handles ingestion, Time Travel provides historical access, and auto-suspend controls warehouse inactivity. Secure Data Sharing is therefore the appropriate Snowflake capability when controlled access to current data is needed across account boundaries.<\/span><\/p>\n

                                    Question 138<\/b><\/h3>\n

                                    Which Snowflake feature is most directly associated with reducing costs from warehouses that remain idle?<\/b><\/p>\n

                                      \n
                                    1. Auto-suspend<\/span><\/li>\n
                                    2. Time Travel<\/span><\/li>\n
                                    3. Search Optimization Service<\/span><\/li>\n
                                    4. Snowpipe<\/span><\/li>\n<\/ol>\n

                                      Correct Answer: 1<\/b><\/p>\n

                                      Explanation:<\/b><\/p>\n

                                      Auto-suspend automatically suspends a virtual warehouse after it has remained idle for the configured period. Since active warehouses consume compute credits, automatically stopping inactive warehouses can help reduce unnecessary credit usage. Auto-resume can be configured so that the warehouse starts again when new work is submitted. Time Travel provides historical data access, Search Optimization Service improves certain queries, and Snowpipe handles continuous ingestion. Auto-suspend is therefore the feature most directly associated with controlling the cost of idle compute resources.<\/span><\/p>\n

                                      Question 139<\/b><\/h3>\n

                                      Which Snowflake feature is used to create a logical copy of an existing table for development purposes?<\/b><\/p>\n

                                        \n
                                      1. Zero-copy cloning<\/span><\/li>\n
                                      2. Resource Monitor<\/span><\/li>\n
                                      3. Snowpipe<\/span><\/li>\n
                                      4. Fail-safe<\/span><\/li>\n<\/ol>\n

                                        Correct Answer: 1<\/b><\/p>\n

                                        Explanation:<\/b><\/p>\n

                                        Zero-copy cloning allows users to create logical copies of supported Snowflake objects without immediately duplicating all of the underlying storage. This makes it useful for development, testing, and quality-assurance environments. Initially, the source and clone can reference the same micro-partitions, and Snowflake manages separate storage as modifications occur. Resource Monitors are used for credit management, Snowpipe handles continuous ingestion, and Fail-safe provides recovery capabilities. Zero-copy cloning therefore provides a fast and storage-efficient way to create development copies of existing Snowflake objects.<\/span><\/p>\n

                                        Question 140<\/b><\/h3>\n

                                        Which statement best describes Snowflake’s separation of compute and storage?<\/b><\/p>\n

                                          \n
                                        1. Warehouses permanently store table data<\/span><\/li>\n
                                        2. Compute resources can be scaled independently from stored data<\/span><\/li>\n
                                        3. Every table requires a separate warehouse<\/span><\/li>\n
                                        4. Storage disappears when a warehouse is suspended<\/span><\/li>\n<\/ol>\n

                                          Correct Answer: 2<\/b><\/p>\n

                                          Explanation:<\/b><\/p>\n

                                          Snowflake’s architecture separates compute from storage, allowing organizations to scale virtual warehouse resources independently from the amount of stored data. A warehouse can be resized when additional processing capacity is needed, while the underlying data remains in Snowflake storage. Multiple warehouses can also access the same data, enabling workload isolation. Suspending a warehouse does not remove the stored data. This architecture provides flexibility for performance management and cost optimization because organizations can adjust compute resources according to workload demand without changing the storage architecture.<\/span><\/p>\n

                                           <\/p>\n","protected":false},"excerpt":{"rendered":"

                                          View Full Snowflake SnowPro Core Exam Dumps and Practice Test Dumps.   Question 121 Which Snowflake feature allows a user to create a copy of a table without immediately duplicating all of its underlying storage? Snowpipe Zero-copy cloning Time Travel Resource Monitor Correct Answer: 2 Explanation: Zero-copy cloning allows supported Snowflake objects to be cloned […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13477"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=13477"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13477\/revisions"}],"predecessor-version":[{"id":13511,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13477\/revisions\/13511"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=13477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=13477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=13477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}