Download Snowflake Snowpipe Certification Exam Questions and Answers and more Exams Computer Science in PDF only on Docsity!
SnowPro Certification Final Test Exam
t/f: Snowpipe must have a COPY statement in the pipe definition - โ โ true What does the copy statement in a pipe definition identify - โ โ stage and a target table What are the different mechanisms for detecting staged files using Snowpipe - โ โ automating snowpipe using cloud messaging, calling Snowpipe rest endpoints Cross-cloud support for automated Snowpipe using cloud messaging is only available to accounts hosted on a. AWS b. Azure c. GCP - โ โ a. aws When calling Snowpipe rest endpoints, your client application calls a public REST endpoint with... - โ โ the name of a pipe object and a list of new data filenames Authenticating for a bulk data load relies on - โ โ security options supported by the client application for authenticating and initiating a user session Authenticating when calling rest endpoints with snowpipe requres - โ โ key pair authentication with JSON Web Token
The load history for Snowpipe is stored in the metadata for how many days? - โ โ 64 days Where is the load history for Snowpipe stored? - โ โ In the metadata of the pipe The load history for a bulk data load is stored in the _________________ for ____ days - โ โ metadata of the target table, 64 days Load history for Snowpipe must be requested via a ______________, _____________, or _____________________________ - โ โ rest endpoint, sql table function, account_usage view t/f: snowflake recommends using either bulk data loading or Snowpipe but not both - โ โ true t/f: Bulk data loads are always performed in multiple transactions - โ โ False (Loads are always performed in a single transaction) t/f: Snowpipe loads are combined or split into a single or multiple transactions based on the number and size of rows in each data file - โ โ true Snowpipe is billed according to.... - โ โ compute resources used in the Snowpipe WH while loading the files Bulk data loading compute costs are billed for.. - โ โ amount of time wh is active For the most efficient and cost-effective load experience with Snowpipe, Snowflake recommends staging files once per ___________
a. account b. schema c. database d. pipe - โ โ a. account, b. schema, d. pipe As a data consumer you can have many data shares BUT? - โ โ Can only create ONE read-only database Data shared to a Reader account? - โ โ Is read-only(SELECT) they can NOT perform any DML The same role based access is applicable to a shared database? - โ โ True Snowflake sharing, no data is copied. It is just the metadata that enables the sharing of data? - โ โ Since no data is copied, the target snowflake account (also called the consumer) is not charged for any storage. A share contains? - โ โ - Usage privileges on DB+Schema
- Secure views
- Consumer account to share too You can create an unlimited amount of shares? - โ โ True To create a DB as a consnumer account? - โ โ Must be ACCOUNTADMIN role OR Have import share privileges
What DB objects can be shared? - โ โ - Secure Views
- DBs
- Schemas
- Tables Lowest edition that provides customer dedicated warehouse? - โ โ Standard Only one instance of data per cloud or region has to be replicated. Once the instance is replicated more then one consumer can make use of this data - โ โ True To share data with other clouds? - โ โ Provider must enable replication and replicate existing DB to other cloud provider Load metadata expires after? - โ โ 64 days Snowflake supports loading from? - โ โ - S
- Google Cloud
- Azure Blob
- Internal named stage VARIANT data type can store up to? - โ โ 16 MB Snowpipe uses a server less compute which? - โ โ Managed by Snowflake and scales up/down SnowPipe load history is maintained for? - โ โ 14 days.
- Views Cloning a schema, clones? - โ โ All tables in schema(s) and other cloneable objects Is a cloned object writable? - โ โ True Patch releases for Snowflake are released how? - โ โ To ALL editions at the same time How are new releases deployed? - โ โ In phases from lowest edition(EA) and up Can you pre purchase storage capacity at a lower price compared to on- demand? - โ โ True JSON format when extracting to JSON? - โ โ ndjson(New Line Delimited JSON) Lowest version Tri-Secret is available? - โ โ Business Critical Database failover and failback is available starting at what edition? - โ โ Business Critical Dedicated metadata store and pool of virtual servers (used in virtual warehouses) is available in what edition? - โ โ Only in VPS Edition Materialized views, with automatic maintenance of result is available starting at? - โ โ Enterprise Edition Which minimum edition to allow data sharing? - โ โ Standard Snowflake SQL UDFs can return scalar OR tabular results? - โ โ True
Which of the following are valid casting functions available? - โ โ TO_VARIANT TO_TIMESTAMP TO_NUMBER TO_NUMERIC How are columns stored in a Snowflake Partion? - โ โ Independently True or False: When data is staged to a Snowflake internal staging area using the PUT command, the data is encrypted on the client's machine.
- โ โ True What is the frequency for Snowflake to apply software patches to the code base? - โ โ Weekly What is a pipe in Snowflake? - โ โ A named, first-class Snowflake object that contains a COPY statement used by Snowpipe.
The COPY statement identifies the source location of the data files (i.e., a stage) and a target table. All data types are supported, including semi- structured data types such as JSON and Avro. What file loading metadata is associated with each pipe object to prevent reloading the same files in a table? - โ โ path (i.e. prefix) and name of each loaded file (this prevents loading files with the same name even if they were later modified)
if a pipe is paused for longer than ___________, it is considered stale - โ โ 14 days t/f: Automated Snowpipe uses event notifications to determine when new files arrive in monitored cloud storage and are ready to load. Notifications identify the cloud storage event and include a list of the file names. They (do/do not) include the actual data in the files. - โ โ do not Calls to the public Snowpipe REST endpoints use ______________ authentication, rather than the typical username/password authentication - โ โ key-bASED t/F: it is recommended to create a separate user and role to use for ingesting files using a pipe - โ โ true t/f: Snowpipe supports both internal (Snowflake) stages and external stages, i.e. s3 buckets - โ โ true What are the steps to set up Snowpipe using rest endppoints - โ โ
- create a named stage object 2. create a pipe 3. configure security for the user who will execute the load 4. install a client sdk (java or python) for calling the Snowpipe public rest endpoints t/f: the number of load operations that run in parallel cannot exceed the number of files to be loaded - โ โ true to optimize the number of parallel operaitions for a load, what size data files should you produce - โ โ 100-250 mb compressed In addition to resource consumption, an overhead is included in the utilization costs charged for Snowpipe: ___________ credits per
_______ files queud. This overhead is charged regardless if the event notifications or REST API calls resulted in data loaded. - โ โ true Snowflake tracks the resource consumption of loads for all pipes in an account, with ________________/___________- granularity - โ โ per-second/per-core per-core refers to the _______________ ___________ _________ in a compute server - โ โ physical cpu cores How can you estimate snowpipe charges - โ โ experiment by performing a typical set of loads Which of the following are ways to view credits billed to your Snowflake account within a specified data range? a. Account > Billing and Usage in Web UI b. Query PIPE_USAGE_HISTORY table function (in the Snowflake Information Schema). c. Query PIPE_USAGE_HISTORY View view (in Account Usage). d. All of the above. - โ โ d. all of the above t/f: Resource monitors can be used to control credit usage for Snowflake-provided warehouses - โ โ false Enabling error notifications for Snowpipe is available on a. Azure b. AWS d. GCP - โ โ b. aws
