A company is subject to GDPR and must demonstrate that personal data in its database is processed lawfully. Which compliance documentation would provide evidence of lawful processing?

The data processing records, including the legal basis for processing

A database administrator is onboarding a new developer who needs to understand the structure of the company's customer database to write queries. The developer asks for a document that lists all tables, their fields, data types, and relationships. Which document should the administrator provide?

The entity-relationship diagram

A standard operating procedure for query writing

During an external audit, which of the following best demonstrates that an organization is following its data retention policies?

Documented evidence of data retention schedules and deletion logs

The database server's IP address

A verbal statement from the DBA that data is retained correctly

A multinational company must comply with both GDPR and a local data residency law that requires personal data of local citizens to be stored within the country. The company's database is hosted in a cloud region outside that country. Which compliance documentation should the company update to address this conflict?

The data dictionary, to document the location of each table

The ERD, to show the relationships between data entities

The data processing and storage documentation, including the region where data is stored

The backup schedule, to show when data is backed up

CompTIADataSys+

Domain 3Objective 3

Documentation and Tools DS0-001 Practice Questions (Page 6)

Part of the Database management and maintenance domain, which accounts for 25% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~9–15 in this domain), expect 2–4 from this objective — we provide 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

8concepts

25%of the exam

Questions 26–30

26application · medium
A company is subject to GDPR and must demonstrate that personal data in its database is processed lawfully. Which compliance documentation would provide evidence of lawful processing?
Select an answer first
27application · medium
A database administrator is onboarding a new developer who needs to understand the structure of the company's customer database to write queries. The developer asks for a document that lists all tables, their fields, data types, and relationships. Which document should the administrator provide?
Select an answer first
28foundation · easy
During an external audit, which of the following best demonstrates that an organization is following its data retention policies?
Select an answer first
29foundation · easy
In a data dictionary, which component describes the kind of data a column can hold, such as integer, varchar, or date?
Select an answer first
30expert · hard
A multinational company must comply with both GDPR and a local data residency law that requires personal data of local citizens to be stored within the country. The company's database is hosted in a cloud region outside that country. Which compliance documentation should the company update to address this conflict?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.

Documentation and Tools DS0-001 Practice Questions (Page 6)

Questions 26–30

A company is subject to GDPR and must demonstrate that personal data in its database is processed lawfully. Which compliance documentation would provide evidence of lawful processing?

A database administrator is onboarding a new developer who needs to understand the structure of the company's customer database to write queries. The developer asks for a document that lists all tables, their fields, data types, and relationships. Which document should the administrator provide?

During an external audit, which of the following best demonstrates that an organization is following its data retention policies?

In a data dictionary, which component describes the kind of data a column can hold, such as integer, varchar, or date?

Keep studying — Database management and maintenance