WGU D191 Exam Study Guide | 335 Questions with 100% Correct Answers | Verified | Latest Update | 116 Pages
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, transformation, is to convert, reformat, cleanse data into format that can be used be the target database.What does ETL stand for? - ETL is short for extract, transform, load
Document information
- Uploaded on
- February 11, 2023
- Number of pages
- 116
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers