True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A . True
- B . False
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html
True or False: You can define multiple columns within a clustering key on a table.
- A . True
- B . False
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
- A . True
- B . False
Which of the following statements is true of data loading?
- A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
- B . The "deal file size for loading is 16MB to match micro-partition size
- C . Marry files in the 10-lOOMB range tend to land In the ‘sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A . Bulk copy from an External Stage
- B . Continuous load using Snowpipe REST API
- C . The Snowflake Web Interface (UT) data loading wizard
- D . Bulk copy from an Internal Stage
A,B,C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-overview.html
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
- A . SCIM
- B . Federated authentication
- C . TLS 1.2
- D . Key-pair authentication
- E . OAuth
- F . OCSP authentication
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
- A . SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- B . SECURITYADMIN ACCOUNTADMIN, SYSADMIN
- C . SECURITYADMIN, ACCOUNTADMIN
- D . ACCOUNTADMIN
D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
Which of the following statement is true of Snowflake?
- A . It was built specifically for the cloud
- B . it was built as an on-premises solution and then potted to the cloud
- C . It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- D . It was built for Hadoop architecture
- E . It’s based on an Oracle Architecture
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A . True
- B . False
B
Explanation:
https://docs.snowflake.com/en/user-guide/jdbc.html
Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
- A . INITTIALLY_SUSPENDED = TRUE/FALSE
- B . START_AFTCR_CREATE = TRUE/FALSE
- C . START_TTIME = 60 // (seconds from now)
- D . START.TIME = CURRENT.DATE()
What is the minimum Snowflake edition required to create a materialized view?
- A . Standard Edition
- B . Enterprise Edition
- C . Business Critical Edition
- D . Virtual Private Snowflake Edition
B
Explanation:
Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.
Which type of table corresponds to a single Snowflake session?
- A . Temporary
- B . Translent
- C . Provisional
- D . Permanent
A
Explanation:
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session. https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%2 0remainder%20of%20the%20session.
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
- A . True
- B . False
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A . Through the Snowflake web interface (Ul)
- B . Through the DATA_SHARE=TRUE parameter
- C . Through SQL commands
- D . Through the enable__share=true parameter
- E . Using the CREATE SHARE AS SELECT * TABLE command
What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers
- A . On-premise availability
- B . Simplicity
- C . Open source based
- D . Concurrency
- E . Performance
True or False: Snowflake charges a premium for storing semi-structured data.
- A . True
- B . False
B
Explanation:
Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A . A Schema may contain one or more Databases
- B . A Database may contain one or more Schemas
- C . A Schema is a logical grouping of Database Objects
- D . Each Schema is contained within a Warehouse
B,C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html
What is the minimum duration charged when starting a virtual warehouse?
- A . 1 second
- B . 1 minute
- C . 1 hour
- D . 1 day
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
- A . The complexity of each query
- B . The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
- C . The size of the data required for each query
- D . The tool that s executing the query
A,C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers
- A . Amazon Web Services
- B . Private Virtual Cloud
- C . Oracle Cloud
- D . Microsoft Azure Cloud
True or False: All Snowflake table types include fail-safe storage.
- A . True
- B . False
True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.
- A . True
- B . False
B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
- A . True
- B . False
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html
What transformations are supported in a CREATE PIPE … AS COPY … FROM (….) statement? (Select TWO.)
- A . Data can be filtered by an optional where clause
- B . Incoming data can be joined with other tables
- C . Columns can be reordered
- D . Columns can be omitted
- E . Row level access can be defined
What is the minimum Snowflake edition that provides data sharing?
- A . Standard
- B . Premier
- C . Enterprise
- D . Business Critical Edition
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)
- A . JDBC
- B . SnowSQL
- C . Snowflake Web Interface (UI)
- D . ODBC
- E . Python
A,B,C,D,E
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
How long is Snowpipe data load history retained?
- A . As configured in the create pipe settings
- B . Until the pipe is dropped
- C . 64 days
- D . 14 days
C
Explanation:
Bulk data load
Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20data%20load&text=Stored%20in%20the%20metadata%20of,statement%20as%20the%20statement%20output.&text=Stored%20in%20the%20metadata%20of%20the%20pipe%20for%2014%20days.
True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
- A . True
- B . False
B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
- A . The object immediately becomes unavailable for all Data Consumers
- B . Any additional data arriving after this point in time will not be visible to Data Consumers
- C . The Data Consumers stop seeing data updates and become responsible for storage charges for the object
- D . A static copy of the object at the time the privilege was revoked is created In the Data Consumers’ accounts
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers
- A . SnowSQL
- B . ODBC
- C . R
- D . HIVE
A,B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/connecting.html
What privileges are required to create a task?
- A . The global privilege create task is required to create a new task.
- B . Tasks are created at the Application level and can only be created by the Account Admin role.
- C . Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
- D . The role must have access to the target schema and the create task privilege on the schema itself.
D
Explanation:
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A . VARIANT
- B . ARRAY
- C . VARCHAR
- D . XML
- E . BLOB
A,B
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)
- A . Growth of storage and compute are tightly coupled together
- B . Storage expands without the requirement to add more compute
- C . Compute can be scaled up or down without the requirement to add more storage
- D . Multiple compute clusters can access stored data without contention
B,C,D
Explanation:
Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt-separate-storage-and-compute-65d2dffd450f
What feature can be used to reorganize a very large table on one or more columns?
- A . Micro-partitions
- B . Clustering keys
- C . Key partitions
- D . Clustered partitions
B
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A . Via the Snowflake Web Interface (Ul)
- B . Via the data_share=true parameter
- C . Via SQL commands
- D . Via Virtual Warehouses
A,C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
Which copy INTO command outputs the data into one file?
- A . SINGLE=TRUE
- B . MAX_FILE_NUMBER=1
- C . FILE_NUMBER=1
- D . MULTIPLE=FAISE
How many shares can be consumed by single Data Consumer?
- A . 1
- B . 10
- C . 100, but can be increased by contacting support
- D . Unlimited
D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html
What command is used to load files into an Internal Stage within Snowflake?
- A . PUT
- B . COPY INTO
- C . TRANSFER
- D . INSERT
A
Explanation:
You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO <table> command when loading data into a table from the staged files.
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A . True
- B . False
B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A . To accommodate more queries
- B . To accommodate more users
- C . To accommodate fluctuations in workload
- D . To accommodate a more complex workload
D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
How would you determine the size of the virtual warehouse used for a task?
- A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
- B . Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- C . If using the stored procedure to execute multiple SQL statements, it’s best to test run the stored procedure separately to size the compute resource first
- D . Since task infrastructure is based on running the task body on schedule, it’s recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers
- A . MIN(< < column value>>)
- B . COPY
- C . SUM(<< column value >>)
- D . UPDATE
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A . Time Travel – 1 day. Fail-safe – 1 day
- B . Time Travel – 0 days. Fail-safe – 1 day
- C . Time Travel – 1 day. Fail-safe – 0 days
- D . Transient tables are retained in neither Fail-safe nor Time Travel
C
Explanation:
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manage&text=Temporary%20tables%20can%20also%20have,have%20no %20Fail%2Dsafe%20period.
What happens when a virtual warehouse is resized?
- A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
- B . When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
- C . The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
- D . Users who are trying to use the warehouse will receive an error message until the resizing is complete
Which statements are true of micro-partitions? Choose 2 answers
- A . They are approximately 16MB in size
- B . They are stored compressed only if COMPRESS=TRUE on Table
- C . They are Immutable
- D . They are only encrypted in the Enterprise edition and above
A,C
Explanation:
Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69
Which Snowflake partner specializes in data catalog solutions?
- A . Alation
- B . DataRobot
- C . dbt
- D . Tableau
A
Explanation:
Alation provides Data Cataloging functionality. They state they are the ‘One Place to Find, Understand, & Govern Data Across an Enterprise.
https://docs.snowflake.com/en/user-guide/ecosystem-all.html
A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?
- A . The primary cluster in the virtual warehouse
- B . The entire virtual warehouse
- C . The database in which the virtual warehouse resides
- D . The Queries currently being run on the virtual warehouse
B
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.
True or False: Snowpipe via RFST API can only reference External Stages as source.
- A . True
- B . False
B
Explanation:
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
Which statement best describes ” clustering”?
- A . Clustering represents the way data is grouped together and stored within snowflake’s micro-partitions
- B . The database administrator must define the clustering methodology for each Snowflake table.
- C . The clustering key must be included on the COPV command when loading data into Snowflake.
- D . Clustering can be disabled within a Snowflake account.
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
Which of the following statements would be used to export/unload data from Snowflake?
- A . COPY INTO @stage
- B . EXPORT TO @stage
- C . INSERT INTO @stage
- D . EXPORT_TO_STAGE (stage = > @Wage, select = > ‘select * from t1);
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
- A . Informatica
- B . Power Bl
- C . Adobe
- D . Data Robot
D
Explanation:
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
What is a key feature of Snowflake architecture?
- A . Zero-copy cloning creates a mirror copy of a database that updates with the original
- B . Software updates are automatically applied on a quarterly basis
- C . Snowflake eliminates resource contention with its virtual warehouse implementation
- D . Multi-cluster warehouses allow users to run a query that spans across multiple clusters
- E . Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Which of the following roles is recommended to be used to create and manage users and roles?
- A . SYSADMIN
- B . SECURITYADMIN
- C . PUBLIC
- D . ACCOUNTADMIN
B
Explanation:
https://docs.snowflake.com/en/user-guide/security-access-control-overview.html "Security admin: Role that can manage any object grant globally, as well as create, monitor, and manage users and roles"
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A . The validation_mode option is used when creating an Internal Stage
- B . validation_mode=return_all_errors is a parameter of the copy command
- C . The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- D . The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
B,D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html
True or False: Once created, a micro-partition will never be changed.
- A . True
- B . False
A
Explanation:
Reference: https://interworks.com/blog/kbridges/2019/03/12/time-travel-with-snowflake/
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A . Configure the Maximum Clusters setting to “Auto-Scale”
- B . Set the Warehouse type to “Auto”
- C . Set the Minimum Clusters and Maximum Clusters settings to the same value
- D . Set the Minimum Clusters and Maximum Clusters settings to the different values
D
Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
Which of the following describes how clustering keys work in Snowflake?
- A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
- B . Clustering keys sort the designated columns over time, without blocking DML operations
- C . Clustering keys create a distributed, parallel data structure of pointers to a table’s rows and columns
- D . Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
Which of the following are benefits of micro-partitioning? (Select TWO)
- A . Micro-partitions cannot overlap in their range of values
- B . Micro-partitions are immutable objects that support the use of Time Travel.
- C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
- D . Rows are automatically stored in sorted order within micro-partitions
- E . Micro-partitions can be defined on a schema-by-schema basis
A,D
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A . The Snowflake Web Interface (UI)
- B . SQL commands
- C . Data integration tools
- D . All of the above
D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A . Concurrency
- B . Performance
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A . True
- B . False
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.
Which are true of Snowflake roles?
- A . All grants to objects are given to roles, and never to users
- B . In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
- C . The public role controls at other roles
- D . Roles are a subset of users and users own objects In Snowflake
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
- A . 1 Hour
- B . 3 Hours
- C . 12 hours
- D . 24 hours
D
Explanation:
Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A . Pipe
- B . External stage
- C . Task
- D . Stream
A
Explanation:
Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers
- A . Their default role should be set to SYSTEMADMIN (the lower of the two)
- B . They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
- C . They should only access and ‘step into’ the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
- D . They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
- E . They should use the SYSADMIN role to perform administrative work on database objects
Which statement best describes Snowflake tables?
- A . Snowflake tables are logical representations of underlying physical data
- B . Snowflake tables ate the physical instantiation of data loaded Into Snowflake
- C . Snowflake tables require that clustering keys be defined to perform optimally
- D . Snowflake tables are owned by a user
A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the
data.
- A . True
- B . False
What is the MOST performant file format for loading data in Snowflake?
- A . CSV (Unzipped)
- B . Parquet
- C . CSV (Gzipped)
- D . ORC
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A . True
- B . False
A
Explanation:
Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
- A . True
- B . False
B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
What Snowflake role must be granted for a user to create and manage accounts?
- A . ACCOUNTADMIN
- B . ORGADMIN
- C . SECURITYADMIN
- D . SYSADMIN
A
Explanation:
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
A company strongly encourages all Snowflake users to self-enroll in Snowflake’s default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
- A . Okta Verify
- B . Duo Mobile
- C . Microsoft Authenticator
- D . Google Authenticator
B
Explanation:
https://docs.snowflake.com/en/user-guide/security-mfa.html
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.
- A . True
- B . False
B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/credits.html
A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?
- A . Organize files into logical paths
- B . Store the files on the external stage to ensure caching is maintained
- C . Use pattern matching for regular expression execution
- D . Load the data in one large file
What SQL command would be used to view all roles that were granted to user.1?
- A . show grants to user USER1;
- B . show grants of user USER1;
- C . describe user USER1;
- D . show grants on user USER1;
How often are encryption keys automatically rotated by Snowflake?
- A . 30 Days
- B . 60 Days
- C . 90 Days
- D . 365 Days
A
Explanation:
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is% 20automatically%20destroyed.
The FLATEEN function is used to query which type of data in Snowflake?
- A . Structured data
- B . Semi-structured data
- C . Both of the above
- D . None of the above
B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html
FLATTEN is used to unnest semi-structured data. Don’t see an application for structured data as by definition it shouldn’t be nested.
Which of the following is true of Snowpipe via REST API? Choose 2 answers
- A . you can only use it on internal Stages
- B . All COPY INTO options are available fluting pipe creation
- C . Snowflake automatically manages the compute required to execute the Pipe’s copy into commands
- D . Snowpipe keeps track of which files it has loaded
C,D
Explanation:
https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes
Which statement about billing applies to Snowflake credits?
- A . Credits are billed per-minute with a 60-minute minimum
- B . Credits are used to pay for cloud data storage usage
- C . Credits are consumed based on the number of credits billed for each hour that a warehouse runs
- D . Credits are consumed based on the warehouse size and the time the warehouse is running
D
Explanation:
Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used. https://docs.snowflake.com/en/user-guide/what-are-credits.html
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A . Is available to all Snowflake Editions
- B . Is only available to customers with Business Critical Edition
- C . Restricts or enables access to specific IP addresses
- D . Is activated using an “ALTER DATABASE” command
A,C
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html