CompTIA DA0-001 問題集

質問 1：
Which of the following database schemas features normalized dimension tables?
A. Flat
B. Hierarchical
C. Star
D. Snowflake
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to BEST display the data?
A. Include a line chart using the site and the percentage of new customers data.
B. Include a scatter chart using the site and the percent of new customers data.
C. Include a pie chat using the site and percentage of new customers data.
D. Include a bar chart using the site and the percentage of new customers data.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN:

Customer Table -
In-store Transactions -

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?
A. INNER: 9 rows; LEFT: 15 rows
B. INNER: 15 rows; LEFT: 9 rows
C. INNER: 6 rows; LEFT: 9 rows
D. INNER: 9 rows; LEFT: 6 rows
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?
A. Create subscriptions.
B. Optimize the dashboard.
C. Get stakeholder approval.
D. Deploy to production.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the best access control method for the administrator to use?
A. Group-based
B. Rule-based
C. Discretionary
D. Role-based
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
An analyst wants to test the association between the number of doors in a car and the number of gears in the car. Which of the following is the best test to use?
A. Chi-squared test
B. Acceptance test
C. Z-test
D. F-test
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which of the following is an example of discrete data?
A. The temperature at a weather station
B. The power consumption in a building
C. The amount of rain that falls in a storm
D. The number of employees at a company
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
A data set for sales per month includes the following data:

Which of the following cleaning and profiling methods should be applied to the data set?
A. Data type validation
B. Invalid data
C. Duplicate data
D. Data outliers
正解：B