PrepAway - Latest Free Exam Questions & Answers

What steps are necessary to provide usable output to the DBA?

You are working with a database administrator (DBA) who would like to create a revised
format for a database based on your data profiling results. The DBA wants to directly create
the resulting tables from the analysis. What steps are necessary to provide usable output to
the DBA?

PrepAway - Latest Free Exam Questions & Answers

A.
Select lnvestigate>Publish Analysis Results; select the relevant Table; select Generate
Physical Model; select Create DDL File option; enter file location; click Submit.

B.
Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the
InfoSphere Metadata Asset Manager option; click Submit; create New Import Area; select
the InfoSphere Data Architect Metabroker; select the created PDR model; select generate
ANSI standard DDL; click Submit.

C.
Select lnvestigate>Column Analysis; select the relevant Table; select Export Data Model;
select Create ANSI Standard DDL option; enter file location; click Submit.

D.
Select lnvestigate>Publish Analysis Results; select the relevant Table; choose the
Generate Database DDL option; select the database-specific DDL type; enter file location;
click Submit.

One Comment on “What steps are necessary to provide usable output to the DBA?


Leave a Reply