Download Snowflake Exam Study Set Exam Questions & Correct Complete Answers|2025/2026 Edition and more Exams Computer Science in PDF only on Docsity!
Snowflake Exam Study Set Exam
Which of the following are Snowflake view types? (Select 3) - ✔ ✔ Secure; Standard; Materialized What are the three Snowflake Stage types? (Select 3) - ✔ ✔ User; Table; Named Named stages come in two varieties, what are they? - ✔ ✔ Internal; External Which type of view is most like a table? - ✔ ✔ Materialized Which type of view has an extra layer of protection to hide the SQL code from unauthorized viewing? - ✔ ✔ Secure In a Snowflake account named MX43210, you need to set a user's default namespace to a database called MYDB and the PUBLIC schema. Which of the following commands would you use? - ✔ ✔ set default_namespace = mydb.public Select all statements that are true about the Snowflake container hierarchy: - ✔ ✔ Accounts contain databases which contain schemas; Schemas contain tables as well as views
In the Snowflake container hierarchy, what container is represented as a URL (for example: https://HJ54364.snowflakecomputing.com)? - ✔ ✔ Account Fail-Safe is a seven-day history of data and is automatically available on which table types? - ✔ ✔ Permanent Which part of the URL is the region? https://TH77881.us-east- 1.azure.snowflakecomputing.com - ✔ ✔ us-east- Each Snowflake account comes with two shared databases. One is a set of sample data and the other contains Account Usage information. Check all true statements about these shared databases. - ✔ ✔ SNOWFLAKE contains a schema called ACCOUNT_USAGE; SNOWFLAKE_SAMPLE_DATA contains several schemas from TPC (tpc.org); ACCOUNT USAGE is a schema filled with secure views Check all true statements about Fail-safe: - ✔ ✔ Only a Snowflake employee can recover data from fail-safe storage; The data stored as part of fail-safe is part of storage costs charged to customers Time travel is available for which table types? (Select 3) - ✔ ✔ Permanent; Temporary; Transient
Using the History area of the WebUI, how far back in time is query history available? - ✔ ✔ 14 days The columns in the query history include the QueryID, the SQL Text, the Warehouse name, the Warehouse Size, the Session ID and others. Which column is a good indicator of whether a Warehouse was used (and Compute costs incurred) by a query? - ✔ ✔ Size FDNEIGE is running queries using SYSADMIN and ACCOUNTADMIN roles. User ALICE is using the PUBLIC Role. Mark all true statements. - ✔ ✔ FDNEIGE can see all of ALICE's queries; ALICE can see all of FDNEIGE's queries A query you initiated is taking too long. You've gone into the History area to check whether this query (which usually runs every hour) is supposed to take a long time. Check all true statements. - ✔ ✔ Information in the History area can be filtered to show a single Warehouse; Information in the History area can be filtered to show a single User; Information in the History area can be filtered to show a single Session; Information in the History area can help you visually compare query times An hour ago, you ran a complex query. You then ran several simple queries from the same worksheet. You want to export the results from the complex query but they are no longer loaded in the Results pane of the worksheet. What is the least costly way to download the results? - ✔ ✔ Click on History -> Locate the Query -> Click the QueryID -> Use the "Export Result" button
You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is very stable, only changing once or twice per day. The query run by the dashboard connector user never changes. How will Snowflake manage changing and non-changing data? Mark all true statements. - ✔ ✔ Snowflake will show the most up-to-date data each time the dashboard is refreshed; Snowflake will spin up a warehouse only if the underlying data has changed; Snowflake will re-use data from the Results Cache as long as it is still the most up-to-date data available When running a SELECT COUNT(*) on a table, which of the following statements is true? - ✔ ✔ No Warehouse will be needed because Count statistics are stored in the Metadata Cache You create a new worksheet in the WebUI. You want to set the user role, warehouse, database, and schema context that will be used when running the SQL code. Which of the options listed here are valid? - ✔ ✔ Run four "USE" commands, setting each context with a separate statement; Use the Context drop menu in the upper right corner of the worksheet Which of these statements is a valid script-based way to set context in a Worksheet? (select all that apply) - ✔ ✔ USE database MY_DATABASE; USE schema MY_SCHEMA;
Which method for viewing query history provides more parameters/fields/attributes? - ✔ ✔ The QUERY_HISTORY secure view available from the Account Usage Share Which cache type gets purged in a predictable way so that it ends up empty of all cached information? - ✔ ✔ Warehouse Cache Which cache type runs on a 24 hour "clock"? - ✔ ✔ Results Cache Which cache stores object definitions and statistics? - ✔ ✔ Metadata Cache Which of the following could be considered synonymous with the term "Warehouse Cache"? (Choose 3) - ✔ ✔ Raw Data Cache; SSD Cache; Data Cache User A and User B can access one another's result sets from the Results Cache, as long as which of the following are true? (Choose two) - ✔ ✔ They run the exact same SQL Text/Query; They use the same Role There are four data locations covered in the caching video. Three are caches and the other is long-term centralized storage. Which of the four locations require a running warehouse when retrieving data from them? - ✔ ✔ Warehouse Cache; Centralized Storage What action causes a Warehouse's cache to be purged? - ✔ ✔ Suspending the warehouse
You are viewing the Query History table in the History area of the WebUI. You want to see if a query pulled data from long-term centralized storage. Where will you look and what will you look for? - ✔ ✔ Look in the Bytes Scanned column for a green bar Snowflake's Data Marketplace has three roles. One is Administrator, what are the other two? - ✔ ✔ Consumer & Provider During the video, Lottie is seen using two browser tabs, and both are open to a different Snowflake user interface(UI). What are these two UI's called? - ✔ ✔ Classic Console; AppUI You are browsing listings in Snowflake's Data Marketplace and you find a Standard listing you like. You want to click on the Get Data button but it is grayed-out. As seen in the video, what do you need to do to get the button to turn blue so you can click it? - ✔ ✔ Set your user role to ACCOUNTADMIN You are browsing Snowflake's Data Marketplace and you see a Personalized listing you like. You look for the Get Data button but see a Request button instead. Why do Personalized listings have Request buttons? - ✔ ✔ Personalized Shares require you to submit a Request in writing and work with the Provider What are some criteria required of a data set for it to qualify for listing on Marketplace? - ✔ ✔ Complies with Privacy and Other Laws; Fresh and Not Static; Legally "Ours" to Distribute;
Which of the following is the correct syntax for the REPLACE FUNCTION? - ✔ ✔ REPLACE(,[,]) What can be typed in front of a line of text in the SQL pane to make it into a comment or note rather than have it treated as code?(Check all that apply.) - ✔ ✔ A double slash: //; A double dash: -- Which of the following options would result in a column named MY_VALUE being sandwiched between two percent signs? (Check all that apply) - ✔ ✔ '%'||MY_VALUE||'%'; CONCAT('%',CONCAT(MY_VALUE,'%')) Match a SQL word or phrase with the labels EXTRACT, TRANSFORM, or LOAD. These relationships were highlighted using comments in a script you loaded as part of a lab. - ✔ ✔ EXTRACT --> FROM; TRANSFORM --> REPLACE; LOAD --> INSERT INTO Match the real-world warehouse term with the corresponding Snowflake terms. - ✔ ✔ Workers --> Servers; Goods --> Data; (does not apply) --> REST API Not all Snowflake Editions have Elastic Data Warehousing. Check all the Snowflake editions that have Elastic Data Warehousing enabled. - ✔ ✔ Enterprise Edition; Business Critical Edition (formerly Enterprise for Sensitive Data);
Virtual Private Snowflake The following statements have to do with warehousing metaphors. Check all true statements. - ✔ ✔ Real-world warehouses have goods and workers; Traditional data warehouses have data and servers; Goods = Data = Storage; Workers = Servers = Compute Power The following statements have to do with the scaling of the warehouses. Check all true statements. - ✔ ✔ Scaling a warehouse DOWN will decrease the number of servers. (e.g. Medium to Small); Scaling a warehouse OUT will increase the number of clusters. (e.g. Min to Max); Scaling a warehouse OUT will increase the number of servers. (e.g. Min to Max); Scaling a warehouse IN will decrease the number of clusters. (e.g. snapping back) Contrast Snowflake Warehouses from traditional data marts. Choose all correct statements. - ✔ ✔ Both Data Marts and Snowflake Warehouses can be assigned to a business' departments for their specific needs; Snowflake Warehouses have access to all of a company's data at all times; Data Marts can improve efficiency but can lead to inaccuracies due to replication
True or False: FTP Stages require three cloud storage providers - ✔ ✔ False True or False: Cloud storage providers must be linked to internal stage objects - ✔ ✔ False External Stages require customers to have an account with a cloud storage service provider. Which of the following are available currently or have been announced by Snowflake as under development? - ✔ ✔ AWS S3; MS Azure Blob; GCP Buckets To configure an External Stage you need to define the stage object in Snowflake. You also need two additional components. What are they? - ✔ ✔ Cloud storage location (e.g. S3 Bucket); Cloud access credentials (e.g. IAM User and Policy) Match the logical data concepts to their data storage counterparts. - ✔ ✔ Entity --> Table; Attribute --> Column Heading; Value --> Row Contents What is the column datatype used for ingesting semi-structured data? - ✔ ✔ VARIANT What data structure types can be ingested into a VARIANT column in a Snowflake table? (Check all that apply) - ✔ ✔ ORC; PARQUET; JSON;
XML;
AVRO
SQL Statements fall into several categories, including DDL and DML. What does DDL stand for? - ✔ ✔ Data Definition Language SQL Statements fall into several categories, including DDL and DML. What does DML stand for? - ✔ ✔ Data Manipulation Language Which of the following SQL keywords are DDL commands? - ✔ ✔ CREATE; ALTER; DROP Which of the following SQL keywords are DML commands? - ✔ ✔ SELECT; INSERT; UPDATE We loaded an XML file that included a header entity called . In order to bypass this entity and treat each AUTHOR object as a separate record (loading each into a separate row), what FILE_FORMAT property did we change? - ✔ ✔ STRIP OUTER ELEMENT Many logical data models refer to entities, attributes, and values. In JSON, and some other semi-structured types, the word "attributes" is often replaced with what word? - ✔ ✔ KEYS A CAST command (symbol) will force a value to be output as a certain datatype. Which of the following code samples will result in the
True or False: The database appearing as "SNOWFLAKE" is often called the "Billing Share." - ✔ ✔ False True or False: Databases based on most inbound shares can be dropped
- ✔ ✔ True True or False: Databases based on most inbound shares can be renamed - ✔ ✔ True What operations are allowed on databases like SNOWFLAKE_SAMPLE_DATA (inbound share data)? - ✔ ✔ SELECT with JOIN; SELECT with GROUP BY You want to create a view based on the SNOWFLAKE_SAMPLE_DATA share. How can this be done? - ✔ ✔ Use fully-qualified table names in the SELECT statement; Save the view in a regular database, not in the SAMPLE share Which of the following are NOT possible for SHARED data? - ✔ ✔ Run an UPDATE statement on the data; Add the data to your OUTBOUND SHARE; Create a table in the INBOUND SHARE's database What command (partial) is used to convert a SECURE VIEW to a "regular" VIEW? - ✔ ✔ UNSET SECURE True or False: You cannot share a share - ✔ ✔ True When Osiris created an outbound share, he was able to stop doing some tasks related to sharing data with Lottie. Check all the tasks Osiris
will no longer have to carry out. - ✔ ✔ Run an extract on INTL_DB to place data in a flat file; Move his flat file to an FTP directory When adding Consumers to Outbound Shares, what types of Consumer Accounts can be selected? - ✔ ✔ Full; Reader Why was a database called WDE_INTL created in the Reader Account? - ✔ ✔ It makes the share into a usable data source Shares take place between which two groups? - ✔ ✔ Providers & Consumers Data Consumers can be set up to consume data using which two types of consuming accounts? - ✔ ✔ Full Accounts & Reader Accounts When Osiris set up a Reader Account for Lottie, before Lottie was a Snowflake Customer, which of the following were true? - ✔ ✔ Osiris as billed by Snowflake based on the compute resources used by Lottie; Lottie's queries could be limited by Osiris using a Resource Monitor For Snowflake customers who might create a Reader Account for their partners, what are some considerations? - ✔ ✔ Reader Accounts can help Snowflake Customers distribute their data to non-customers; Reader Accounts require more set-up steps than sharing with Full Accounts; The compute used by Reader Accounts can be limited by the Sharing Provider; The compute used by Reader Accounts is billed to the Sharing Provider
Which of the following terms are associated with the Cloud Services Layer? (Select 3) - ✔ ✔ Query Planning; Query Optimization; Query Compilation Which of the following are performed by the Cloud Services layer? (Select 4) - ✔ ✔ Metadata Management; User Authentication; Metadata Storage; Data Security Three of these terms refer to the same layer. Select the correct 3. - ✔ ✔ Compute Layer; Virtual Warehouse Layer; Query Processing Layer Two of these terms refer to the same layer. Select the correct 2. - ✔ ✔ Cloud Services Layer; Services Layer Two of these terms refer to the same layer. Select the correct 2. - ✔ ✔ Data Layer; Storage Layer True or False: Storage can increase or decrease without any effect on virtual warehouse size - ✔ ✔ True
True or False: Virtual Warehouses have no effect on compute costs - ✔ ✔ False True or False: Compute can be scaled up, down, out, or in and there is no effect on storage used - ✔ ✔ True True or False: Cloud services can be increased to multiple regions without any user intervention - ✔ ✔ False True or False: Two Virtual Warehouses can access the same data at the same time without causing contention issues - ✔ ✔ True What attributes make Snowflake a true SaaS solution? (Select 3) - ✔ ✔ No hardware to purchase or configure; No maintenance upgrades or patches to install; Transparent releases don't require user intervention Which installment option versions of Snowflake are available? (Select 2)
- ✔ ✔ Snowflake-Hosted Accounts (on Amazon cloud infrastructure); Snowflake-Hosted Accounts (on Azure cloud infrastructure) Which of the following terms describes Snowflake's Architecture? - ✔ ✔ Shared Data Which of the following terms or phrases can also be used to describe Snowflake? (Select 4) - ✔ ✔ Native SQL; Hybrid Columnar; Built from the ground up for the cloud;
