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

01. After you execute an SQL select statement in Datamaker, which tab displays the column data?
a) GT Diagrammer
b) SQL Target Data
c) Schema Explorer
d) Results, which will renamed "Data in <table_name>"

02. The Test Data Repository is where users keep a registry of data sources and connection information. The Test Data Repository also:
a) calculates the coverage of sub-flows inside test cases.
b) stores all data from any source a user connects to during a project.
c) captures source metadata and the native data attributes of a database.
d) triggersthe Data Generation tool to create the data needed for a test case.

03. When you create a project in the CA TDM Portal, which group or groups are automatically assigned to the project?
a) Admin and Tester
b) Admin only
c) Tester and Profiler
d) Admin, PowerUser, and Auditor

04. Which tasks can you perform in the CA TDM Portal?
(Choose three)
a) Create test match data pools.
b) Publish test match data for reservation.
c) Parse and shred request/response pair files.
d) Create and manage database connection profiles.
e) Import flat file definitions and generate flat file data.

05. When you register data to a project, it is the version of the project that is targeted. Which statement about registered data is TRUE?
a) All database tables are copied and stored in the version.
b) Tables can be re-registered and duplicated inside a version as many times as needed.
c) As tables are registered, all data attributes and relationships are stored in the repository.
d) With the exception of copybook file definitions, any flat files that are registered, such as .csv, .xlsx, or .xls files, will be provided with a primary key for the source environment.

06. During the Excel/CSV file registration procedure, which step can you perform?
a) Select a pervasive file descriptor.
b) Import worksheet data into a data pool.
c) Select worksheets from multiple workbooks
d) Select to extract direct attributes of the data for test case use.

07. Which step must you perform before creating a data generator?
a) Register the tables or file objects you need to create derived tables from.
b) Use the search function to find your specific data generator name and description.
c) Click the View Table Relationships feature to select the appropriate tables you want to use for data generation rules.
d) Go to the application.properties file and verify that the value of the following setting is "true": tdmweb.testerSelfService.useDatamakerToPublish=true

08. When you upgrade CA Test Data Manager product components, you typically rename:
a) the server.xml file for the portal upgrade.
b) the rep.xml file for the repository upgrade.
c) the application.properties file for the Datamaker upgrade.
d) the projects.xml file for the Test Data on Demand (TDoD) upgrade.

09. What typically happens when you launch the Data Subset tool for the first time?
a) A wizard appears where you are asked to select a driving table to extract rules.
b) A Sampling Options dialog appears where you select the options you will use for the subsetting.
c) A dialog appears where you indicate if you will use HTML and XML files as sources for subsetting.
d) A dialog appears where you complete any connection profile details that have not been transferred from the source and repository connection.

10. Which repository types does CA Test Data Manager support?
a) Oracle and DB2 only
b) Oracle and SQL Server only
c) SQL Server, Oracle, and PostGreSQL only
d) CA Datacom®, SQL Server, and Oracle only