D075 Unit 3 Questions and Answers Rated A

Document Content and Description Below

D075 Unit 3 Questions and Answers Rated A Which type of data are referred to as "decayed"? ✔✔Data that have become outdated An analyst uses software to analyze data in the company's data wareho ... use and produce information to guide the organization. The information is presented in clearly understandable charts and graphs on a dashboard and is used to inform decisions in the organization. Which type of software is this analyst using? 0 / 1 ✔✔Business intelligence software A database manager is setting up a relational database. The manager creates a field in a table that links to the primary key in a different table in the database. What is this field called? ✔✔Foreign key Which level of security is required to protect the hardware and communications equipment that support a database? ✔✔System-level security A data analyst is using the ETL process to enter data into the company's relational database. The data contain many redundancies. Which process will the data analyst need to use before loading the extracted data into the database? ✔✔Normalization A data analyst is working with a very large set of data and trying to calculate the amount of data processing that needs to be completed each week. ✔✔Velocity Which tool allows large data sets to be stored and processed across multiple servers? ✔✔Hadoop Which term is used to refer to the process of combining structured, unstructured, and semistructured data into a data warehouse structure? ✔✔Data scrubbing Which technique is used to ensure data accuracy for a mailing campaign? ✔✔Segmentation An analyst at a furniture company wants to use the company's relational database to find out which customers have made purchases in the past six months. What is an appropriate tool for the data analyst to use to find this information? ✔✔SQL [Show More]

Last updated: 2 years ago

Preview 1 out of 2 pages

Buy Now

Instant download

We Accept: