Free CompTIA Data+ Exam DA0-001 Exam Practice Test

You are working with a dataset and need to swap the values in rows with those in columns.What action do you need to perform?

• Recording
• Filtering.
• Aggregation.
• Transposition.

Which of the following query optimization techniques involves examining only the data that is needed for a particular task?

• Making a temporary table
• Creating a flat file
• Indexing documents
• Creating an execution plan

You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

• True.
• False.

Which of the following types of analysis is used when comparing last week's sales to the previous week's sales?

• Trend analysis
• Exploratory analysis
• Prescriptive analysis
• Link analysis

Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

• Numeric
• Date
• Float
• Text

Which of the following is a characteristic of a relational database?

• It utilizes key-value pairs.
• It has undefined fields.
• It is structured in nature.
• It uses minimal memory.

An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit. but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

• Normalize the data.
• Standardize the data.
• Rescale the data.
• Aggregate the data.

You would like to measure how well an organization is achieving its goals.What type of analysis should you perform?

• Performance analysis.
• Outlier analysis.
• Predictive analysis.
• Trend analysis.

A survey asks participants to rate a company on a scale of one to ten. Which of the following best describes the rating variable?

• Continuous
• Ordinal
• Categorical
• Nominal

Which of the following types of analyses should be used to evaluate the connections and anomalies in a data set when either known patterns are being violated or new patterns are emerging?

• Correlation
• Descriptive
• Graph
• Regression