Topic 1 · Question 183
Which of following is a non-relational database?
- ANeo4j (correct answer)
- BSQLite
- CMySQL
- DPostgreSQL
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Neo4j
DA0-001 — questions
Page 10 of 15 · 294 total questions.
Topic 1 · Question 184
An analyst is building a new dashboard for a user. After an initial conversation with the user, the analyst created a mock-up of the dashboard. Which of the following best explains why the analyst created the mock-up?
- ATo identify the dimensions and measures
- BTo send to the client after deploying the dashboard to production
- CTo confirm important details before dashboard development begins (correct answer)
- DTo receive client approval for the final dashboard design
Reveal answer & explanationHide answer
Correct answer: C
The correct answer is C. Option C: To confirm important details before dashboard development begins
Topic 1 · Question 185
Which of the following is the best approach to use to gain a general understanding of a data set?
- ADescriptive statistics (correct answer)
- BBasic projections
- CGap analysis
- DTrend analysis
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Descriptive statistics
Topic 1 · Question 186
A salesperson who is prospecting potential clients collected the following data: Which of the following is an issue with this data?
- ADuplicate data
- BInvalid data (correct answer)
- CMissing value
- DRedundant data
Reveal answer & explanationHide answer
Correct answer: B
The correct answer is B. Option B: Invalid data
Topic 1 · Question 187
Given the following table: Which of the following methods is the best way to describe the changes in the values in the table?
- AAverage
- BRange (correct answer)
- CStandard deviation
- DMedian
Reveal answer & explanationHide answer
Correct answer: B
The correct answer is B. Option B: Range
Topic 1 · Question 188
A marketing analytics team received customer transaction data from two different sources. The data is complete and accurate; however, the field names appear to be inconsistent. Given the following tables: Which of the following is considered best practice if the team wants to consolidate the files and conduct further analysis?
- AStandardize the field names. (correct answer)
- BRecode the data values.
- COverwrite the field names in one of the tables.
- DEdit the field names in the data dictionary.
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Standardize the field names.
Topic 1 · Question 189
During data cleansing, an analyst conducts measures of central tendency on a data set. Which of the following data is the analyst attempting to identify?
- ADuplicate
- BMissing
- COutlying (correct answer)
- DInvalid
Reveal answer & explanationHide answer
Correct answer: C
The correct answer is C. Option C: Outlying
Topic 1 · Question 190
An analyst needs to determine the appropriate data type for the following sample data: Sample data collected: 5.99 - Which of the following data types should be used for this data?
- AText (correct answer)
- BFloat
- CAlphanumeric
- DNumeric
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Text
Topic 1 · Question 191
Which of the following types of analysis is used when comparing last week's sales to the previous week's sales?
- ATrend analysis (correct answer)
- BExploratory analysis
- CPrescriptive analysis
- DLink analysis
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Trend analysis
Topic 1 · Question 192
Which of the following is an example of structured data?
- AA credit card number (correct answer)
- BAn email
- CA photo
- DSocial media correspondence
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: A credit card number
Topic 1 · Question 193
A data analyst needs to create a dashboard to help identify trends in the data sets. Which of the following is an appropriate consideration for dashboard development?
- AData sources and attributes (correct answer)
- BFrequently asked questions
- CA report from the data source
- DA comparison of data sets
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Data sources and attributes
Topic 1 · Question 194
Which of the following data protection methods provides confidentiality for data in transit?
- ADe-identification
- BEncryption (correct answer)
- CMasking
- DAnonymization
Reveal answer & explanationHide answer
Correct answer: B
The correct answer is B. Option B: Encryption
Explanation
Encryption protects confidentiality by making data unreadable without the appropriate key.
Topic 1 · Question 195
A business intelligence team wants to create a new dashboard in order to solve a problem statement. Which of the following is the correct order of steps the team should take?
- ADetermine business needs, find data sources, validate the data, create a mock-up, and analyze the information. (correct answer)
- BFind data sources, determine business needs, validate the data, create a mock-up, and analyze the information.
- CCreate a mock-up, validate the data, analyze the information, determine business needs, and find data sources.
- DValidate the data, find data sources, analyze the information, and determine business needs.
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Determine business needs, find data sources, validate the data, create a mock-up, and analyze the information.
Topic 1 · Question 196
Which of the following formulas correctly illustrates an IF statement?
- A=IF(A1=2,"no","hat") (correct answer)
- B=IF(A1=2,"no","hat")END
- C=IF(A1,"no","hat")
- D=IF(A1=2,no,hat)
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: =IF(A1=2,"no","hat")
Topic 1 · Question 197
A company wants to know how its customers interact with an e-commerce website based on clicks over items. Which of the following is the primary requirement for this report?
- AData content (correct answer)
- BFrequency
- CFiltering
- DViews
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Data content
Topic 1 · Question 198 · Select all that apply
A database administrator is required to mask certain table columns containing PII in order to comply with the company privacy policy. Which of the following are the most likely types of information the administrator should mask? (Choose two.)
- AGovernment-issued ID (correct answer)
- BAddress (correct answer)
- COrder ID
- DOrder date
- ECustomer ID
- FReferral number
Reveal answer & explanationHide answer
Correct answer: A, B
The correct answer is A, B. Option A: Government-issued ID Option B: Address
Topic 1 · Question 199
A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below: Which of the following steps should the analyst take to create the table?
- ATranspose the first name and last name in both tables. Use LOOKUP to pull the address field from Table 2 into Table 1.
- BUse LOOKUP with the first name or last name to pull the address field from Table 2 into Table 1.
- CUse the append formula in both tables for the first name and last name. Use LOOKUP to pull the address field from Table 2 into Table 1.
- DCreate a column that concatenates the first name and last name in each table. Use CONCATENATE and LOOKUP to bring the address field into Table 1. (correct answer)
Reveal answer & explanationHide answer
Correct answer: D
The correct answer is D. Option D: Create a column that concatenates the first name and last name in each table. Use CONCATENATE and LOOKUP to bring the address field into Table 1.
Explanation
Network address translation maps addresses between networks and commonly lets private hosts share public connectivity.
Topic 1 · Question 200
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?
- ACorrelation
- BDescriptive
- CGraph (correct answer)
- DRegression
Reveal answer & explanationHide answer
Correct answer: C
The correct answer is C. Option C: Graph
Topic 1 · Question 201
A research analyst collects ten data points from 1,000 specimens. The analyst will not need any additional data to complete the analysis and will not need to retrieve information by specifier. Which of the following is the best data structure for the analyst to use?
- ANoSQL
- BFlat file (correct answer)
- CJSON
- DRelational database
Reveal answer & explanationHide answer
Correct answer: B
The correct answer is B. Option B: Flat file
Topic 1 · Question 202
Which of the following data manipulation techniques should an analyst use to hide unnecessary data during analysis?
- AFiltering (correct answer)
- BParametrization
- CSorting
- DIndexing
Reveal answer & explanationHide answer
Correct answer: A
The correct answer is A. Option A: Filtering
Showing questions 181–200 of 294 · Page 10 of 15