What is one of the most significant advantages of an RDBMS?
2. Question 2 What is one of the most significant advantages of an RDBMS? 1 point Requires source and destination tables to be identical for migrating data …
-
-
Data Marts and Data Warehouses have typically been relational, but the emergence of what technology has helped to let these be used for non-relational data?
1. Question 1 Data Marts and Data Warehouses have typically been relational, but the emergence of what technology has helped to let these be used for non-relational data? 1 point …
-
While data integration combines disparate data into a unified view of the data, a data pipeline covers the entire data movement journey from source to destination systems, and ETL is a process within data integration.
5. Question 5 While data integration combines disparate data into a unified view of the data, a data pipeline covers the entire data movement journey from source to destination systems,…
-
Which of the following is an example of unstructured data?
2. Question 2 Which of the following is an example of unstructured data? 1 / 1 point Video and Audio files Spreadsheets XML Zipped files Correct Video and audio files are…
-
In the data engineer’s ecosystem, languages are classified by type. What are shell and scripting languages most commonly used for?
5. Question 5 In the data engineer’s ecosystem, languages are classified by type. What are shell and scripting languages most commonly used for? 1 / 1 point Manipulating data Building apps Querying…
-
Which data source can return data in plain text, XML, HTML, or JSON among others?
4. Question 4 Which data source can return data in plain text, XML, HTML, or JSON among others? 1 / 1 point APIs XML PDF Delimited text file Correct APIs can…
-
Which one of these file formats is independent of software, hardware, and operating systems, and can be viewed the same way on any device?
3. Question 3 Which one of these file formats is independent of software, hardware, and operating systems, and can be viewed the same way on any device? 1 / 1 point XML…
-
There are two main types of data repositories – Transactional and Analytical. For high-volume day-to-day operational data such as banking transactions, Transactional, or OLTP, systems are the ideal choice.
1. Question 1 There are two main types of data repositories – Transactional and Analytical. For high-volume day-to-day operational data such as banking transactions, Transactional, or OLTP, systems are the…
-
Oracle Exadata, IBM Db2 Warehouse on Cloud, IBM Netezza Performance Server, and Amazon RedShift are some of the popular __________________ in use today.
2. Question 2 Oracle Exadata, IBM Db2 Warehouse on Cloud, IBM Netezza Performance Server, and Amazon RedShift are some of the popular __________________ in use today. 1 / 1 point Data Warehouses…
-
To ensure business stakeholders can see real-time data each time they log into the dashboard, Sarah decided to build _______________ to extract, transform, and load data on an ongoing basis.
3. Question 3 To ensure business stakeholders can see real-time data each time they log into the dashboard, Sarah decided to build _______________ to extract, transform, and load data on…