What are computer language considerations when using Snowflake interfaces? (Select TWO).
Answer(s): A,C
Snowflake Notebooks support both SQL and Python as executable cell types. This means that users can create notebook cells written in Python for programmatic data processing and modeling, and in SQL for declarative querying and transformation. Because of this, the statements "Notebook cells can be written in Python" and "Notebook cells can be written in SQL" are both correct.Snowflake databases do not natively execute queries written in Scala; Scala is supported via Snowpark APIs for application code, not as a direct query language. Worksheets in Snowsight are primarily SQL-based and also support procedural constructs (e.g., Snowflake Scripting), so the phrase "only in SQL" is not a precise or complete characterization. Dashboards in Snowsight are created using SQL-backed visualizations and built-in UI components; JavaScript is not a supported authoring language inside the native dashboarding layer. Therefore, options B, D, and E are not correct in this context.
What Snowflake object is used to store data?
Answer(s): A
A table is the core Snowflake object used to store structured data. Tables persist rows and columns in Snowflake's storage layer, which internally uses compressed, columnar micro-partitions managed by the platform. Tables can be permanent, transient, or temporary, but in every case, they are the primary objects that hold the actual data.A virtual warehouse is a compute resource used to process queries and perform operations; it does not store user data. A stored procedure contains executable logic (such as complex workflows or procedural code) but does not serve as a data container. A view is a logical object that presents the results of a saved query; it references underlying tables and does not store its own data. As a result, "Table" is the correct answer.
Where is unstructured data stored in Snowflake?
Answer(s): B
Unstructured data such as PDF files, images, and other binary documents is stored in stages in Snowflake. These stages may be internal stages, which Snowflake manages directly, or external stages, which reference external cloud storage such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. Stages are the designed mechanism for storing and accessing unstructured files so that they can be processed with functions like PARSE_DOCUMENT or accessed via directory tables.External tables are used to query structured or semi-structured data (for example, Parquet or JSON) stored in external locations, not to store raw unstructured binary content. The Cloud Services layer coordinates metadata, security, and query services; it does not store user data. Tables with a single VARCHAR column might be used as an improvised approach for small text blobs, but this is not the native or recommended method for managing unstructured data at scale.
What is the name of Snowflake's default web-based interface?
Answer(s): C
Snowsight is the default web-based interface for Snowflake. It provides a graphical, browser-based environment to write and run SQL and Python, manage and explore database objects, create visualizations and dashboards, monitor query and warehouse activity, and collaborate via worksheets. It has replaced the Classic Console as the default UI for new Snowflake accounts.SnowSQL is a command-line client used to connect to Snowflake from a terminal and execute SQL statements. Snowpark is a developer framework that supports writing data applications in languages like Python, Java, and Scala, but it is not a UI. "Snowflake CLI" refers to command-line tooling and automation utilities, again not a graphical web interface.
What task can be performed on the Snowsight Schema Details page?
On the Snowsight Schema Details page, one of the supported operations is renaming the schema. The UI exposes controls that allow users with appropriate privileges to change the schema name, which can help maintain consistent naming conventions or reflect project reorganizations.Sharing data with other accounts is typically done using secure shares at the database or object level, not from a simple "Share this schema" function on the Schema Details page. Truncation is a table- level operation (e.g., TRUNCATE TABLE), not something that applies at the schema level. Metrics visible on the Schema Details page (such as object counts or storage usage) are informational and not directly editable; they are derived from system metadata.
What is the impact of enabling auto-suspend on a Snowflake virtual warehouse?
When auto-suspend is enabled on a virtual warehouse, Snowflake automatically suspends (stops) the warehouse after it has been idle for the configured period of time. Once suspended, the warehouse stops consuming compute credits, thereby reducing costs, since Snowflake bills only for active compute usage. When new queries arrive, auto-resume (if enabled) restarts the warehouse automatically.Auto-suspend does not change the warehouse size; scaling up or down is a separate configuration. The warehouse is not dropped--its metadata and settings remain intact. Costs may be reduced and made more efficient but are not guaranteed to "stabilize month-to-month," as the bill still depends on actual usage and workload patterns.
What parameter is used to define how long Time Travel can be used to access a table?
The DATA_RETENTION_TIME_IN_DAYS parameter controls the Time Travel retention period for Snowflake objects such as tables, schemas, and databases. It specifies the number of days that historical data (prior versions of rows or dropped objects) is retained and accessible via Time Travel. Within this retention window, users can query data "as of" a previous time, restore dropped objects, or clone objects at a historical point.DATE_OUTPUT_FORMAT determines the display format for date values and is unrelated to historical retention. TIMEZONE affects how timestamps are interpreted and displayed, not how long data history is preserved. USE_CACHED_RESULT governs whether Snowflake may return cached query results, not Time Travel behavior.
What filter can be used when searching for data products on the Snowflake Marketplace?
On the Snowflake Marketplace, users can apply a Price filter when searching for data products. This filter helps distinguish between free offerings and paid listings, making it easier to align data acquisition with budget and commercial terms. Marketplace metadata includes pricing information that this filter uses to refine search results.Dataset "Size" is not exposed as a primary Marketplace search filter. "Compatibility" is implied, as all Marketplace products are consumable within Snowflake. "Performance" is not a filterable attribute, because performance is influenced mainly by the consumer's compute configuration and query design, rather than a fixed property of the Marketplace listing.
Share your comments for Snowflake SnowPro Associate Platform SOL-C01 exam with other users:
pd1 with great experience
@t it seems like azure service bus message quesues could be the best solution
helpful to check your understanding.
question 128 the answer should be static not auto
more comments here
great support to appear for exams
useful dumps
making progress
q31 answer should be d i think
is this real?
q10: c and f are also true. q11: this is outdated. you no longer need ownership on a pipe to operate it
good questions with simple explanation
admin guide (windows) respond to malicious causality chains. when the cortex xdr agent identifies a remote network connection that attempts to perform malicious activity—such as encrypting endpoint files—the agent can automatically block the ip address to close all existing communication and block new connections from this ip address to the endpoint. when cortex xdrblocks an ip address per endpoint, that address remains blocked throughout all agent profiles and policies, including any host-firewall policy rules. you can view the list of all blocked ip addresses per endpoint from the action center, as well as unblock them to re-enable communication as appropriate. this module is supported with cortex xdr agent 7.3.0 and later. select the action mode to take when the cortex xdr agent detects remote malicious causality chains: enabled (default)—terminate connection and block ip address of the remote connection. disabled—do not block remote ip addresses. to allow specific and known s
very inciting
question 5, it seems a instead of d, because: - care plan = case - patient = person account - product = product2;
it look like real one
i am taking oracle fcc certification test next two days, pls share question dumps
i need dumps
its time to comptia sec+
question 35 has an answer for a different question. i believe the answer is "a" because it shut off the firewall. "0" in registry data means that its false (aka off).
helpful content
oracle 19c is complex db
helpful for practice
support team is fast and deeply knowledgeable. i appreciate that a lot.
helpful questions
thanks for question
the software is provided for free so this is a big change. all other sites are charging for that. also that fucking examtopic site that says free is not free at all. you are hit with a pay-wall.
i need exam questions nca 6.5 any help please ?
just took the comptia cybersecurity analyst (cysa+) - wished id seeing this before my exam
very helpful
i need this exam
nice questions... are these questions the same of the exam?
need to view
highly appreciate for your sharing.