Mock Exam for Snowflakes || with Complete Solutions Udemy Snowpro Core Certification - Practice Questions Test 3 || All Correct 100% SnowPro Core Exam Study Guide- Questions and Answers. SnowPro Certification || with Complete Solutions SnowPro Certification Study Guide Part 1 || with 100% Error-fre...
[Show more]
Lateral and Table correct answers The Flatten command will parse nested objects into separated rows. One version of the flatten command uses a join and other uses an object keyword. Select the two words that represent the option used with the flatten command. Flatten correct answers a table funct...
Preview 1 out of 4 pages
Add to cartLateral and Table correct answers The Flatten command will parse nested objects into separated rows. One version of the flatten command uses a join and other uses an object keyword. Select the two words that represent the option used with the flatten command. Flatten correct answers a table funct...
What object do you need to create to fetch data from private cloud locations? A. Storage Integration B. Only Stage C. Nothing, just pass source URL to a query D. Storage Connection correct answers A. Storage Integration What parameter should be changed to modify table retention time? A....
Preview 4 out of 84 pages
Add to cartWhat object do you need to create to fetch data from private cloud locations? A. Storage Integration B. Only Stage C. Nothing, just pass source URL to a query D. Storage Connection correct answers A. Storage Integration What parameter should be changed to modify table retention time? A....
Cloud services layer correct answers Brain layer. Manages everything Query planning, optimization, compilation What is performed by the cloud services layer? correct answers Metadata management, storage Data security User authentication Compute layer correct answers Processing layer, virtua...
Preview 3 out of 27 pages
Add to cartCloud services layer correct answers Brain layer. Manages everything Query planning, optimization, compilation What is performed by the cloud services layer? correct answers Metadata management, storage Data security User authentication Compute layer correct answers Processing layer, virtua...
True or False: Data Storage is independent from compute? correct answers True True or False: All virtual warehouses have access to all data? correct answers True True or False: Al interactions with data are initialized through the services layer? correct answers True True or False: Multi-Cl...
Preview 3 out of 25 pages
Add to cartTrue or False: Data Storage is independent from compute? correct answers True True or False: All virtual warehouses have access to all data? correct answers True True or False: Al interactions with data are initialized through the services layer? correct answers True True or False: Multi-Cl...
What is Snowflake? (key features) correct answers Analytic data warehouse SaaS offering - No hardware/installation/patching - No ongoing maintenance/tuning - Can't run privately (on-prem/hosted) Runs completely in the Cloud (AWS, Azure, GCP) - Has its own VPC Decoupled compute and stor...
Preview 2 out of 15 pages
Add to cartWhat is Snowflake? (key features) correct answers Analytic data warehouse SaaS offering - No hardware/installation/patching - No ongoing maintenance/tuning - Can't run privately (on-prem/hosted) Runs completely in the Cloud (AWS, Azure, GCP) - Has its own VPC Decoupled compute and stor...
Which of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse correct answers A. Compress ...
Preview 3 out of 16 pages
Add to cartWhich of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse correct answers A. Compress ...
Which of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend correct an...
Preview 3 out of 19 pages
Add to cartWhich of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend correct an...
True or False: Data Storage is independent from compute? correct answers True True or False: All virtual warehouses have access to all data? correct answers True True or False: Al interactions with data are initialized through the services layer? correct answers True True or False: Multi-Cl...
Preview 3 out of 25 pages
Add to cartTrue or False: Data Storage is independent from compute? correct answers True True or False: All virtual warehouses have access to all data? correct answers True True or False: Al interactions with data are initialized through the services layer? correct answers True True or False: Multi-Cl...
True or false: A table in Snowflake can contain both a variant columns and a timestamp. correct answers True True or false: The warehouse cache may be reset if a running warehouse is suspended and then resumed. correct answers True Which of the following are true of Multi-Cluster warehouses? S...
Preview 3 out of 17 pages
Add to cartTrue or false: A table in Snowflake can contain both a variant columns and a timestamp. correct answers True True or false: The warehouse cache may be reset if a running warehouse is suspended and then resumed. correct answers True Which of the following are true of Multi-Cluster warehouses? S...
What are the 3 Cloud Providers available for Snowflake correct answers 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) correct answers Tr...
Preview 2 out of 12 pages
Add to cartWhat are the 3 Cloud Providers available for Snowflake correct answers 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) correct answers Tr...
You own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... A) Grant USAGE on D1 B) Grant SELECT on D1 C) Grant USAGE on S1 D) Grant SELECT on S1 E) Grant USAGE on T1 F) Grant SELECT on T1 c...
Preview 2 out of 13 pages
Add to cartYou own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... A) Grant USAGE on D1 B) Grant SELECT on D1 C) Grant USAGE on S1 D) Grant SELECT on S1 E) Grant USAGE on T1 F) Grant SELECT on T1 c...
True or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. correct answers True True or False? Are Snowpipe charges calculated per second and per core? correct answers True What types of views are available in Snowflake? correct answers Regular...
Preview 2 out of 8 pages
Add to cartTrue or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. correct answers True True or False? Are Snowpipe charges calculated per second and per core? correct answers True What types of views are available in Snowflake? correct answers Regular...
Which file format option would you use when you want to load a JSON file after removing the outer array structure and load the records into separate table rows?: STRIP_OUTER_ARRAY DROP_OUTER_ARRAY UNSET_OUTER_ARRAY TRUNCATE_OUTER_ARRAY correct answers STRIP_OUTER_ARRAY (Correct) In gener...
Preview 2 out of 5 pages
Add to cartWhich file format option would you use when you want to load a JSON file after removing the outer array structure and load the records into separate table rows?: STRIP_OUTER_ARRAY DROP_OUTER_ARRAY UNSET_OUTER_ARRAY TRUNCATE_OUTER_ARRAY correct answers STRIP_OUTER_ARRAY (Correct) In gener...
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is: A. Micro-partitions B. Clustering keys Most Voted C. Key partitions D. Clustered partitions correct answers Clustering Keys Which of the following are valid Snowflake Virtual Wareho...
Preview 4 out of 65 pages
Add to cartSnowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is: A. Micro-partitions B. Clustering keys Most Voted C. Key partitions D. Clustered partitions correct answers Clustering Keys Which of the following are valid Snowflake Virtual Wareho...
Multi-cluster shared data correct answers Which of the following terms best describes Snowflake's database architecture? Pruning correct answers What technique does Snowflake use to limit the number of micro-partitions scanned by each query? All data in Snowflake is encrypted correct answers ...
Preview 2 out of 13 pages
Add to cartMulti-cluster shared data correct answers Which of the following terms best describes Snowflake's database architecture? Pruning correct answers What technique does Snowflake use to limit the number of micro-partitions scanned by each query? All data in Snowflake is encrypted correct answers ...
True or False: Network policies for granting or restricting users access to the site based on their IP address (i.e. IP whitelisting). correct answers True True or False: Snowflake does NOT provide Verification/authentication required for any users accessing your account (includes support for MFA...
Preview 1 out of 4 pages
Add to cartTrue or False: Network policies for granting or restricting users access to the site based on their IP address (i.e. IP whitelisting). correct answers True True or False: Snowflake does NOT provide Verification/authentication required for any users accessing your account (includes support for MFA...
Every Week correct answers Snowflake deploy new release at what frequency? Cluster the Transactions table on the transaction data column. The daily report will only access one day at a time and therefore will only scan required data correct answers You are the data modeler at a large retail organ...
Preview 3 out of 24 pages
Add to cartEvery Week correct answers Snowflake deploy new release at what frequency? Cluster the Transactions table on the transaction data column. The daily report will only access one day at a time and therefore will only scan required data correct answers You are the data modeler at a large retail organ...
What is the best way to store semi-structured data? correct answers Data should be loaded and stored in a VARIANT type column What is the best practice for handling semi-structured data with 3rd party BI tools? correct answers Create a Snowflake view that parse the semi-structured column into str...
Preview 4 out of 134 pages
Add to cartWhat is the best way to store semi-structured data? correct answers Data should be loaded and stored in a VARIANT type column What is the best practice for handling semi-structured data with 3rd party BI tools? correct answers Create a Snowflake view that parse the semi-structured column into str...
what does the INFORMATION_SCHEMA hold correct answers a collection of views -holds metadata and other statistics about the database, schema, table, views, etc. T/F the INFORMATION_SCHEMA cannot be deleted, renamed or moved correct answers True T/F the PUBLIC schema is created empty correct an...
Preview 2 out of 13 pages
Add to cartwhat does the INFORMATION_SCHEMA hold correct answers a collection of views -holds metadata and other statistics about the database, schema, table, views, etc. T/F the INFORMATION_SCHEMA cannot be deleted, renamed or moved correct answers True T/F the PUBLIC schema is created empty correct an...
Database Storage(Layer 3) correct answers Responsible - Data loaded into snowflake is reorganized into internal optimized/compressed/columnar format - Data objects stored by Snowflake are not directly visible nor accessible by customers - Manages all aspects of data(size,compression etc) Query...
Preview 2 out of 6 pages
Add to cartDatabase Storage(Layer 3) correct answers Responsible - Data loaded into snowflake is reorganized into internal optimized/compressed/columnar format - Data objects stored by Snowflake are not directly visible nor accessible by customers - Manages all aspects of data(size,compression etc) Query...
What is the best way to store semi-structured data? correct answers Data should be loaded and stored in a VARIANT type column What is the best practice for handling semi-structured data with 3rd party BI tools? correct answers Create a Snowflake view that parse the semi-structured column into str...
Preview 4 out of 129 pages
Add to cartWhat is the best way to store semi-structured data? correct answers Data should be loaded and stored in a VARIANT type column What is the best practice for handling semi-structured data with 3rd party BI tools? correct answers Create a Snowflake view that parse the semi-structured column into str...
Which groups of SQL statements will run successfully in the Web UI? (Choose 2) -CREATE INDEX and DROP INDEX -CREATE USER, ALTER USER and DROP USER -CREATE TABLESPACE, ALTER TABLESPACE and DROP TABLESPACE -CREATE LOGFILE GROUP, ALTER LOGFILE GROUP and DROP LOGFILE GROUP -CREATE SERVER, ALTER SER...
Preview 3 out of 19 pages
Add to cartWhich groups of SQL statements will run successfully in the Web UI? (Choose 2) -CREATE INDEX and DROP INDEX -CREATE USER, ALTER USER and DROP USER -CREATE TABLESPACE, ALTER TABLESPACE and DROP TABLESPACE -CREATE LOGFILE GROUP, ALTER LOGFILE GROUP and DROP LOGFILE GROUP -CREATE SERVER, ALTER SER...
True or False: The COPY command exports to a single file by default. correct answers False True/False: Credits used by a Medium virtual warehouse running for 2 hours is equal to 4 hours of Small virtual warehouse usage. correct answers True True or False: If a database or a schema Is cloned, t...
Preview 2 out of 6 pages
Add to cartTrue or False: The COPY command exports to a single file by default. correct answers False True/False: Credits used by a Medium virtual warehouse running for 2 hours is equal to 4 hours of Small virtual warehouse usage. correct answers True True or False: If a database or a schema Is cloned, t...
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.
No, you only buy these notes for $51.60. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
88173 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now