Question1: 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.
Question2: Which of the following significantly improves the performance of selective point lookup queries on a table?
Question3: Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
Question4: True or False: It is possible to load data into Snowflake without creating a named File Format object.
Question5: What is the most granular object that the Time Travel retention can be defined on?
Select one.
Question6: Which Snowflake feature is used for both querying and restoring data?
Question7: Which command can be used to load data into an internal stage?
Question8: If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
Question9: Which command can be used to load data files into a Snowflake stage?
Question10: True or False: Snowflake charges a premium for storing semi-structured data.
Question11: Which of the following objects can be shared through secure data sharing?
Question12: True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
Question13: True or False: During data unloading, only JSON and CSV files can be compressed.
Question14: True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.
Question15: A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
Question16: A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
Question17: Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.
Question18: Which statement is true about running tasks in Snowflake?
Question19: What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
Question20: Which services does the Snowflake Cloud Services layer manage? (Select TWO).
Question21: When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.
Question22: What is the purpose of multi-cluster virtual warehouses?
Question23: The FLATEEN function is used to query which type of data in Snowflake?
Question24: Which statement best describes "clustering"?
Question25: True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
Question26: Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
Question27: Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
Question28: Which of the following terms best describes Snowflake's database architecture?
Question29: What is a responsibility of Snowflake's virtual warehouses?
Question30: Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?
Question31: Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.
Question32: The Query History in the Snowflake Web Interface (UI) is kept for approximately:
Question33: True or False: Snowpipe via REST API can only reference External Stages as source.
Question34: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Question35: Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Question36: What is the recommended Snowflake data type to store semi-structured data like JSON?
Question37: Where would a Snowflake user find information about query activity from 90 days ago?
Question38: Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Question39: Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Question40: Which command sets the Virtual Warehouse for a session?
Question41: What COPY INTO SQL command should be used to unload data into multiple files?
Question42: Which of the following describes external functions in Snowflake?
Question43: What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
Question44: Snowflake is designed for which type of workloads? (Choose two.)
Question45: Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
Question46: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
Question47: Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
Question48: True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Question49: What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Question50: Which type of table corresponds to a single Snowflake session?
Question51: Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)
Question52: Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
Question53: The number of queries that a Warehouse can concurrently process is determined by:
Choose 2 answers
Question54: If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
Question55: Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
Question56: A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
Question57: 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.
Question58: Which of the following commands cannot be used within a reader account?
Question59: Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Question60: What is a limitation of a Materialized View?
Question61: True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
Question62: Which formats are supported for unloading data from Snowflake?
Choose 2 answers
Question63: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
Question64: To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Question65: What type of query benefits the MOST from search optimization?
Question66: A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
Question67: Select the three types of tables that exist within Snowflake.
Choose 3 answers
Question68: Which interfaces can be used to create and/or manage Virtual Warehouses?
Question69: Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Question70: How are serverless features billed?
Question71: If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
Question72: Which statement best describes '' clustering''?
Question73: Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question74: Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
Question75: Which of the following statements is true of Snowflake?
Question76: What command is used to load files into an Internal Stage within Snowflake? Select one.
Question77: How often are the Account and Table master keys automatically rotated by Snowflake?
Question78: What are value types that a VARIANT column can store? (Select TWO)
Question79: When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
Question80: What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Question81: Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Question82: Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
Question83: True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
Question84: True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
Question85: Which statement describes pruning?
Question86: When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Question87: The fail-safe retention period is how many days?
Question88: True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
Question89: What privileges are required to execute a task?
Question90: In which use cases does Snowflake apply egress charges?
Question91: What is the maximum compressed row size in Snowflake?
Question92: When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
Question93: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
Question94: True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
Question95: What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Question96: A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Question97: Account-level storage usage can be monitored via:
Question98: A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
Question99: True or False: Data Providers can share data with only the Data Consumer.
Question100: To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Question101: How can a user change which columns are referenced in a view?
Question102: Which of the following describes a Snowflake stored procedure?
Question103: True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
Question104: User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
Question105: Which stage type can be altered and dropped?
Question106: Which command is used to unload data from a Snowflake table into a file in a stage?
Question107: How long is Snowpipe data load history retained?
Question108: Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Question109: Fail-safe is unavailable on which table types?
Question110: True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
Question111: Which of the following statements is true of data loading?
Select one.
Question112: What actions will prevent leveraging of the ResultSet cache? (Choose two.)
Question113: Which of the following describes how clustering keys work in Snowflake?
Question114: When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.
Question115: Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Question116: How would a user run a multi-cluster warehouse in maximized mode?
Question117: What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Question118: Which Snowflake technique can be used to improve the performance of a query?
Question119: When a pipe is recreated using the CREATE on REPLAC PIPE command:
Select one.
Question120: What is a best practice after creating a custom role?
Question121: Which of the following commands sets the Virtual Warehouse for a session?
Question122: Which of the following can be executed/called with Snowpipe?
Question123: True or False: Snowflake charges additional fees to Data providers for each share they create.
Question124: Which of the following roles is recommended to be used to create and manage users and roles?
Question125: Which statement describes how Snowflake supports reader accounts?
Question126: Which of the following is true of Snowpipe via REST API?
Choose 2 answers
Question127: Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question128: Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Question129: Which formats are supported for unloading data from Snowflake?
Choose 2 answers
Question130: The PUT command: (Choose two.)
Question131: Select the different types of Internal Stages: (Choose three.)
Question132: Which type of table corresponds to a single Snowflake session?
Question133: What can be used to view warehouse usage over time? (Select Two).
Question134: By default, which Snowflake role is required to create a share?
Question135: Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
Question136: How many resource monitors can be assigned at the account level?
Question137: Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.
Question138: True or False: Fail-safe can be disabled within a Snowflake account.
Question139: Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers
Question140: When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
Question141: When loading data into Snowflake, how should the data be organized?
Question142: True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
Question143: How many shares can be consumed by single Data Consumer?
Question144: During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Question145: Where can a user find and review the failed logins of a specific user for the past 30 days?
Question146: What data is stored in the Snowflake storage layer? (Select TWO).
Question147: True or False: A single database can exist in more than one Snowflake account.
Question148: Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)?
(Choose two.)
Question149: What tasks can be completed using the copy command? (Select TWO)
Question150: Select the three types of tables that exist within Snowflake.
Choose 3 answers
Question151: True or False: Snowpipe via RFST API can only reference External Stages as source.
Question152: What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
Question153: Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Question154: True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Question155: Snowflake is designed for which type of workloads? (Choose two.)
Question156: Which statement about billing applies to Snowflake credits?
Question157: A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Question158: Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Question159: True or False: You can query the files in an External Stage directly without having to load the data into a table.
Question160: Users are responsible for data storage costs until what occurs?
Question161: True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
Question162: When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)
Question163: Which interfaces can be used to create and/or manage Virtual Warehouses?
Question164: True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.
Question165: In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
Question166: Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Question167: When should a multi-cluster warehouse be used in auto-scaling mode?
Question168: A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?
Question169: True or False: The COPY command must specify a File Format in order to execute.
Question170: Which cache type is used to cache data output from SQL queries?
Question171: True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
Question172: Which of the following can be used when unloading data from Snowflake? (Choose two.)
Question173: What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.
Question174: Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
Question175: A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?
Question176: Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
Question177: Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Question178: How would a user execute a series of SQL statements using a task?
Question179: Which are true of Snowflake roles?
Question180: For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.
Question181: How many days is load history for Snowpipe retained?
Question182: 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.
Question183: Which of the following commands cannot be used within a reader account?
Question184: True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
Question185: Which statement best describes Snowflake tables?
Question186: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Question187: What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Question188: Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Question189: True or False: Snowflake charges additional fees to Data providers for each share they create.
Question190: What is the default File Format used in the COPY command if one is not specified?
Question191: How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?
Question192: Which of the following is the Snowflake Account_Usage.Metering_History view used for?
Question193: Which of the following is true of Snowpipe via REST API?
Choose 2 answers
Question194: True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
Question195: What features does Snowflake Time Travel enable?
Question196: Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
Question197: When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
Question198: Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
Question199: A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
Question200: How long is Snowpipe data load history retained?
Question201: Select the three types of tables that exist within Snowflake.
Choose 3 answers
Question202: What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Question203: Network policies can be applied to which of the following Snowflake objects? (Choose two.)
Question204: Which Snowflake technique can be used to improve the performance of a query?
Question205: True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
Question206: True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
Question207: Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
Question208: The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers
Question209: A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
Question210: A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
Question211: True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
Question212: Which of the following is true of Snowpipe via REST API? (Choose two.)
Question213: Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
Question214: True or False: All Snowflake table types include fail-safe storage.
Question215: What privileges are required to create a task?
Question216: What is a responsibility of Snowflake's virtual warehouses?
Question217: True or False: Pipes can be suspended and resumed.
Question218: Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
Question219: Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Question220: Which of the following are options when creating a Virtual Warehouse?
Question221: Which of the following objects is not covered by Time Travel?
Question222: True or False: Users are able to see the result sets of queries executed by other users that share their same role.
Question223: For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
Question224: Which formats are supported for unloading data from Snowflake?
Choose 2 answers
Question225: Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:
Question226: Using variables in Snowflake is denoted by using which SQL character?
Question227: If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:
Question228: True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
Question229: Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
Question230: How a Snowpipe charges calculated?
Question231: Which of the following are characteristics of security in Snowflake?
Question232: True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Question233: What is the default character set used when loading CSV files into Snowflake?
Question234: What is the most granular object that the Time Travel retention period can be defined on?
Select one.
Question235: True or False: A single database can exist in more than one Snowflake account.
Question236: How would you execute a series of SQL statements using Task?
Question237: Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Question238: A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?
Question239: Which of the following is a data tokenization integration partner?
Question240: Which statement best describes Snowflake tables?
Question241: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Question242: A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
Question243: Which of the following are options when creating a virtual Warehouse?
Choose 2 answers
Question244: What happens when a Data Provider revokes privileges to a Share on an object in their source database?
Question245: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
Question246: Which of the following statements is true of data loading?
Select one.
Question247: True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Question248: True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.