D191 - Study guides, Class notes & Summaries

WGU D191 study cards continued...PA Questions And Answers.

f ETL and each subsequent step? - Extract, transform, load = data integration EXTRACT: Data from external/operational sources TRANSFORM: clean data into appropriate format LOAD: Put data into repo What are the basics of the EXTRACT step? - Connect to source systems by selecting/collecting data for analytical purposes within the data mart. Usually this involves consolidation. Must also convert data into a format that is suitable for transformation What are the basics of the TRANSFORM s...

TRUNCATE TABLE - delete all data from table leaving structure intact DROP TABLE - deletion of a table DELETE FROM table_name WHERE conditional; - delete specific data/rows from a table DROP DATABASE - Dropping a database ALTER TABLE table_name ALTER COLUMN column_name TIMESTAMP DEFAULT current_timestamp; - adding column in table to store a timestamp ALTER TABLE table_name ALTER COLUMN column_name1 TYPE CHARACTER VARYING( ), ALTER COLUMN column_name1 SET NOT NULL; - modify ...

WGU D191 Exam With 100% Correct Answers 2023 -d flag Specifies the database name in the psql command. -h flag Specifies the hostname of the database in the psql command. -p flag Specifies the database port in the psql command. ANALYZE command Collects statistics about tables and indices and stores them in internal tables. boolean A data type used to represent true or false. COPY command Transfers data from a database to a file, or from a file to a databa...

WGU D191 Review Rated 100% Correct!!

Which three events can activate a trigger? - INSERT UPDATE DELETE Which operator is used in a WHERE clause when the subquery returns more than one row of data? - IN ALL ANY Which statement accurately describes how jobs are scheduled in PostgreSQL? - The pgAgent is a job scheduling agent available for PostgreSQL What must be completed during the extract step in the ETL process? - The first step, extraction, is to collect or grab data from from its source(s). The second step, transfo...

D191 Advanced Data Management 2023

WGU D191 terms Questions and Answers graded A+ -d flag Specifies the database name in the psql command. -h flag Specifies the hostname of the database in the psql command. -p flag Specifies the database port in the psql command. ANALYZE command Collects statistics about tables and indices and stores them in internal tables. boolean A data type used to represent true or false. COPY command Transfers data from a database to a file, or from a file to a data...

WGU - D191 - Advanced Data Management (Textbook Flashcard Dump)

D191 Advanced data management (SQL) review solution