Question
If the price of wheat rises by 40%, how much percentage
reduction in consumption is required so that the total expense remains constant?Give your answer rounded to the nearest integer.Solution
ATQ,
Initial price = Rs. 100m, consumption = n kg
Initial expenditure = 100mn
New price = 140m
New consumption = 100mn ÷ 140m = 100n ÷ 140
Decrease = n - (100n ÷ 140) = 40n ÷ 140
Required percent = (40n ÷ 140) ÷ n × 100 = 4000 ÷ 140 ≈ 29%
Which of the following best defines the concept of the "Internet of Things" (IoT)?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Data warehouse metadata primarily describes:
Which type of slowly changing dimension (SCD) preserves full history by adding a new row for each change and using effective date ranges?
Which of these is NOT an ensemble method?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
Which OLAP operation involves focusing on a subset of dimensions (e.g., region=‘Asia’)?
ETL stands for:
Which SQL keyword is used to combine results from two queries and remove duplicates?
Data cleansing is primarily concerned with: