Snowflake DAA-C01 Certification Exam Sample Questions

DAA-C01 Braindumps, DAA-C01 Exam Dumps, DAA-C01 Examcollection, DAA-C01 Questions PDF, DAA-C01 Sample Questions, SnowPro Advanced - Data Analyst Dumps, SnowPro Advanced - Data Analyst Official Cert Guide PDF, SnowPro Advanced - Data Analyst VCEWe have prepared Snowflake SnowPro Advanced - Data Analyst (DAA-C01) certification sample questions to make you aware of actual exam properties. This sample question set provides you with information about the SnowPro Advanced - Data Analyst exam pattern, question formate, a difficulty level of questions and time required to answer each question. To get familiar with Snowflake Certified SnowPro Advanced - Data Analyst exam, we suggest you try our Sample Snowflake DAA-C01 Certification Practice Exam in simulated Snowflake certification exam environment.

To test your knowledge and understanding of concepts with real-time scenario based Snowflake DAA-C01 questions, we strongly recommend you to prepare and practice with Premium Snowflake SnowPro Advanced - Data Analyst Certification Practice Exam. The premium Snowflake SnowPro Advanced - Data Analyst certification practice exam helps you identify topics in which you are well prepared and topics in which you may need further training to achieving great score in actual Snowflake Certified SnowPro Advanced - Data Analyst exam.

Snowflake DAA-C01 Sample Questions:

01. Two analysts on a pharmacy retail team must both be able to list and load the same set of staged CSV deliveries, and a scheduled job running under a third role has to read them as well. One analyst has been uploading the files to her own user stage, and the other analyst cannot see them.
Which internal stage should hold these files?
a) The table stage of the target table, since it inherits that table's privileges and is therefore reachable by every role that already holds SELECT on it.
b) A named internal stage, since a user stage reference resolves to the session issuing it and never reaches another user's files.
c) Her user stage, with read access on it granted to the second analyst and to the scheduled job's role, so no new object is created.
d) A table stage on each analyst's own scratch table, keeping each copy of the files separate.
 
02. An agricultural cooperative receives a CSV extract converted from a fixed-width mainframe file. Every product_code value is padded with trailing spaces out to a uniform width. After the load, a join between the loaded table and the product dimension returns no matches, and LENGTH over the loaded column returns the padded width rather than the width of the code itself.
The correction has to be made in the load, has to leave spaces occurring inside a value untouched, and must not require the statement to name each field individually. Which change meets those requirements?
a) Apply RTRIM to the column in every reporting view that joins on the code, so that the comparison uses the trimmed form while the loaded values stay exactly as the provider wrote them.
b) Describe the file format by column start position and width, so that the fixed layout is stated once and the padding never becomes part of a value.
c) Enable TRIM_SPACE in the file format, which strips white space from both ends of every field as it is parsed and leaves the spaces inside a value alone.
d) Declare the space character as a second field delimiter, so that the padding is consumed while the record is split into fields.
 
03. Analysts at a market research firm work interactively against a shared warehouse. Occasionally an exploratory statement runs for hours and holds compute the rest of the team needs. The team wants any statement exceeding an agreed duration to be ended rather than left running, and wants that bound to hold regardless of who submits the statement.
Which two statements about using STATEMENT_TIMEOUT_IN_SECONDS for this are accurate?
(Select TWO.)
a) When both the warehouse and the session carry a value, the lower non-zero value governs, so an analyst cannot lengthen the warehouse's bound from a worksheet.
b) Setting the value on the warehouse bounds every statement submitted to it, whatever role or session issued that statement.
c) A statement that reaches the limit is queued behind the warehouse's other work and resumes when compute frees up, rather than being ended.
d) Suspending the warehouse while the statement is running ends it cleanly and returns the rows produced up to that point to the worksheet.
e) The bound applies only to statements a task or a stored procedure submits, so an interactive worksheet statement sits outside its scope, and an analyst's own session is unaffected by it, however long it runs.
 
04. An energy utility feeds a managed table through a pipe that loads files as storage notifications arrive. Analysts report that rows are appearing hours after the source system writes the file. The team needs to establish whether the pipe is working through a backlog of files it has already been notified about, or is not being notified about the new files at all.
Which check distinguishes the two?
a) Query COPY_HISTORY for the target table over the period, which lists each file the pipe has loaded and the rows it contributed.
b) Run LIST against the stage path and count the files sitting there, which shows how many are still waiting for the pipe.
c) Resume the pipe with ALTER PIPE and place the day's files in the stage a second time, since a pipe that falls behind stops asking for further notifications.
d) Call SYSTEM$PIPE_STATUS for the pipe and read its pending file count alongside the time at which the last notification message reached it from the channel.
 
05. Three weeks ago a healthcare payer's analyst promoted an exploratory worksheet onto a dashboard as a tile reporting active member counts. Since then the analyst has duplicated that worksheet and continued refining the statement in the copy, adding a predicate that excludes internal test accounts, and the copy now returns a materially lower count. The dashboard tile has been refreshed several times since, still reports the higher figure, and runs on a warehouse that has been active throughout.
What accounts for the difference?
a) The tile carries the statement as it stood when the tile was created, so refinements made in the analyst's working copy never reached it.
b) The tile is serving the rows from its most recent successful refresh, so the corrected statement has executed while the dashboard continues to display the result produced before it.
c) The working copy and the tile resolve the member table under different roles, so each returns a different set of rows.
d) The dashboard's warehouse was suspended between refreshes and returned its previous result.
 
06. An insurance analytics team maintains a curated claims aggregate with a stream on the source table and a task running a MERGE the team wrote and tunes itself. Business users have stated only a maximum staleness the aggregate may carry, and the team wants to stop owning both the incremental logic and the refresh cadence.
Which object expresses that requirement directly?
a) A materialized view over the same query, since a materialized view also accepts a target lag and refreshes itself on that basis.
b) A task scheduled at the stated staleness, whose statement rebuilds the aggregate in full from the source each time.
c) A stream on the source with a serverless task, so the refresh cadence is chosen by Snowflake from the observed data volume.
d) A dynamic table defined by that query, with TARGET_LAG set to the stated staleness.
 
07. A broadcast analytics team reconciles deliveries by querying a directory table defined on an external stage. A new batch of files was written to that stage path an hour ago, and the provider has confirmed the objects are present under the path the stage points at. The directory table query still returns only the previous day's rows. Automatic refresh is not configured on the stage.
What accounts for the result?
a) A directory table reads only files the stage's file format can parse, and the new batch uses a format the stage does not declare.
b) The directory table serves cached file metadata, which has not been refreshed since the new files arrived.
c) Directory table rows appear only after a COPY INTO has loaded a file, so files that no load has consumed are absent.
d) The new files were written outside the stage's URL prefix, so the stage resolves a different path than the provider used for delivery.
 
08. An e-commerce team measures a checkout funnel from an events table holding one row per event, with user_id, stage and event_ts. Shoppers frequently return to the cart stage several times in one session, and shoppers arriving from a saved payment link reach the payment stage with no cart event at all.
The report must show, for each stage, the share of shoppers who reached it after having reached the stage before it.
Which approach produces that measure?
a) Count the events recorded at each stage and divide by the events at the stage before it, which absorbs the repeat visits.
b) Count distinct shoppers at each stage without regard to order, since reaching a stage implies every stage before it was reached.
c) Count distinct shoppers whose first event at each stage falls after their first event at the preceding stage.
d) Number each shopper's events with ROW_NUMBER over the event timestamp and treat the rank of an event as its stage position.
 
09. A media publisher's dashboard carries three tiles covering the same four subscription products. Each tile takes its colors from a categorical palette applied in the order the products arrive in that tile's own result, and one of the three tiles is filtered to the three products sold through retail partners.
A reviewer reading the dashboard attributed a decline on one tile to the wrong product, having carried the color assignment across from the tile above it.
Which change removes that failure?
a) Assign each product one color and apply that mapping on every tile.
b) Add a legend to every tile so a reader can check which color stands for which product before reading that tile.
c) Give each tile a palette chosen to suit its own chart type, so that every tile is readable on its own terms.
d) Order the products consistently in each tile's query so that the palette assigns its colors in the same sequence everywhere.
 
10. Regional managers at a logistics operator already open the company's BI portal each day for finance and headcount reporting drawn from several systems. A new on-time-delivery measure computed in Snowflake has to reach the same managers weekly. The analytics team can publish a Snowsight dashboard for it or add the measure to the existing portal, and wants to avoid maintaining two definitions of on-time delivery.
Which consideration should decide the surface?
a) The measure's logic would have to be rebuilt in the BI tool's own modeling language, so publishing in Snowsight is what avoids a second definition of on-time delivery.
b) Snowsight queries the warehouse at the moment a tile is opened while a BI tool reads rows it has copied into its own storage, so only the dashboard shows figures current as at viewing.
c) The managers already work in the portal and the measure has to be read beside figures sourced elsewhere, so the BI connection puts it where the audience looks and lets one report combine the sources.
d) A Snowsight dashboard runs its statements on a warehouse the analytics team owns, so publishing there keeps the compute cost away from the managers' own budget.

Answers:

Question: 01
Answer: b		 Question: 02
Answer: c		 Question: 03
Answer: a, b		 Question: 04
Answer: d		 Question: 05
Answer: a
Question: 06
Answer: d		 Question: 07
Answer: b		 Question: 08
Answer: c		 Question: 09
Answer: a		 Question: 10
Answer: c

Note: Please update us by writing an email on feedback@vmexam.com for any error in Snowflake Certified SnowPro Advanced - Data Analyst certification exam sample questions

Rating: 5 / 5 (79 votes)