Broadcom TDM Foundations Technical Specialist (250-562) Certification Sample Questions

01. A payments file has a header record, detail records and a trailer that carries the number of detail records and their total amount. The receiving system rejects a generated file, although every detail record is well formed.
What should the team check first?
a) Whether each detail record repeats the header's file date
b) Whether the file holds a realistic daily volume of details
c) Whether the details are in ascending order of their amounts
d) Whether the trailer totals match the details

02. A database administrator objects to profiling an order-processing database during business hours, when it handles its heaviest transaction volume.
Which response addresses the administrator's concern?
a) Mask the database first, so the profile cannot expose any sensitive values to the team
b) Explain that profiling only reads the rows and never changes a stored value
c) Run the profile off-peak or against a recent copy of the database
d) Profile the catalog instead of the rows

03. Directory sign-in to the CA TDM Portal has worked for months. This morning no directory user can sign in, although the same users log on to their workstations normally and the domain controllers report healthy. The Portal's own administrator account, which is not a directory account, still signs in.
What should the administrator check first?
a) Whether the Test Data Repository database is running and accepting connections
b) Whether the lookup account has expired or been locked
c) Whether the users' own directory passwords expired over the weekend
d) Whether the domain controllers need a restart to clear their authentication cache

04. A profile of a 2-million-row accounts table shows that the ACCT_STAT column holds only six distinct values.
What does that result most likely indicate about the column?
a) It holds a status code, so it is a candidate for reference data
b) It is a primary key, so every value identifies one account
c) It holds free text that users type, so each value should be generated as a random string
d) It is mostly empty and can be ignored

05. A financial institution wants to give development teams a representative slice of production rather than a full copy. The result must be much smaller and still support realistic application testing.
Which approach meets that?
a) A full replication of the production database
b) A set of manual table exports maintained by the DBA team
c) A runtime audit of the queries the application issues
d) A designed subset extraction

06. A bank is building a fraud detection platform and needs large volumes of realistic customer, account and transaction records before acceptance testing. Regulation forbids using production information.
Which capability should administrators select?
a) Metadata relationship discovery.
b) Synthetic data generation.
c) Runtime audit analysis.
d) Reservation of a production subset.

07. A team generates JSON customer records for an API. For customers with no middle name, a tester proposes always omitting the middle-name field, arguing that omitting it and sending it with a null value are the same input.
Which statement is accurate?
a) An absent field and a null field are different inputs
b) JSON requires every field to be present, so absence is invalid
c) Both mean no value, so a well-built API treats them the same
d) Parsing turns every null into an absent field

08. A generator for a member table produces the birth date and age columns independently. Testers report rows where a member born in 1990 is listed as 12 years old, and the eligibility screen rejects those members.
How should the age column be generated?
a) Draw it at random from within the range of ages the eligibility rules accept
b) Relax the eligibility check in the test build so these rows are accepted
c) Leave it empty for each generated member
d) Calculate it from the birth date generated in the same row

09. A development team is creating automated integration tests that need thousands of realistic XML documents and JSON payloads, without copying production information.
Which capability best supports this requirement?
a) Relationship refinement
b) Runtime report scheduling
c) Non-relational data generation
d) Metadata profiling of the source

10. A quality assurance team needs JSON test documents for REST services whose production messages carry confidential information.
Which capability creates them?
a) Generating documents from the service's own schema
b) Profiling the production database for sensitive columns
c) Reserving existing documents through the REST APIs
d) Editing sample production messages by hand