SnowPro Advanced Architect Practice Test

These questions are part of the practice quiz. Start practicing

• Exit code 0 indicates everything ran smoothly.
• Which of the following is NOT an available Snowflake edition?
• In SnowSQL, the FILES parameter in a COPY INTO statement from a stage can specify a maximum of how many files?
• Querying tables and views in a secondary database using Time Travel can yield different results than querying the same objects in the primary database.
• As of 2022, which account objects can be replicated in Snowflake?
• Data unloading uses the COPY command.
• Which method is generally the slowest for identifying/specifying data files to load from a stage?
• Does Snowflake call the remote service directly when executing external functions?
• Which of the following is NOT an edition listed for Snowflake?
• Which statement about Snowflake replication is true?
• What is the default warehouse size when executing CREATE WAREHOUSE?
• The number of load operations that run in parallel cannot exceed the number of data files to be loaded.
• Which combination of statements about sharing and consumption is TRUE?
• If federated authentication is enabled for your Snowflake account, Snowflake recommends maintaining user passwords in Snowflake.
• Snowflake supports cross-cloud and cross-region replication and failover to minimize disruption. True or False?
• Metadata for an external table can be refreshed automatically using which service?
• In the typical Kafka Connector pattern with Snowflake, which statement is true about topics and tables?
• Under the standard scaling policy, when will a multi-cluster Snowflake warehouse shut down?
• By default, does COPY purge loaded files from the location?
• What is the result of the following query on the table null_count_test? select count(*), count(nct.*), count(col1), count(distinct col1), count(distinct col1, col2), approx_count_distinct(*) from null_count_test nct;
• The 24-hour early access feature is intended to enable testing and validation prior to what?
• Tri-Secret Secure, which enables customer-managed encryption keys, is supported in which editions?
• Which tables can SHOW TABLES list?
• When adding search optimization to a table, what occurs?
• The maximum number of credits consumed by the multi-cluster warehouse per full hour of usage depends on
• What is the exact naming format for a Snowflake Kafka connector pipe?
• Which Snowflake object executes code outside Snowflake, i.e., a remote service?
• Does VALIDATION_MODE support COPY statements that transform data during a load?
• What is the real maximum batch size limit for external functions in Snowflake?
• If a table’s micro-partitions change due to clustering or consolidation, what happens to persisted query results?
• Cross-region data sharing is supported for Snowflake accounts hosted on which cloud providers?
• Which statement about VARCHAR synonyms in Snowflake is correct?
• Which object can be used as a table function in Information_schema to view replication costs?
• Which description best captures the role of VALIDATION_MODE when using COPY INTO?
• To experience benefits from clustering, table data must be in which size range?
• Snowflake stores security-related external function information in what kind of integration?
• Cross-account database failover and failback requires which Snowflake edition combination?
• Which operation is NOT allowed on a Shared database?
• How do you suspend and resume Automatic Clustering for a clustered table ?
• Does the VARIANT data type impose a 16MB size limit on individual rows?
• How many credits will a medium-size warehouse consume in a setup with two auto-scaled clusters for three hours, where the first cluster runs continuously and the second runs for 30 minutes in the second hour?
• A search access path becomes invalid when which change occurs?
• Can one masking policy be applied to multiple columns?
• What are the four levels of keys in Snowflake's hierarchical key model?
• Which statement correctly describes the meaning of SYSTEM$CLUSTERING_DEPTH?
• What is the effect of Snowflake setting a load status in the table metadata for the data files referenced by a COPY statement?
• If the source table has automatic clustering enabled, the new table starts with Automatic Clustering suspended.
• In a VARIANT column, NULL values are stored as the string 'null' rather than the SQL NULL value.
• Under Economy Scaling, a warehouse is started only if the system estimates there is enough query load to keep the warehouse busy for at least how many minutes?
• The Snowflake SQL API provides the ability to submit SQL statements for execution.
• Where can masking policies be applied in Snowflake?
• How does Snowflake handle maintenance of materialized views?
• How can you verify that search optimization is enabled on a table?
• In Maximized mode, decreasing the max and min for a running cluster results in the specified number of warehouses shutting down after they finish executing statements and the auto-suspend period elapses.
• Which of the following objects can be included in a Snowflake share?
• Defining a clustering key directly on top of VARIANT columns is not supported; however, you can specify a VARIANT column in a clustering key if you provide an expression consisting of the path and the target type.
• SnowSQL is a REST API.
• Which statement best describes the purpose of Table stages in Snowflake?
• What is the meaning of 'Local Disk IO' in the query profiler?
• Which statement is true about cloning privileges transfer?
• As a data provider, if you own the objects in a share but do not own the share, how can you remove an object from the share?
• With a task configured to run WHEN SYSTEM$STREAM_HAS_DATA('ST1'), what happens if the stream has no data?
• During cloning, which pipes are not cloned?
• GET_OBJECT_REFERENCES can identify references to which objects?
• What does SCHEDULE = '5 minute' specify for a Snowflake TASK?
• For a multi-cluster warehouse, auto-resume only applies when the entire warehouse is suspended (i.e., no clusters are running).
• Which object cannot be cloned?
• Which metric is included in the SYSTEM$CLUSTERING_INFORMATION output?
• Which technique is commonly used to improve Snowflake query performance by physically organizing data?
• Snowpipe is designed to load new data typically within a minute after a file notification is sent.
• ON_ERROR ABORT_STATEMENT during bulk load causes what outcome?
• What is the best option to clone a table named MYTABLE?
• Historical data is no longer available for querying.
• Which statement about stage and storage integration parameter handling is true?
• The cloud services layer coordinates activities across Snowflake and processes user requests, from login to query dispatch.
• Future grants of privileges on masking policies are not supported.
• What is the aim of Snowflake's Search Optimization Service?
• Which statement about a Snowflake session and current warehouses is true?
• Which compression method is NOT yet detectable by Snowflake?
• Which statement is false about the following Snowflake task?
• Which file format option controls skipping header lines in a file?
• SCIM is an open specification to automate the management of user identities and groups using RESTful APIs.
• How often does Snowflake rotate object keys?
• In Snowflake's Kafka connector, how many pipes are created relative to topic partitions?
• SnowCD checks access to which resources?
• Which query will use warehouse credits?
• Can a user set a Column-level Security masking policy on a table or view column with the APPLY MASKING POLICY privilege?
• What privilege must the stage owner have on the storage integration?
• Which statement about clustering depth is correct?
• How to suspend a recluster via SQL?
• Which command can drop a Kafka pipe?
• Data Load metadata expires after how many days?
• Which feature is not supported by Snowpipe for data loading?
• When the retention period ends for an object, then
• Recommended amount of columns OR expressions per key
• Which usage schema has higher latency for views, according to the material?
• A cloned container object retains privileges granted on the objects contained in the source object.
• When UNDROP is blocked due to a name collision, what operation enables restoring the previous version?
• In SnowSQL, the FILES parameter in a COPY INTO statement from a stage can specify a maximum of how many files?
• Which statement best describes the impact of spilling to disk on performance?
• If the same file format option is defined in multiple locations, what happens?
• Which property helps Snowflake group rows into the same micro-partition?
• Which function converts its input to a JSON string representation?
• External tables support views, query and join operations?
• What is the standard account URL for an AWS US West (Oregon) region account with locator 'xy12345'?
• Object Tagging can be associated with account-level objects, schemas and schema-level objects, and table columns.
• In external functions, where is the code executed and input relayed?
• How can you determine the last refresh time of a materialized view?
• Which Snowflake edition is abbreviated as VPS?
• To replicate data across Snowflake regions, you must maintain a separate Snowflake account in each region.
• SHOW TABLES includes which tables in its results?
• A masking policy cannot be set on a view if a materialized view is created from that view.
• Which command assigns the read_only_rl role to the SYSADMIN role?
• Which role can view account-level Credit and Storage Usage?
• STRIP_OUTER_ARRAY should be enabled when variant data exceeds 16 MB.
• The cloning operation fails if Time Travel exceeds the retention time of any current child.
• What is the spill sequence when a query cannot fit in memory?
• What does a 200 HTTP response from the insertFiles Snowpipe endpoint indicate?
• What is the maximum size of a SQL statement submitted through a client?
• What is the purpose of the SYSTEM$CLUSTERING_INFORMATION function?
• Copy command is used for data unloading.
• What is the correct order of precedence for file format options across COPY INTO TABLE, stage, and table definitions?
• Which Snowflake tool is used as a command line diagnostic tool for identifying and fixing client network connectivity issues?
• Which statement about the insertReport endpoint limitations is correct?
• In which order does Snowflake determine the default warehouse for a session?
• What happens to uncompressed files when staged in Snowflake by default?
• Under the economy scaling policy, what triggers starting a new cluster?
• What does the STRIP_OUTER_ARRAY option do when loading semi-structured data?
• Snowpipe overhead to manage files in the internal load queue is included in utilization costs and increases with the number of files queued.
• Which keyword is used with GRANT to specify future privileges on database or schema objects?
• Which Snowpipe creation command is correct for data hosted on AWS S3?
• Materialized views are particularly useful under which conditions?
• What portion of cloud services usage is typically free?
• Snowflake uses columnar scanning of partitions to avoid scanning an entire partition when a query filters on a single column.
• The Snowflake SQL API does not support cancellation of a statement's execution.
• Which statement about storage integration parameters is true?
• In Snowflake, which usage schema includes dropped objects that Information Schema does not?
• Database failover and failback between Snowflake accounts for business continuity and disaster recovery is available with which editions?
• What privileges are required to create a stage that uses a storage integration?
• When some compute resources fail to provision, the warehouse consumes credits for what?
• What is the typical consequence of including more than the recommended number of columns or expressions in a clustering key?
• Historical data available to query in a primary database using Time Travel is not replicated to secondary databases.
• Which command is used to create the read_only_rl role in Snowflake?
• Which file format option controls the encoding of the input data?
• For a multi-cluster warehouse, auto-suspend only occurs when the minimum number of clusters is running and there is no activity for the specified period of time.
• Which of the following objects cannot be part of a direct share?
• Time Travel in a secondary database can produce identical results to the primary database.
• Which scenario causes replication to fail for policy-protected objects?
• If any compute resources fail to provision during startup, what does Snowflake do?
• Is refreshing a secondary database blocked if an external table exists in the primary database?
• What is the consequence of exceeding the recommended number of columns per clustering key?
• When cloning a database, schema or table, do privileges on the source object transfer to the cloned object?
• Which authentication method does the Kafka connector use?
• When using a column with very high cardinality as a clustering key, Snowflake recommends:
• A snapshot of the primary database's objects and data is transferred to the secondary database during replication.
• Is smaller clustering depth indicative of better clustering?
• What does the term 'Bytes spilled to remote storage' indicate in the Snowflake query profiler?
• When describing a table created with NAME STRING(100), what data type will be shown for the NAME column?
• Are reclustering operations performed on the primary database also applied automatically to the replicated database?
• Which of the following is a valid Snowflake provided Usage Schema?
• Which SQL statement removes search optimization from a table?
• Snowflake variant columns can be accessed using which notations?
• What is the time window for results returned by RESULT_SCAN?
• Clustering information maintained for micro-partitions includes which of the following?
• Which statement about search access path changes when modifying columns is true?
• Snowflake can be run on private cloud infrastructures.
• Which SnowPipe REST endpoint fetches a report of ingested files whose contents were recently added to a table?
• Which SnowPipe REST endpoint fetches a history between two points in time?
• What is a materialized view?
• What is the default ON_ERROR option for Snowpipe?
• Which strategy aligns privileges with business functions by creating object access roles and assigning them to functional roles?
• The Snowflake feature that provides 24-hour early access to weekly releases for testing before deployment to production accounts is available with which edition?
• Which statement describes the data stored in micro-partitions related to value ranges and distinct values?
• Which statement about fail-safe data in a Snowflake secondary database is true?
• Cardinality is ?
• Are cloud-based functions such as AWS Lambda and Microsoft Azure Functions considered remote services in Snowflake external functions?
• Which command sequence switches the current session context to the role DBA_ROLE in Snowflake?
• Which view in Account Usage schema is used to get details of Pipes objects?
• A cloned object is considered a new object in Snowflake.
• A point lookup query in Snowflake is defined as returning what?
• The error message 'Variable is not defined' can be caused by using the ampersand character (&) inside a statement.
• What is the max number of warehouses you can define in a multi cluster warehouse?
• What does SnowCD verify regarding HTTP communications?
• OAuth authentication is supported by Snowflake.
• To load or unload data from or to a stage that uses a storage integration, which privilege on the stage is required?
• A masking policy cannot be set on a table if a materialized view already exists from that underlying table.
• In the command referencing an internal stage @xf_tuts.public.%emp_raw from a Put command, which internal stage name is indicated by the percent sign?
• Which type of tables typically benefits from creating a cluster key?
• Which property helps enable effective pruning on the table?
• Which statement describes a feature of Snowflake replication?
• What is the default scaling policy for multi-cluster warehouses?
• Which properties make a query a good candidate for search optimization?
• Partition columns for an external table can be defined using expressions such as col1 varchar as (parse_json(metadata$external_table_partition):col1::varchar). Is this statement true?
• Which privileges are required to manage external tables?
• During replication, what is transferred to the secondary database?
• The Stage type that cannot be altered or dropped is 'User and Table Stages'.
• What happens if you attempt to set a column to NOT NULL and the column contains NULL values?
• External tables can be used for query and join operations.
• Python is listed among the native Snowflake clients.
• Regions do not limit user access to Snowflake; they only dictate where data is stored and where compute resources are provisioned.
• Which statement about the Snowflake Search Optimization service is true?
• Quiesce mode refers to which of the following descriptions?
• Which statement requires a running warehouse to execute?
• Which of the following is a valid example of an external table partition column expression?
• What is a reader account in Snowflake?
• Which command converts JSON NULL values to SQL NULL values?
• Which statement is true regarding Row Access Policy for Materialized Views?
• Which best describes IP whitelisting in Snowflake context?
• In a Snowflake query profile, what does the metric Partitions Scanned versus Partitions Total indicate?
• What is the output of the query: SELECT TOP 100 AGE FROM USERS?
• Which statement is true about replication of policy-protected objects?
• What does VPS stand for in Snowflake terminology?
• Secure, direct proxy to your other virtual networks or on-premises data centers via PrivateLink is supported in which Snowflake editions?
• Are materialized views clusterable in Snowflake in the same way as base tables?
• Is reclustering automatic after you define a clustering key on a table?
• Higher cardinality before lower cardinality reduces effectiveness
• Which statement about GROUP BY usage in materialized views is true?
• Why does removing files from a stage improve the next COPY INTO operation?
• What is the default ON_ERROR option when Bulk loading?
• When defining a multi-column clustering key for a table, the order of columns in CLUSTER BY should be:
• Which file format option specifies how times are parsed in the input data?
• What is the recommended method for using a newly created role?
• To use Snowflake across multiple regions, you must maintain a separate Snowflake account in each region.
• SHOW GRANTS TO ROLE SYSADMIN displays which of the following?
• Which principle states that a role should be assigned the least privileges necessary?
• Which of the following is presented as a limitation of using Row Access Policies?
• In Snowflake, every data file is encrypted with a separate key.
• To list all privileges and roles that a role named PYTHON_DEV_ROLE has, which command is most appropriate?
• How long does each successive warehouse wait after the prior one starts, in the Standard policy?
• Which object will NOT be cloned when cloning a schema?
• Can a permanent table be cloned into a temporary or transient table?
• Charges based on database replication are billed on which account?
• Dedicated metadata store and pool of compute resources used in virtual warehouses is provided by which Snowflake edition?
• Can you define a clustering key directly on a VARIANT column?
• Which of the following is NOT listed as a datatype that can be unloaded?
• Which region code corresponds to Canada Central for Snowflake on AWS?
• An existing clustering key is not supported when a table is created using CREATE TABLE ... AS SELECT; however, you can define a clustering key after the table is created.
• Command to turn off variable substitution is '!set variable_substitution=false'.
• Are Azure VNet subnet IDs for a Snowflake account required to be in the same Azure region as the storage account?
• What begins the data retention period for tables in a secondary database?
• When resizing a multi-cluster warehouse, which clusters are resized?
• Which statement describes a limitation related to attaching a row access policy to streams?
• What is the typical minimum number of clusters required for auto-suspend in a multi-cluster warehouse?
• All data in Snowflake tables is automatically divided into micro-partitions, which are what?
• What is true with respect to failing resource provisioning with warehouses?
• What is the minimum database-level permission required to work with external tables?
• SCIM is the open specification to automate management of user identities and groups in cloud applications using RESTful APIs.
• After a full release has been deployed, Snowflake uses a staged approach to move accounts.
• Which mode indicates a compute resource is actively processing queries?
• The cloud services layer runs on compute instances provisioned by Snowflake from the cloud provider.
• Among factors impacting query processing, which has greater impact: the overall size of the tables being queried or the number of rows?
• Are account parameters replicated with database replication?
• Partner Connect is limited to which system role?
• Who pays for compute when a consumer uses a reader account to access shared data?
• What kind of workloads are materialized views designed to speed up?
• If a medium-size warehouse with 2 clusters runs for 3 hours in maximized mode, how many credits does it consume?
• All external tables include the following columns: VALUE
• In a COPY INTO statement, which approach specifies the exact files to load from a stage?
• As required by HIPAA and HITRUST CSF regulations, before any PHI data can be stored in Snowflake, a signed business associate agreement (BAA) must be in place.
• Can a Schema Owner grant object privileges in a managed access schema?
• Which component is NOT typically used in building continuous ELT pipelines?
• Temporary tables belong to a specified database and schema?
• What happens to pipes referencing internal stages during cloning?
• Snowflake provides two ways to view replication costs incurred with database replication. Which are they?
• Automatic Clustering is transparent and does not block DML statements issued against tables while they are being reclustered.
• What is the default clustering state for a Snowflake table with no clustering key defined?
• To which entity are privileges directly granted in Snowflake?
• Which statement about Snowflake authentication is true?
• When cloning a database or schema, tables are cloned, which means the internal stage associated with each table is also cloned but the cloned table stages are empty.
• What is the most likely cause if a large join query takes hours to complete even after increasing the warehouse size?
• When is reclustering triggered?
• What does zero-copy cloning do for a table?
• Partition columns for an external table can be derived from the file path and/or filename.
• Account object replication, failover/failback, and client redirect require which edition or higher?
• What is a typical consequence of using the loadHistoryScan endpoint excessively in Snowpipe?
• What is the interval used for checks when evaluating scaling decisions in Snowflake's multi-cluster warehouses?
• In the Kafka integration, which columns are used to store the data payload and metadata for each topic's records?
• In Snowflake's encryption architecture, the account master key corresponds to one customer account.
• When creating a table with USER_ID NUMBER, what datatype is shown for USER_ID in SHOW COLUMNS?
• Why is it not recommended to use SELECT * in the definition of a materialized view?
• Which statement best describes the handling of ON_ERROR settings for bulk loading and Snowpipe?
• Exit code 3 indicates SnowSQL could not contact the server.
• A Snowflake account hostname starts with the account identifier and ends with snowflakecomputing.com.
• You must specify file format and copy options as part of the COPY INTO <table> command.
• Which of the following is NOT a Context Function in the Session Context sub-category?
• For a Snowflake external function, which type of endpoint must the remote service expose?
• Which option sets the delimiter in a file format?
• In OCSP, Snowflake evaluates each certificate in the chain of trust up to which certificate level?
• If you are using an existing stage to access external tables, which permission is required on the Stage?
• What is the primary purpose of SnowCD?
• Which statement accurately differentiates the loadHistoryScan and insertReport endpoints in Snowpipe?
• What are SnowPipe cost charging units in context to files queued?
• How does Snowflake deploy a full release to accounts?
• Which of the following operations updates the search access path automatically?
• During a refresh, are the materialized view definitions replicated to the secondary database?
• Can a Schema Owner grant object privileges in a regular schema?
• Which account parameter is used for enabling Snowflake-initiated (SSO) login on the main login page?
• What type of searches does the search optimization service speed up?
• Under the economy scaling policy, when will a multi-cluster Snowflake warehouse shut down?
• What is the SQL fragment used to add search optimization to a table?
• Snowpipe ON_ERROR SKIP_FILE results in what?
• Past objects that were dropped can no longer be restored.
• Which command lists all object references of a specific view?
• In what order should you set columns for a multicluster key?
• In a masking policy that shows the plain-text value only to a specific role, what value is shown to a user without that role?
• Which of the following is NOT a valid COPY INTO option for error handling?
• In a multi-cluster warehouse using standard scaling, what is the maximum number of clusters configured in the example?
• Which of the following languages is NOT supported for UDFs?
• Which statement about RECORD_METADATA in Kafka-loaded Snowflake tables is true?
• What are the three types of parameters in Snowflake?
• When a database or schema that contains tasks is cloned, the tasks in the clone are suspended by default?
• If a table is cloned, historical data for the table clone begins at the time/point when the clone was created.
• What are the default delimiters for CSV files in Snowflake?
• The cloud services layer is a collection of services that coordinates activities across Snowflake.
• Why does Snowflake advise against adding more than 3–4 columns to a cluster key?
• In the given Snowflake scenario, what is the BEST architecture for sharing POS data with 500+ retailers using Snowflake?
• True or False: A single clustering key can contain one or more columns or expressions
• If ownership of an external table is transferred to a different role, what happens to AUTO_REFRESH by default?
• What is the recommended approach for speeding up complex aggregations on a large, slowly changing dataset subset?
• What does the query time predicate METADATA$ACTION='INSERT' do in a Snowflake query?
• Which object parameter is replicated during replication?
• Which storage stage requires the INTEGRATION parameter for Snowpipe AUTO_INGEST?
• When cloning a database or schema, what happens to data files in the source tables' internal stages?
• To optimize parallel loads, what compressed data file size is recommended by Snowflake?
• What is the maximum retention time for events in the insertReport API?
• How is data skew best described in the context of Snowflake data distribution?
• Which statements describe use-cases for cross-cloud and cross-region replication?
• After 2-3 consecutive successful checks performed at 1-minute intervals, what is determined?
• In Snowflake, compute resources waiting to shut down are considered to be in which mode?
• Snowflake prunes micro-partitions based on a predicate with a subquery, even if the subquery results in a constant.
• Which statement best describes micro-partitions?
• Snowflake recommends relying more on which endpoint to avoid rate limits when monitoring data loads?
• Are external tables read-only, meaning no DML operations can be performed?
• Which statement about micro-partition properties used to optimize queries is correct?
• Is it good practice to drop the Search Optimization Service before re-clustering and re-adding it after?
• Views can be created against external tables.
• What types of columns are most useful when selecting for clustering?
• Can we clone a temporary table into a permanent one?
• What is the VARIANT data size limitation for semi-structured data when compressed?
• Which of the following options describes the Snowpipe 429 error meaning?
• During a Snowflake trial account, free credits are consumed only when which resources are active?
• If a user is associated to both an account-level and user-level network policy, which policy takes precedence?
• What does 'Percentage scanned from cache' indicate in Snowflake's query profiler?
• Does CREATE OR REPLACE TABLE ... LIKE ... require a running warehouse?
• If a masking policy references an external function, what is the effect on sharing the table or view?
• For each Kafka topic, what objects does the Snowflake Kafka Connector create?
• Snowflake moves data between accounts automatically when replication is configured.
• If a query takes 20 minutes to run and the warehouse auto-suspends after 15 minutes, what happens?
• In Snowflake, does referencing a previous query's results via RESULT_SCAN incur compute credits?
• When a query spills to both local and remote storage, what does that imply about memory usage?
• Snowflake encryption uses which approach?
• By default, inbound shares can be accessible by which role?
• Which of the following is the correct region code for US West (Oregon) in Snowflake on AWS?
• Snowflake uses which protocol to determine certificate revocation during HTTPS connections?
• Where is the code for external functions executed?
• With a multi-cluster warehouse configured for standard scaling and a maximum of eight clusters, what is the maximum time to start all clusters if heavy query load triggers new cluster startups?
• Which setting helps you strip the leading space in file format options?
• Which statement is true about Snowflake materialized views?
• Which REST endpoint does Snowpipe API provide for uploading data?
• On a database created from a share, which privilege is used to grant or revoke access?
• Economy Scaling Policy is characterized by which behavior?
• Which metric is not listed in the Execution Time screen of the Query Profiler?
• Under Standard Scaling Policy, how is queuing minimized?
• In a masking policy, which value can be returned for unauthorized users in the else clause?
• SnowCD can connect via which of the following methods?
• All SnowSQL commands start with an exclamation point (!) followed by the command name.
• In Snowflake, what event occurs for data submitted via insertFiles when its contents are committed to a table and become query-accessible?
• After cloning a database, what is true about privileges for roles?
• What happens when you add a new column to a table that uses search optimization?
• Which Snowflake edition supports SOC 1 Type II compliance and SOC 2 Type II compliance security features?
• How is the compute resource usage for Snowflake's cloud services layer billed?
• Tri-Secret Secure refers to customer-managed encryption keys used to protect data at rest.
• Which pseudocolumn identifies the name of each staged data file included in the external table, including its path in the stage?
• Which file format option controls the NULL_IF behavior?
• Can a Database created from a Share be replicated?
• Which commands are considered TCL (Transaction Control Language) in Snowflake?
• Where can replication costs data be accessed in Snowflake?
• Which of the following is NOT a global privilege object type?
• Which SQL statement requires an active running warehouse?
• Does the search optimization service support tables with masking policies and row access policies?
• Which data types are supported by the Search Optimization service?
• Which of the following is included in the SYSTEM$CLUSTERING_INFORMATION output?
• If a warehouse runs for 61 seconds, shuts down, and restarts and runs for less than 60 seconds, it is billed for how many seconds?
• Which statement about materialized view limitations is true?
• Clustering is most beneficial for which type of tables?
• The data retention period for tables in a secondary database begins when the secondary database is refreshed with the DML operations written to tables in the primary database.
• In Snowflake, in which scenario is the maximized mode of a multi-cluster warehouse appropriate?
• What is the default timeout in hours for Snowflake statements (STATEMENT_TIMEOUT_IN_SECONDS)?
• A region group is a group of regions that offer similar security controls, isolation and compliance?
• Which of the following is not a type of Snowflake product release?
• In Maximized mode, increasing the max and min warehouses for a running cluster causes the specified number of warehouses to start immediately.
• Which edition range supports secure direct proxy to VNETs using PrivateLink?
• When a database is cloned, which privileges of the original database are replicated in the cloned database?
• If an object with the same name already exists when attempting UNDROP, what must you do to restore the previous version?
• What is the purpose of the DBA_ROLE in this scenario?
• The root key is the top-level in Snowflake's hierarchical key model.
• During the repair process, the warehouse starts processing SQL statements once 50% or more of the requested compute resources are successfully provisioned.
• Can an Object Owner grant object privileges in a regular schema?
• Before 2022, replication in Snowflake was limited to which object type?
• What is the retention period for historical data in Account Usage compared to Information Schema?
• True or False: After a key has been defined on a table, no additional administration is required?
• Which statement accurately describes Snowflake network policies?
• Which statement is true about database replication in Snowflake?
• What is the name of the Snowflake-provided warehouse used for billing Automatic Clustering?
• What might cause a query to spill to remote storage in Snowflake?
• Do reclustering operations performed on the primary database apply to the replicated database for performance improvement?
• Time Travel and Fail-safe data is maintained independently for a secondary database and is not replicated from the primary database.
• When using Search Optimization, if table data is updated what happens?
• Which ON_ERROR option is NOT valid when loading data with COPY INTO?
• After dropping an object, creating a new object with the same name results in which outcome?
• Which action allows a role that owns objects in a share but is not the share owner to access those objects?
• Which privilege is required on the table to use the Search Optimization Service for a query?
• If the Organizations feature is enabled, specifying the Snowflake Region ID as part of an account identifier is required when you create a new account and configure replication and failover?
• What is the clustering depth of a table with no micro-partitions?
• Which function deconstructs an OBJECT into its components?
• Individual external named stages can be cloned.
• In data sharing, a data sharing provider cannot create a masking policy in a reader account.
• What is the primary advantage of using Snowflake Data Exchange for sharing data with a network of retailers?
• What is the purpose of external functions in Snowflake?
• When are materialized views NOT recommended?
• Which statement is true regarding a row access policy on a materialized view, given no policy on the underlying table?
• What is the default multi-cluster warehouse scaling policy?
• Which option allows loading all files even if their metadata has expired?
• Which region code corresponds to US East (Ohio) in Snowflake AWS regions?
• Materialized views speed up which kind of operations?
• Which parameter should be set to unload data in only one file when using COPY INTO?
• Custom roles can be created by the SECURITYADMIN role as well as by any role to which the CREATE ROLE privilege has been granted.
• SnowPipe REST endpoints: which option correctly identifies the endpoint that provides a POST method to inform Snowflake about files to ingest?
• After CREATE TABLE ... AS SELECT, you can define a clustering key after the table is created.
• Which Snowflake feature enables secure sharing of data with internal and external parties?
• Which statement describes the best practice when adding search optimization to a table?
• An existing clustering key is propagated when a table is created using CREATE TABLE ... LIKE.
• Delimited (CSV, TSV) is a supported loading format.
• During loading/unloading, staged files encryption uses which of the following?
• To maximize throughput, where is it recommended to run your Kafka Connect instance relative to your Snowflake account?
• Which of the following is NOT a securable object in Snowflake?
• Which statement about the CLUSTER BY clause is true?
• Auto-suspend and auto-resume are enabled by default.
• Snowflake recommends using the insertReport endpoint rather than the loadHistoryScan when working with Snowpipe. Which statement best explains why?
• How can you add a clustering key to the existing table MYTABLE in the columns USER and CREATED_AT?
• What is the definition of securable objects?
• If a masking policy is set on an underlying table or view column and a materialized view is created from that table or view, the materialized view only contains columns that are not protected by a masking policy.
• What does the insertReport Snowpipe endpoint do?
• A user can change object parameters using which roles?
• Snowflake architecture is a hybrid of traditional shared-disk and shared-nothing database architectures.
• Which privilege is required on the Stage to manage external tables?
• Does Snowflake support creating TRANSIENT databases and schemas?
• Which option purges loaded data files in the COPY INTO command?
• Are privileges granted on database objects replicated to the secondary database?
• In Snowflake, who receives privileges directly?
• How do you restore a dropped share?
• Can we create materialized views without any additional cost?
• Which of the following columns contains the Kafka message payload in Snowflake tables loaded by the Kafka connector?
• How can we disable auto suspend on a warehouse?
• When cloning a database or schema, which pipes are cloned?
• METADATA$FILE_ROW_NUMBER shows the row number for each record in a staged data file.
• Which command lists all privileges granted to a role?
• Can Snowflake replicate databases across regions and cloud providers?
• Exit code 5 indicates the exit_on_error configuration option was set and SnowSQL exited because of an error.
• What does role hierarchy and privilege inheritance accomplish in Snowflake's access control model?
• Which of the following are stored in micro-partitions to support optimization and query processing?
• In Snowflake, all tables created in a transient schema, as well as all schemas created in a transient database, are transient by definition.
• The billing for Automatic Clustering is charged via a separate warehouse named AUTOMATIC_CLUSTERING.
• Which REST endpoint is part of Snowpipe API for loading data?
• Auto-suspend in a multi-cluster warehouse occurs under what condition?
• Snowpipe supports which types of stages in Snowflake?
• Which command is used to refresh a materialized view?
• What is the recommended pattern for calling the Snowpipe loadHistoryScan endpoint to avoid rate limits?
• Which command parameter allows scheduling a task with a CRON expression?
• Which query will fail if a table was created with DDL: CREATE TABLE MYTABLE (ID INTEGER, NAME VARCHAR)?
• Can you specify more than one file format when loading a table?
• What is the purpose of row-level security in Snowflake?
• The read_only_rl role has a comment indicating it is limited to querying tables in schema_1.
• Which of the following are types of Snowflake product releases?
• A user can change session parameters using which roles?
• SnowSQL supports key pair authentication and key rotation, and does not support unencrypted private keys.
• Snowflake allows setting a masking policy on a materialized view column.
• Which parameter is used for Snowpipe auto-ingest with AWS S3 stages?
• Which file format option should be set to STRIP_NULL_VALUES=TRUE when loading JSON files to remove null values representing missing data?
• True or False: You can cluster materialized views just like tables?
• Which clause sorts the result set by a specified column?
• Which privileges are required to add or remove search optimization?
• Which ALTER TABLE command can change a column's data type, potentially impacting Time Travel behavior?
• What is a recommended practice for the ACCOUNTADMIN role to avoid long password reset procedures?
• Snowflake encryption by default is true statement?
• GET_OBJECT_REFERENCES returns which types of objects?
• Which Snowflake function constructs an OBJECT from the arguments provided by a query (such as table columns)?
• For file formats, the only supported character set is UTF-8.
• What is the default warehouse size in the Snowflake Web UI?
• What tables are clustering useful for?
• When is a multicluster warehouse in maximized mode?
• How does the search optimization service function?
• What is the credits value for a Small (S) warehouse?
• Which statement is true about the insertReport API limitations?
• Regarding query result retention, using a query result resets the 24-hour retention window, and results are retained for up to 31 days from the first execution.
• True or False: Search Optimization is a table-level property?
• During a refresh, which aspect of materialized views is replicated to the secondary database?
• What is the default behavior of ON ERROR when loading staged data into the target table using COPY INTO?
• In the Snowflake query profiler, what does the Processing statistic represent?
• How is query load calculated for an interval in Snowflake?
• When cloning a database or schema, any pipes in the source container that reference an internal (Snowflake) stage are not cloned.
• Which command deletes a share from the Snowflake account?
• If the source table has automatic clustering enabled, the new table created by CLONE starts with Automatic Clustering suspended.
• Why might a profiler show different information for a secure view compared with a standard view?
• Which file format option specifies how dates are parsed in the input data?
• If you do not intend to use variable substitution, you can avoid the problem by turning off variable substitution.
• Which of the following is NOT listed as a CSV file format option for unloading?
• Does Snowflake support both row-level and column-level security policies?
• In Snowflake, can a role be granted to another role?
• Under which condition will a multi-cluster warehouse start a new cluster when using the economy scaling policy?
• Which database object is not replicated to the secondary database during replication?
• Which is the fastest approach to identify data files to load from a stage?
• An existing clustering key is copied when a table is created using CREATE TABLE ... CLONE.
• In a masking policy where the plain-text value is shown only to a user with a specific role, which statement is true about who sees the plain-text value?
• Internal (i.e. Snowflake) named stages cannot be cloned.
• SnowCD accepts which input formats?
• How many days of query history can you view in the History tab?
• True or False: The search optimization service does NOT directly improve the performance of joins.
• What does clustering depth measure?
• There is a limit to the number of databases, schemas, or tables you can create.
• Are Snowflake variant element names case-sensitive?
• Which feature enables applying a masking policy to a column for column‑level security?