DAA-C01試験無料問題集（67題）「Snowflake SnowPro Advanced: Data Analyst Certification 認定」

出題：1

A Directed Acyclic Graph (DAG) of 12 tasks (ETLDAILY) failed because one of the tasks failed (STEP10), therefore the dependent tasks (STEP11 and STEP12) did not run. Which command is needed to re-run task STEP10 and the two dependent tasks?

A. ALTER TASK ETLDAILY RESUME;

B. ALTER TASK STEP10 RESUME;

C. EXECUTE TASK ETLDAILY RETRY LAST;

D. EXECUTE TASK STEP10 RETRY LAST;

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Why would a Data Analyst use a dimensional model rather than a single flat table to meet BI requirements for a virtual warehouse? (Select TWO).

A. Combining facts and dimensions in a single flat table limits the scalability and flexibility.

B. Snowflake generally performs better with dimensional modelling.

C. Dimensional modelling will improve query performance over a single table.

D. Dimensions and facts allow power users to run ad-hoc analyses.

E. Dimensional modelling will save on storage space since it is denormalized.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

A Data Analyst runs a query in a Snowflake worksheet, and selects a numeric column from the result grid.
What automatically-generated contextual statistic can be visualized?

A. A frequency distribution, displayed for all numeric columns

B. MIN/MAX values for the column

C. A key distribution

D. A histogram, displayed for all numeric, date, and time columns

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

A Data Analyst wants to transform query results. Which transformation option will incur compute costs?

A. Increasing or decreasing decimal precision.

B. Showing a thousand separator for numeric columns.

C. Sorting a column by using the column options.

D. Formatting date and timestamp columns.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

A Data Analyst for a ride-sharing company needs to assess the relationship between the number of active drivers in a city, and the average waiting time for passengers. Which query will determine if an increase in the number of active drivers is associated with a decrease in the average waiting time?

A. SELECT CITY, VARIANCE(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;

B. SELECT CITY, SUM(ACTIVE_DRIVERS), VARIANCE(AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

C. SELECT CITY, CORR(ACTIVE_DRIVERS, AVERAGE_WAITING_TIME) FROM RIDE_DATA GROUP BY CITY;

D. SELECT CITY, SUM(ACTIVE_DRIVERS), AVG(AVERAGE_WAITING_TIME) FROM
RIDE_DATA GROUP BY CITY;

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

What functionalities are available when a Snowflake worksheet is shared with other users? (Select TWO).

A. Users with edit permissions can view past versions of the worksheet.

B. If the worksheet is being edited, the collaborators will be able to see these edits in real-time.

C. If multiple users edit and run a shared worksheet at the same time, each run of the worksheet will create a new version.

D. Whenever a user with permissions runs a worksheet, the existing version history of the worksheet will be overwritten.

E. Collaborators can share the worksheet across Snowflake accounts.

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

A Data Analyst needs to add address details based on a customer's latitude and longitude to a customer sales database. The Analyst found a free Worldwide Address Data listing on the Snowflake Marketplace. The ACCOUNTADMIN placed the data set into a new database called ADDRESS_DATA. The Data Analyst needs to join the ADDRESS_DATA.OPENADDRESS table with the ORDERS table which is stored in the GLOBAL_DWH database. The combined data set needs to be created as a view. How can this be achieved?

A. Ask the ACCOUNTADMIN to grant the Data Analyst the IMPORTED_PRIVILEGES on the ADDRESS_DATA database and then create a view in the ADDRESS_DATA database.

B. Create a view in the GLOBAL_DWH database.

C. Create a new schema called ENRICHED in the ADDRESS_DATA database and create this view in the ENRICHED schema.

D. Create a view in the ADDRESS_DATA database.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

DAA-C01試験無料問題集「Snowflake SnowPro Advanced: Data Analyst Certification 認定」