387,680 views
18 votes
18 votes
An update log file contains the following information:

LogID Old.Name Old.Phone Old.City New.Name New.Phone New.City UpdateTimeStamp
15 Steve Gleason 212 834- 2345 Brooklyn Steven Gleason 212 834- 2345 NJ 01/21/22 07:02:09 UTC
16 Mabel Zurich 315 332 3833 Morristown Mabel Lee 315 332- 833 Camden 01/21/22 07:02:29 UTC
17 Juan Moroni 646 257- 7455 Bronx Juan Moroni 646 257- 7455 Long Island Jan. 21 2022 07:03:02 UTC

For LoglD 17 which of the following data structure issues are present?
a. Data parsing.
b. Cryptic data values.
c. Misfielded values.
d. Data consistency.
e. Data concatenation

User Sylordis
by
2.3k points

2 Answers

9 votes
9 votes

Final answer:

Issues of data parsing and data consistency are present in LogID 17, where the timestamp format differs from others. There is no evidence of data concatenation, misfielded, or cryptic data values.

Step-by-step explanation:

For LogID 17, the data structure issues present are:

  • Data parsing: While other timestamps are recorded in MM/DD/YY format, this log's timestamp is spelled out as 'Jan. 21 2022', requiring parsing to match the format of others.
  • Data consistency: An inconsistency is present in the UpdateTimeStamp format compared to the earlier entries.
  • Data concatenation: There is no issue with data concatenation observed in this log entry.

Data parsing and data consistency are the predominant issues in this log file's data structure for LogID 17. The correct Old.City and New.City values are listed with no misfielding or cryptic data values, and data concatenation typically refers to improper combining of fields, which is not evident here.

User Aeyang
by
2.6k points
28 votes
28 votes
Cooollll very goodnight
User Asafel
by
2.8k points