WGU D075 IT CORRECT EXAM QUESTIONS AND
ANSWERS SET A+
✔✔A data analyst wants to search through unstructured data from social media posts to
look for useful customer behavior patterns and sentiments. Which type of analytics is
appropriate for this task? - ✔✔Text analytics
✔✔Which term refers to managing the availability, integrity, and security of an
organization's data to ensure that the data remain high quality and valid? - ✔✔Data
governance
✔✔By segmenting data in a data management system, a business achieves a
significant advantage over nonsegmentation. What is that advantage? - ✔✔It targets the
right customers.
✔✔What is the process of normalization of a database? - ✔✔Removing redundancies
within the database
✔✔Which restriction applies to the data in the primary field of a database? - ✔✔Each
key must be unique.
✔✔The data analyst at Freedom Rock Bicycles wants to link two tables in the database.
What is the name of the field in a database table that is used to connect or link two
tables together? - ✔✔Foreign key
✔✔Freedom Rock Bicycles is considering adopting a cloud-database system. What is
the primary advantage of a cloud database? - ✔✔It can be accessed from anywhere
there is an internet connection.
✔✔Which valuable business intelligence (BI) can Freedom Rock Bicycles acquire from
the database that directly relates to overall revenue and profitability based on this
scenario? - ✔✔Knowing which products sell the best in each region
, ✔✔Freedom Rock Bicycles found that it has multiple records due to multiple sales to
the same individual. This has caused access problems when looking for specific
customers. What can Freedom Rock Bicycles do to alleviate this problem? -
✔✔Normalize the database
✔✔Freedom Rock Bicycles has installed a new database to keep track of sales by
region, salesperson, product, and sales prices, among other items, to keep information
on business processes. After installation, Freedom Rock Bicycles discovered additional
benefits of the information accumulated in the database and how the information can
improve the business profitability and future plans.
Freedom Rock Bicycles found that daily reports could be run using SQL to indicate
product and parts inventory and sales for the day.
Which approach can be used to retrieve this information efficiently? - ✔✔Online
analytical processing (OLAP)
✔✔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 warehouse 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? - ✔✔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
✔✔William and Jack are motorcyclists. They ride to work each day and own a
motorcycle repair shop. They started their business fixing friends' motorcycles, and
before long they found they had more work than they could handle. Customers began to
ask for services such as a website to buy parts and accessories and information on
safety and maintenance. William and Jack believe they could expand their business and
increase their revenue by adding these services and selling used motorcycles. To make
this possible, they need to install and gain expertise in the use of IT. In addition, they
ANSWERS SET A+
✔✔A data analyst wants to search through unstructured data from social media posts to
look for useful customer behavior patterns and sentiments. Which type of analytics is
appropriate for this task? - ✔✔Text analytics
✔✔Which term refers to managing the availability, integrity, and security of an
organization's data to ensure that the data remain high quality and valid? - ✔✔Data
governance
✔✔By segmenting data in a data management system, a business achieves a
significant advantage over nonsegmentation. What is that advantage? - ✔✔It targets the
right customers.
✔✔What is the process of normalization of a database? - ✔✔Removing redundancies
within the database
✔✔Which restriction applies to the data in the primary field of a database? - ✔✔Each
key must be unique.
✔✔The data analyst at Freedom Rock Bicycles wants to link two tables in the database.
What is the name of the field in a database table that is used to connect or link two
tables together? - ✔✔Foreign key
✔✔Freedom Rock Bicycles is considering adopting a cloud-database system. What is
the primary advantage of a cloud database? - ✔✔It can be accessed from anywhere
there is an internet connection.
✔✔Which valuable business intelligence (BI) can Freedom Rock Bicycles acquire from
the database that directly relates to overall revenue and profitability based on this
scenario? - ✔✔Knowing which products sell the best in each region
, ✔✔Freedom Rock Bicycles found that it has multiple records due to multiple sales to
the same individual. This has caused access problems when looking for specific
customers. What can Freedom Rock Bicycles do to alleviate this problem? -
✔✔Normalize the database
✔✔Freedom Rock Bicycles has installed a new database to keep track of sales by
region, salesperson, product, and sales prices, among other items, to keep information
on business processes. After installation, Freedom Rock Bicycles discovered additional
benefits of the information accumulated in the database and how the information can
improve the business profitability and future plans.
Freedom Rock Bicycles found that daily reports could be run using SQL to indicate
product and parts inventory and sales for the day.
Which approach can be used to retrieve this information efficiently? - ✔✔Online
analytical processing (OLAP)
✔✔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 warehouse 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? - ✔✔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
✔✔William and Jack are motorcyclists. They ride to work each day and own a
motorcycle repair shop. They started their business fixing friends' motorcycles, and
before long they found they had more work than they could handle. Customers began to
ask for services such as a website to buy parts and accessories and information on
safety and maintenance. William and Jack believe they could expand their business and
increase their revenue by adding these services and selling used motorcycles. To make
this possible, they need to install and gain expertise in the use of IT. In addition, they
