{"id":13494,"date":"2026-09-16T09:11:00","date_gmt":"2026-09-16T09:11:00","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=13494"},"modified":"2026-09-16T09:11:00","modified_gmt":"2026-09-16T09:11:00","slug":"snowflake-snowpro-core-practice-test-questions-and-exam-dumps-part19-q361-380","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/snowflake-snowpro-core-practice-test-questions-and-exam-dumps-part19-q361-380\/","title":{"rendered":"Snowflake SnowPro Core Practice Test Questions and Exam Dumps Part19 Q361-380"},"content":{"rendered":"

<\/h1>\n

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

 <\/p>\n

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

Which Snowflake feature is used to define a reusable set of rules for interpreting files during data loading and unloading?<\/b><\/p>\n

    \n
  1. Stream<\/span><\/li>\n
  2. File Format<\/span><\/li>\n
  3. Task<\/span><\/li>\n
  4. Resource Monitor<\/span><\/li>\n<\/ol>\n

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

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

    A File Format object defines reusable rules for how Snowflake should interpret files during loading and unloading operations. Depending on the file type, settings can include field delimiters, record delimiters, compression, quotation marks, header handling, and other parsing options. Named file formats are especially useful when the same file structure is used repeatedly across multiple loading operations. Streams track table changes, Tasks automate processing, and Resource Monitors manage credit consumption. Therefore, File Format is the correct Snowflake object for defining reusable file interpretation rules.<\/span><\/p>\n

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

    Which Snowflake feature is primarily used to provide fine-grained control over which rows users can access?<\/b><\/p>\n

      \n
    1. Row Access Policy<\/span><\/li>\n
    2. Masking Policy<\/span><\/li>\n
    3. Network Policy<\/span><\/li>\n
    4. Resource Monitor<\/span><\/li>\n<\/ol>\n

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

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

      A Row Access Policy provides row-level security by determining whether particular rows should be visible to a user or role. Conditions within the policy can evaluate information such as role membership or user identity and then control row visibility accordingly. This is different from a Masking Policy, which controls the representation of column values rather than whether a row is visible. Network Policies control account access based on network conditions, while Resource Monitors manage credit consumption. Therefore, Row Access Policy is the appropriate feature for restricting access to specific rows.<\/span><\/p>\n

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

      Which Snowflake feature can help an organization avoid unnecessary compute costs by automatically stopping an inactive warehouse?<\/b><\/p>\n

        \n
      1. AUTO_RESUME<\/span><\/li>\n
      2. Time Travel<\/span><\/li>\n
      3. AUTO_SUSPEND<\/span><\/li>\n
      4. Fail-safe<\/span><\/li>\n<\/ol>\n

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

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

        AUTO_SUSPEND allows Snowflake to automatically suspend a virtual warehouse after it has remained inactive for a configured period. Since a running warehouse can consume compute credits, automatically suspending an idle warehouse can help reduce unnecessary consumption. AUTO_RESUME performs the opposite function by restarting a suspended warehouse when work requires it. Time Travel and Fail-safe are data protection and recovery capabilities rather than warehouse lifecycle settings. Therefore, AUTO_SUSPEND is the correct feature for automatically stopping an inactive warehouse and supporting cost control.<\/span><\/p>\n

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

        Which command is used to remove specific rows from a Snowflake table while retaining the table itself?<\/b><\/p>\n

          \n
        1. DROP TABLE<\/span><\/li>\n
        2. DELETE<\/span><\/li>\n
        3. DROP DATABASE<\/span><\/li>\n
        4. REMOVE<\/span><\/li>\n<\/ol>\n

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

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

          The DELETE command removes rows from a table while keeping the table object and its structure available. A WHERE clause can be used to identify specific rows that should be removed, allowing targeted data deletion. In contrast, DROP TABLE removes the entire table object, while DROP DATABASE operates at the database level. REMOVE is not the standard Snowflake SQL command for deleting table rows. Because the requirement is to remove rows without removing the table itself, DELETE is the correct command.<\/span><\/p>\n

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

          Which Snowflake feature is most appropriate for querying data as it existed at an earlier point in time?<\/b><\/p>\n

            \n
          1. Snowpipe<\/span><\/li>\n
          2. Time Travel<\/span><\/li>\n
          3. Resource Monitor<\/span><\/li>\n
          4. Network Policy<\/span><\/li>\n<\/ol>\n

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

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

            Time Travel allows Snowflake users to access historical versions of supported data within the applicable retention period. It can be used to investigate previous data states, recover accidentally modified or deleted records, and compare historical versions of data. Snowpipe is used for continuous file ingestion, Resource Monitors manage credit consumption, and Network Policies restrict account access based on network rules. Time Travel is therefore the appropriate feature when a user needs to query or recover data from an earlier point in time.<\/span><\/p>\n

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

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

              \n
            1. COPY INTO<\/span><\/li>\n
            2. PUT<\/span><\/li>\n
            3. GET<\/span><\/li>\n
            4. GRANT<\/span><\/li>\n<\/ol>\n

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

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

              COPY INTO is the standard Snowflake command used to load data from a stage into a target table. It can work with internal and external stages and can reference file formats and other loading options. PUT is commonly used to upload local files to an internal stage, while GET can download files from an internal stage to a local environment. GRANT is used for access control rather than data loading. Therefore, COPY INTO is the correct command when staged files need to be loaded into a Snowflake table.<\/span><\/p>\n

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

              Which Snowflake object is designed to store information about changes made to rows in a source table?<\/b><\/p>\n

                \n
              1. Stage<\/span><\/li>\n
              2. Stream<\/span><\/li>\n
              3. File Format<\/span><\/li>\n
              4. Warehouse<\/span><\/li>\n<\/ol>\n

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

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

                A Stream records change information for a supported source table and can expose changes such as inserts, updates, and deletes to downstream processing. Streams are particularly useful for incremental data pipelines because they allow downstream logic to work with changed data rather than repeatedly processing an entire table. A Stage stores or references files, File Formats define how files are interpreted, and a Warehouse provides compute resources. Therefore, Stream is the correct object for tracking table changes for downstream processing.<\/span><\/p>\n

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

                Which Snowflake feature is designed to maintain precomputed results for supported queries?<\/b><\/p>\n

                  \n
                1. Standard View<\/span><\/li>\n
                2. Materialized View<\/span><\/li>\n
                3. Stage<\/span><\/li>\n
                4. Network Policy<\/span><\/li>\n<\/ol>\n

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

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

                  A Materialized View maintains precomputed results for supported query definitions. By maintaining these results, Snowflake can potentially serve eligible queries more efficiently than recalculating the underlying query from the source data each time. Materialized Views are useful for appropriate workloads but involve maintenance and storage considerations. A Standard View is a logical query definition, a Stage provides a file location, and a Network Policy controls network access. Therefore, Materialized View is the correct answer when the requirement is to maintain precomputed query results.<\/span><\/p>\n

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

                  Which Snowflake capability is used to restrict account access according to network rules such as allowed IP addresses?<\/b><\/p>\n

                    \n
                  1. Row Access Policy<\/span><\/li>\n
                  2. Masking Policy<\/span><\/li>\n
                  3. Network Policy<\/span><\/li>\n
                  4. Search Optimization Service<\/span><\/li>\n<\/ol>\n

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

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

                    A Network Policy can restrict access to a Snowflake account according to network-based rules, including approved or blocked IP addresses. This can help organizations limit access to trusted corporate networks or other approved network ranges. A Row Access Policy controls which rows are visible, while a Masking Policy controls how sensitive column values are presented. Search Optimization Service is intended for supported query-performance scenarios. Therefore, Network Policy is the appropriate Snowflake feature for controlling account access based on network information.<\/span><\/p>\n

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

                    Which Snowflake feature helps reuse an eligible previously generated query result without fully executing the query again?<\/b><\/p>\n

                      \n
                    1. Query Profile<\/span><\/li>\n
                    2. Result Cache<\/span><\/li>\n
                    3. Search Optimization Service<\/span><\/li>\n
                    4. Automatic Clustering<\/span><\/li>\n<\/ol>\n

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

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

                      Snowflake’s Result Cache can allow an eligible query result to be reused instead of executing the query again from the beginning. When the requirements for result reuse are satisfied, this can reduce query response time and avoid unnecessary compute work. Query Profile is a diagnostic tool for examining execution details, while Search Optimization Service and Automatic Clustering address different performance considerations. Result caching should not be confused with warehouse caching or micro-partition pruning because these mechanisms operate differently. Therefore, Result Cache is the correct feature for reusing eligible previously generated query results.<\/span><\/p>\n

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

                      Which Snowflake feature allows data to be shared with another Snowflake account without creating a traditional duplicate of the provider’s data?<\/b><\/p>\n

                        \n
                      1. Secure Data Sharing<\/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

                        Secure Data Sharing allows a Snowflake provider to share selected data with another Snowflake account without requiring a traditional physical copy of the shared data for the consumer. The provider determines which objects are exposed through the share, helping maintain control over the shared information. This architecture can simplify collaboration and reduce unnecessary data duplication. Time Travel provides historical access, Snowpipe handles continuous file ingestion, and Resource Monitors track credit consumption. Therefore, Secure Data Sharing is the correct capability for controlled cross-account data sharing.<\/span><\/p>\n

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

                        Which Snowflake setting automatically starts a suspended warehouse when a workload requires it?<\/b><\/p>\n

                          \n
                        1. AUTO_SUSPEND<\/span><\/li>\n
                        2. AUTO_RESUME<\/span><\/li>\n
                        3. DATA_RETENTION_TIME_IN_DAYS<\/span><\/li>\n
                        4. STATEMENT_TIMEOUT_IN_SECONDS<\/span><\/li>\n<\/ol>\n

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

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

                          AUTO_RESUME controls whether a suspended virtual warehouse automatically starts when a workload requires compute resources. This can make warehouse management more convenient because users do not need to manually resume the warehouse before running queries. AUTO_SUSPEND is used to stop inactive warehouses after a configured period. DATA_RETENTION_TIME_IN_DAYS concerns data retention, while STATEMENT_TIMEOUT_IN_SECONDS controls query execution time limits. Therefore, AUTO_RESUME is the correct setting for automatically restarting a suspended warehouse when work arrives.<\/span><\/p>\n

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

                          Which Snowflake command is used to assign privileges to a role?<\/b><\/p>\n

                            \n
                          1. SELECT<\/span><\/li>\n
                          2. COPY<\/span><\/li>\n
                          3. GRANT<\/span><\/li>\n
                          4. MERGE<\/span><\/li>\n<\/ol>\n

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

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

                            The GRANT command is used to assign privileges or roles within Snowflake’s role-based access-control system. For example, administrators can grant SELECT on a table or USAGE on a database or schema to a role. The role can then be assigned to appropriate users. SELECT retrieves data, COPY performs data loading or unloading, and MERGE combines conditional insert, update, and delete operations. Access control in Snowflake depends on appropriate privileges across the object hierarchy. Therefore, GRANT is the correct command for assigning privileges to a role.<\/span><\/p>\n

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

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

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

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

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

                              Search Optimization Service is designed to improve performance for supported selective search patterns. It can be useful when queries frequently search for particular values in large datasets and normal micro-partition pruning may not provide sufficient performance. The service maintains additional search information to help Snowflake locate relevant data more efficiently. It is not a universal performance solution for every workload. Time Travel handles historical data access, Fail-safe provides recovery support, and Snowpipe performs file ingestion. Therefore, Search Optimization Service is the correct answer.<\/span><\/p>\n

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

                              Which Snowflake architectural concept allows compute resources to be scaled independently of data storage?<\/b><\/p>\n

                                \n
                              1. Schema hierarchy<\/span><\/li>\n
                              2. Separation of storage and compute<\/span><\/li>\n
                              3. File staging<\/span><\/li>\n
                              4. Role inheritance<\/span><\/li>\n<\/ol>\n

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

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

                                Snowflake’s separation of storage and compute means that data storage and processing resources are managed independently. Virtual warehouses provide compute resources while Snowflake’s storage layer stores the data. This architecture allows organizations to resize or create warehouses without needing to duplicate the underlying data. It also supports workload isolation because different warehouses can process the same stored data independently. Schema hierarchy organizes database objects, file staging handles data files, and role inheritance relates to access control. Therefore, separation of storage and compute is the correct architectural concept.<\/span><\/p>\n

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

                                Which Snowflake object is used to define a logical SQL query that users can reference like a table?<\/b><\/p>\n

                                  \n
                                1. Stream<\/span><\/li>\n
                                2. Stage<\/span><\/li>\n
                                3. View<\/span><\/li>\n
                                4. Task<\/span><\/li>\n<\/ol>\n

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

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

                                  A View is a logical SQL definition that can be queried similarly to a table. Instead of maintaining a complete independent copy of the query results like a materialized view, a standard view stores the query definition. Views are useful for simplifying complex queries, presenting selected columns, and creating logical abstractions over underlying tables. Streams track changes, Stages handle files, and Tasks automate SQL execution. Therefore, View is the correct Snowflake object when a reusable logical SQL query needs to be presented as a queryable object.<\/span><\/p>\n

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

                                  Which Snowflake data type is best suited for storing an ordered collection of values within semi-structured data?<\/b><\/p>\n

                                    \n
                                  1. OBJECT<\/span><\/li>\n
                                  2. ARRAY<\/span><\/li>\n
                                  3. NUMBER<\/span><\/li>\n
                                  4. DATE<\/span><\/li>\n<\/ol>\n

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

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

                                    ARRAY is a Snowflake semi-structured data type used to store an ordered collection of values. Arrays are common when processing JSON and other nested datasets where multiple elements are grouped together in a defined order. OBJECT represents key-value pairs, while NUMBER stores numeric values and DATE stores calendar dates. Arrays can also contain nested structures, making them useful for complex semi-structured data. Snowflake’s FLATTEN function can be used when array elements need to be expanded into individual rows. Therefore, ARRAY is the correct answer.<\/span><\/p>\n

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

                                    Which Snowflake capability can automatically maintain clustering for eligible tables according to a defined clustering key?<\/b><\/p>\n

                                      \n
                                    1. Snowpipe<\/span><\/li>\n
                                    2. Automatic Clustering<\/span><\/li>\n
                                    3. Result Cache<\/span><\/li>\n
                                    4. Secure Data Sharing<\/span><\/li>\n<\/ol>\n

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

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

                                      Automatic Clustering helps maintain the organization of eligible table data according to a defined clustering key. As data changes, the physical organization may become less aligned with the desired clustering strategy. Snowflake can perform background maintenance to improve the clustering organization without requiring administrators to manually reorganize the data after every change. Snowpipe is used for continuous ingestion, Result Cache reuses eligible query results, and Secure Data Sharing provides controlled data access across accounts. Therefore, Automatic Clustering is the correct capability for automated clustering maintenance.<\/span><\/p>\n

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

                                      Which Snowflake function is commonly used to parse a JSON-formatted string into a semi-structured value?<\/b><\/p>\n

                                        \n
                                      1. FLATTEN<\/span><\/li>\n
                                      2. PARSE_JSON<\/span><\/li>\n
                                      3. COUNT<\/span><\/li>\n
                                      4. CONCAT<\/span><\/li>\n<\/ol>\n

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

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

                                        PARSE_JSON converts valid JSON text into a semi-structured Snowflake value, commonly represented using the VARIANT data type. Once parsed, users can access nested attributes and array elements using Snowflake’s semi-structured data capabilities. FLATTEN serves a different purpose by expanding nested arrays or objects into rows. COUNT is an aggregation function, while CONCAT combines strings. Therefore, PARSE_JSON is the appropriate function when JSON-formatted text needs to be converted into a queryable semi-structured representation.<\/span><\/p>\n

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

                                        Which Snowflake feature can be used to automate processing of changed data captured by a Stream?<\/b><\/p>\n

                                          \n
                                        1. Task<\/span><\/li>\n
                                        2. File Format<\/span><\/li>\n
                                        3. Network Policy<\/span><\/li>\n
                                        4. Resource Monitor<\/span><\/li>\n<\/ol>\n

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

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

                                          A Task can automate SQL execution and is commonly combined with a Stream to process changed data automatically. The Stream identifies changes in a source table, while the Task can execute transformation or loading logic according to a schedule or dependency configuration. This combination is useful for incremental data pipelines because only relevant changes can be processed instead of repeatedly processing an entire dataset. File Formats define file parsing, Network Policies control network access, and Resource Monitors manage credit usage. Therefore, Task is the correct feature for automating Stream-based processing.<\/span><\/p>\n

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

                                          View Full Snowflake SnowPro Core Exam Dumps and Practice Test Dumps.   Question 361 Which Snowflake feature is used to define a reusable set of rules for interpreting files during data loading and unloading? Stream File Format Task Resource Monitor Correct Answer: 2 Explanation: A File Format object defines reusable rules for how Snowflake should […]<\/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\/13494"}],"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=13494"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13494\/revisions"}],"predecessor-version":[{"id":13498,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13494\/revisions\/13498"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=13494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=13494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=13494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}