IBM IBM Certified Analyst C2170-051 Questions & Answers

• Question 81:

  The Filters and Histograms feature in Analyst's Notebook allows the user to do all of the following EXCEPT for the ability to:

  A. use analysis attributes for analyzing data.

  B. isolate data based on filters or histograms selected.

  C. drill-down into the data to do more in depth analysis.

  D. view the data in different ways while at the same time changing the underlying data.

  Correct Answer: D

• Question 82:

  An analyst is creating an Import Specification. During the Assign Columns step, which task MUST be performed?

  A. Assign all the identities.

  B. Create more than one entity.

  C. Add additional entities and links.

  D. Assign all of the columns in the spreadsheet.

  Correct Answer: A

• Question 83:

  A researcher in the UK has been tasked with creating a spreadsheet ready to be imported into Analyst's Notebook. The chart required looks like this:

  

  Which of the following spreadsheets is ready for importing, and does not need any spreadsheet formulas or Column Actions to change it in any way?

  

  A. Exhibit A

  B. Exhibit B

  C. Exhibit C

  D. Exhibit D

  Correct Answer: B

• Question 84:

  Review the following screenshot of an import, where blank values have been detected:

  

  Which of the following is NOT an option to address the warning message?

  A. Do not create the entity.

  B. Create the entity with a blank identity.

  C. Create the entity and assign a specified identity.

  D. Create the entity and assign each identity individually.

  Correct Answer: D

• Question 85:

  A researcher in the UK has been tasked with creating a spreadsheet ready to be imported into Analyst's Notebook. The chart required looks like this:

  

  Which of the following spreadsheets is ready for importing, and does not need any spreadsheet formulas or Column Actions to change it in any way?

  

  A. Exhibit A

  B. Exhibit B

  C. Exhibit C

  D. Exhibit D

  Correct Answer: C

• Question 86:

  An analyst wants to import a timeline of a suspect's activity. This timeline would represent the suspect and a brief description of each activity tied to that suspect. Which is the BEST import design for this chart?

  A. Entities only

  B. Association chart

  C. Sequence of events

  D. Sequence of transactions

  Correct Answer: C

• Question 87:

  Which file type can be imported automatically into Analyst's Notebook without the need for an Import Specification?

  A. Tab delimited files (*.tsv)

  B. Cellebrite UFED files (*.xml)

  C. Excel spreadsheet files (*.xls)

  D. Comma separated value files (*.csv)

  Correct Answer: B

• Question 88:

  Review the following image:

  

  Which of the following will eliminate the Red Circle Error in the identity field?

  A. Change capitalization

  B. Set identity with a value

  C. Close the source data file

  D. Rename the column header

  Correct Answer: B

• Question 89:

  When importing, a data source output shows columns A and B. It is necessary for Column B to be joined with Column A, but the information in column B must appear first. With Column B selected, which of the following Column Actions can MOST efficiently accomplish this task?

  A. Compress Columns

  B. Suffix with Another Column

  C. Prefix with Another Column

  D. Merge with Another Column

  Correct Answer: B

• Question 90:

  When using telephone data, it is sometimes necessary to standardize data.

  

  Which of the following is the MOST efficient Column Action to standardize the following phone numbers?

  A. Find and Replace

  B. Combine Columns

  C. Remove Characters

  D. Extract Portion of Text

  Correct Answer: C