D191 - Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about D191? On this page you'll find 36 study documents about D191.
Page 3 out of 36 results
Sort by
-
WGU D191 study cards continued...PA Questions And Answers.
- Exam (elaborations) • 4 pages • 2023
-
- $9.99
- + learn more
WGU D191 study cards continued...PA Questions And Answers.
-
WGU D191 Exam Study Guide | Latest 2023/24 | Updated & Verified | Guaranteed Success
- Exam (elaborations) • 15 pages • 2023
-
- $15.49
- + learn more
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...
-
D191 Advanced data management(SQL) Questions And Answers Graded 2023
- Exam (elaborations) • 8 pages • 2023
-
- $10.49
- + learn more
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
- Exam (elaborations) • 3 pages • 2023
-
- $11.19
- + learn more
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!!
- Exam (elaborations) • 2 pages • 2023
-
- $12.99
- + learn more
WGU D191 Review Rated 100% Correct!!
Fear of missing out? Then don’t!
-
WGU D191 Exam Study Guide | 335 Questions with 100% Correct Answers | Verified | Latest Update | 116 Pages
- Exam (elaborations) • 116 pages • 2023
-
- $27.49
- + learn more
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
- Exam (elaborations) • 5 pages • 2023
-
- $11.49
- + learn more
D191 Advanced Data Management 2023
-
WGU D191 terms Questions and Answers graded A+
- Exam (elaborations) • 3 pages • 2023
-
Available in package deal
-
- $13.49
- + learn more
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)
- Exam (elaborations) • 3 pages • 2023
-
- $11.49
- + learn more
WGU - D191 - Advanced Data Management (Textbook Flashcard Dump)
-
D191 Advanced data management (SQL) review solution
- Exam (elaborations) • 3 pages • 2023
-
- $11.49
- + learn more
D191 Advanced data management (SQL) review solution
Do you wonder why so many students wear nice clothes, have money to spare and enjoy tons of free time? Well, they sell on Stuvia! Imagine your study notes being downloaded a dozen times for $15 each. Every. Single. Day. Discover all about earning on Stuvia