DEA-7TT2 무료 덤프문제 온라인 액세스

Consider the following SQL query:
SELECT product_id FROM supplier_A
UNION
SELECT product_id FROM supplier_B;
What is the expected result?
Response:

• A.All product_id values from both tables with no duplicates or repeating rows
• B.All product_id values from both tables with duplicates or repeating rows
• C.All product_id values from supplier_B table but not from supplier_A table
• D.All product_id values from supplier_A table but not from supplier_B table

Refer to the exhibit.

You have plotted the distribution of savings account sizes for your bank. How would you proceed, based on this distribution?
Response:

• A.The data is extremely skewed. Replot the data on a logarithmic scale to get a better sense of it.
• B.The data is extremely skewed. Split your analysis into two cohorts: accounts less than 2500, and accounts greater than 2500
• C.The accounts of size greater than 2500 are rare, and probably outliers. Eliminate them from your future analysis.
• D.The data is extremely skewed, but looks bimodal; replot the data in the range 2, 500-10, 000 to be sure.

You are provided with the following list. Which window function is missing?
cume_dist()
dense_rank()
rank()
percent_rank()
first_value()
last_value()
lag()
lead()
ntile()
Response:

• A.cumulative_sum()
• B.median()
• C.row_preceding()
• D.row_number()

Refer to the exhibit.

Which type of data issue would you suspect based on the exhibit?
Response:

• A.The exhibit does not raise any obvious concerns with the data.
• B.Mis-scaled data, indicating potential issues with data entry
• C."Saturated" data, indicating potential issues with data definitions
• D.Incomplete data, indicating potential issues with data transmission

Refer to the Exhibit.

You are going into a meeting where you anticipate your manager will have a question on your dataset. Specifically, your manager will want to know about customers that are classified as renters with a good credit status. In order to prepare for the meeting, you create a rule: RENTER => GOOD CREDIT.
What is the confidence of this rule?
Response:

• A.73%
• B.63%
• C.41%
• D.18%