Answer:
True
Explanation:
A single file can be used to record/ store all the information regarding a transaction because in a transaction there are less complexities. a simple transaction involves an exchange/communication between a buyer and a seller which involves exchange in finances between the buyer and the seller.
An employee can be involved in several activities like work activities and multiple transactions while a single inventory part record is different from an employee's record and any other form of transaction. hence separate files have to be created for each of these activities.
To have an easy access to this information when needed a master file is created to store all the individual files.
Answer:
An online company wants to conduct real-time sentiment analysis about its products from its social media channels using SQL. The solution which has lowest cost and operational burden is as follow:
B. Configure the input stream using Amazon Kinesis Data Streams. Use Amazon Kinesis Data Analytics to write SQL queries against the stream.
Explanation:
- The option A is not correct as this solution doesn't have lowest cost and operational burden as set up a streaming data ingestion application on Amazon EC2 and connect it to a Hadoop cluster for data processing will have more cost and operational burden.
- The lowest cost and operational burden solution is that we configure input stream using Amazon Kinesis Data Streams. We can use Amazon Kinesis Data Analytics to write SQL queries against the stream.
- The option c and d are also more pricey in terms of cost and operational burden as compared to Amazon Kinesis Data stream and analytics.
Answer: C. Cause and Effect Modelling.
Explanation:
Data Mining is a technique which aims at obtaining important and useful information in a stockpile of data. This in turn would prove useful in making predictions. It would also inform present decisions.
The Cause and Effect modelling approach explains that for every given action ( effect ), there was a prompting factor ( cause ).
In the case of Sendstars Company, the downward spiral in customer retention was as a result of ill -mannered staff. This effect, prompted the decision to have the employees trained on customer service.
Here are some of the computers used in the first generation of computers:
ENIAC
EDVAC
UNIVAC
IBM-701
IBM-650
These are some of the first computers ever that led to today's computers.
Answer:
SELECT paintname, COUNT(paintname) as count_paintname
FROM paint
GROUP BY paintname HAVING COUNT(paintname) > 2
ORDER BY paintname
Explanation:
The structured query language or SQL statement returns two columns of paintname and the count of the distinct paint names in the paint table with rows of grouped paint names greater than two and in the ascending order of the names.
