Download Snowflake Certification Exam Questions and Answers and more Exams Computer Science in PDF only on Docsity!
SnowPro 493 Certification ExamQuestions With Verified Correct Answers
Which one of the below requires an user-specified warehouse toexecute COPY statements
A) Bulk data load B) Snowpipe C) Both - ✔ ✔ A) Bulk data load When you remove the predecessor of a child task, what may happen tothe child task. Select two possibilities?
A) The child task is removed from the system B) The child task may become the root task C) The child task may become a stand-alone task -task may become the root task ✔ ✔ B) The child
C) The child task may become a stand-alone taskWhile loading data through the COPY command, you can transform the data. Which of the below transformations are allowed? A) TRUNCATECOLUMNS B) REORDER COLUMNS C) OMIT COLUMNS D) CAST E) AGGREGATE - ✔ ✔ A) TRUNCATECOLUMNS B) REORDER COLUMNS C) OMIT COLUMNS D) CAST
D) Fail-safe ensures historical data is protected in the event of a systemfailure or other catastrophic event, e.g. a hardware failure or security breach -during which historical data is recoverable by Snowflake ✔ ✔ B) Fail-safe provides a (non-configurable) 7-day period
D) Fail-safe ensures historical data is protected in the event of a systemfailure or other catastrophic event, e.g. a hardware failure or security breachWhen you load a table from a file through COPY command, the file should have the same number and order of columns as the table (TRUEOR FALSE) - ✔ ✔ FALSE Failsafe period for temporary and transient table is zero (TRUE ORFALSE) - ✔ ✔ TRUE When the snowflake staged release happens, which accounts get theupdates first
A) Enterprise or above B) Trial accounts C) Premier accounts
D) Accounts who has opted for early access -has opted for early access ✔ ✔ D) Accounts who After you have granted a share to a consumer, you added more objectsto the share. You have provided the required access by using the GRANT ... TO SHARE command.Please select the true statement
A) The added objects will be accessible to the consumers immediately B) You will need to recreate the share -will be accessible to the consumers immediately ✔ ✔ A) The added objects
Note: objects in the share flow in, but you cannot change access on theshare For federated authentication and MFA, what is the minimum snowflakeedition required?
A) Business critical B) Enterprise C) Premier
Which of the following is not a layer in SF's Architecture? Storage Cloud ServicesData Catalog Virtual Warehouses - ✔ ✔ Data Catalog Which of the following techniques can be in SF to improve queryperformance?
A. Index DefinitionB. Cluster Keys/Reclustering C. Distribution Keys D. Query Hints - ✔ ✔ B True or False: SF offers tools to extract data from source systems. - ✔ False ✔ Which of the following are options when creating a Virtual Warehouse? A. Auto-suspendB. Storage size C. Auto-resume
D. Server Count - ✔ ✔ A & C True or False: The warehouse cache may be reset if a runningwarehouse is suspended and then resumed. - ✔ ✔ A Which of the following best describes SF's processing engine? Leverages Apache Spark Based on Map ReduceA derivative of Presto Native SQL - ✔ ✔ Native SQL Which role in Snowflake allows a user to administer users and manageall database objects?
SYSADMIN SECURITYADMINACCOUNTADMIN ROOT - ✔ ✔ ACCOUNTADMIN Which transformations are available when using the COPY INTOcommand to load data files into Snowflake from a stage?
FiltersAggregates
D. Snowflake can run within a customer's VPC - ✔ ✔ A & C True or False: Snowflake caches are automatically invalidated if theunderlying data changes. - ✔ ✔ True True or False: The query profiler view is only available for completedqueries. - ✔ ✔ False Which of the following are true about the variant data type inSnowflake?
A. Optimized storage based on repeated elements B. Stored in a separate file format from structured dataC. Can be queried using JSON path notation D. Requires a customer mapping for each record type - ✔ ✔ A & C True or False: Snowflake only works with cloud based tools. - False ✔ ✔ Which of the following are true of Multi-Cluster warehouses? A. Adds clusters automatically based on query activityB. Sizes each cluster optimally based on the queries C. Scales down when query activity slows down D. Multi-cluster warehouses will never auto-suspend - ✔ ✔ A & C
What is the maximum number of consumer accounts that can be addedto a Share object?
A. OneB. Unlimited C. 10 D. 100 - ✔ ✔ B What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
A. Indexing B. PruningC. Map Reduce D. B-True - ✔ ✔ B What is the recommended approach for making a variant columnaccessible in a BI tool?
A. A pre-defined mappingB. A View C. Leveraging a JSON parser D. There is no way to do this - ✔ ✔ B
A. Columnar shared nothing B. Shared diskC. Multi-cluster shared data D. Cloud native shared memory - ✔ ✔ C SF is available on premise? (TRUE OR FALSE) - ✔ ✔ False Note: Snowflake's data warehouse is a true SaaS offering. Morespecifically: There is no hardware (virtual or physical) for you to select, install,configure, or manage. There is no software for you to install, configure, or manage. Ongoing maintenance, management, and tuning is handled bySnowflake. Snowflake runs completely on cloud infrastructure. All components ofSnowflake's service (other than an optional command line client), run in a public cloud infrastructure.Snowflake uses virtual compute instances for its compute needs and a storage service for persistent storage of data. Snowflake cannot be runon private cloud infrastructures (on-premises or hosted). Snowflake is not a packaged software offering that can be installed by auser. Snowflake manages all aspects of software installation and updates. https://docs.snowflake.com/en/user-guide/intro-key-concepts.htmlPick the true statement for snowflake architecture
A) Shared nothing architecture B) Shared disk architecture C) Multi-Cluster Shared Data architecture -Shared Data architecture ✔ ✔ C) Multi-Cluster
Note: nowflake's architecture is a hybrid of traditional shared-diskdatabase architectures and shared-nothing database architectures. Similar to shared-disk architectures, Snowflake uses a central datarepository for persisted data that is accessible from all compute nodes in the data warehouse. But similar to shared-nothing architectures,Snowflake processes queries using MPP (massively parallel processing) compute clusters where each node in the cluster stores a portion of theentire data set locally. This approach offers the data management simplicity of a shared-disk architecture, but with the performance andscale-out benefits of a shared-nothing architecture. https://docs.snowflake.com/en/user-guide/intro-key-concepts.htmlThe three key layers of snowflake are
A) Extraction, Ingestion, Load
B) Snowflake processes queries running spark on a EC2 instance C) Snowflake process queries using 'Virtual Warehouses' -Snowflake process queries using 'Virtual Warehouses' ✔ ✔ C) Which of the below services are provided by cloud services A) Metadata management B) Authentication C) Infrastructure management D) Query execution - ✔ ✔ A) Metadata management B) AuthenticationC) Infrastructure management How will you store JSON data in snowflake A) Using a column with datatype as JSON
B) Using a column with datatype as VARCHAR C) Using a column with datatype as VARIANT -column with datatype as VARIANT ✔ ✔ C) Using a You have two data warehouses in your snowflake instance. You haveupdated the data in the storage layer using one of the warehouses. When will the other warehouse be able to see the data A) Immediately B) After 30 minutes once snowflake completes data synchronization C) You will need to trigger the data synchronization process for theother warehouse to see the data - ✔ ✔ A) Immediately Zero-copy cloning in snowflake is powered by which service? A) Metadata store of the service layer B) SSD cache of Virtual warehouse C) Query result cache - ✔ ✔ A) Metadata store of the service layer
A) The third party product's webpage and contact them throughcontact us
B) Call snowflake support to enable the product C) Enable the product through Partner Connect in Snowflake webconsole - ✔ ✔ C) Enable the product through Partner Connect in Snowflake web consoleCompute in snowflake is provided by
A) The cloud providers VM instances B) Only EC2 instances on AWS C) Virtual warehouses - ✔ ✔ C) Virtual warehouses Once you have selected a warehouse size, you cannot resize the size ofthe warehouse (TRUE OR FALSE) - ✔ ✔ FALSE What is the easiest way to monitor the queries that are run onsnowflake?
A) Create a tableau dashboard and connect to snowflake
B) All queries go to cloudwatch and use cloudwatch to monitor C) Click on the the History tab and monitor all queries that are executedin the last 14 days - ✔ ✔ C) Click on the the History tab and monitor all queries that are executed in the last 14 daysYou are a snowflake architect hired by an organization. They want you to design their warehouse strategy. Which one of the strategy will youpick up.
A) Both loading and analysis of data will be done by a single warehouseto reduce cost
B) You do not need to use warehouse for loading data, only queryanalysis will require a warehouse
C) You will recommend to use a multi-warehouse strategy. The loadworkload will be done by one ware house and the query analysis workload will be done by another warehouse -recommend to use a multi-warehouse strategy. The load workload will ✔ ✔ C) You will be done by one ware house and the query analysis workload will bedone by another warehouse
