MauryaHub PYQ Practice

Business Data Management · End Term · Jan 2023 · AN

Business Data Management · End Term · Jan 2023 AN

← Course papers · Start practice / exam

Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.

0 / 20 published solutions

Question 218 MCQ · 1.0 marks

From the converted csv file in previous question , you realize that the team ‘Delhi Daredevil’ has changed its name to ‘Delhi Capital’. Using excel, you wish to replace the old name with a new name. It can be done in Excel using
A.
Find and Replace
B.
Finding and Replacing
C.
Replace and Find
D.
Search and Replace       **BDM** **Section Id :** 64065338405 **Section Number :** 8 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 16 **Number of Questions to be attempted :** 16 **Section Marks :** 40 **Display Number Panel :** Yes **Group All Questions :** No **Enable Mark as Answered Mark for Review and** Yes **Clear Response :** **Maximum Instruction Time :** 0

A published solution is not available for this question yet.

Report a correction for Q218

Question 220 MCQ · 2.0 marks

Which of the following best describes the churn rate?
A.
The number of new customers acquired in a given period
B.
The percentage of customers who stop using a product or service in a given period
C.
The amount of money earned from a customer in a given period
D.
The cost of acquiring a new customer

A published solution is not available for this question yet.

Report a correction for Q220

Question 221 MCQ · 2.0 marks

Which of the following goods is likely to have the lowest marginal utility?
A.
A necessity good.
B.
A luxury good.
C.
A good that the consumer has never tried before.
D.
A good that the consumer has consumed many times before.

A published solution is not available for this question yet.

Report a correction for Q221

Question 222 MCQ · 2.0 marks

When does marginal utility become negative?
A.
When a consumer consumes the first unit of a good.
B.
When the total utility of a good is zero.
C.
When the total utility of a good is at its maximum.
D.
When the consumer reaches the point of overconsumption.

A published solution is not available for this question yet.

Report a correction for Q222

Question 223 MCQ · 2.0 marks

If the price of a product increases by 20% and the quantity demanded decreases by 10%, what is the price elasticity of demand?
A.
2
B.
0.5
C.
1
D.
1.5

A published solution is not available for this question yet.

Report a correction for Q223

Question 224 MCQ · 2.0 marks

The current ratio is a measure of:
A.
A company's ability to pay its long-term debt obligations.
B.
A company's liquidity and short-term solvency.
C.
A company's ability to generate profits.
D.
A company's efficiency in managing its inventory.

A published solution is not available for this question yet.

Report a correction for Q224

Question 225 MCQ · 2.0 marks

A Company has current assets of $750,000 and current liabilities of $250,000. What is the current ratio of the company?
A.
3
B.
1
C.
1.5
D.
0.33

A published solution is not available for this question yet.

Report a correction for Q225

Question 226 MCQ · 2.0 marks

A/B testing is used for:
A.
Measuring the churn rate of a product
B.
Comparing two versions of a product to determine which one performs better
C.
Increasing the price of a product to maximize revenue
D.
Reducing the number of features of a product to make it simpler

A published solution is not available for this question yet.

Report a correction for Q226

Question 227 MCQ · 2.0 marks

Consider the following graphical representation of the Average of Credit Scores of Approved and Declined Credit Applications. Which of the following statements stands TRUE?
Source diagram or notation
Statement A: The average of Credit Scores of customers getting declined remains more or less constant throughout the months Statement B: Average Credit Scores of customers getting approved have increased over time Statement C: Average Credit Scores of customers getting approved have decreased over time Statement D: Grand Total Average has no correlation with whether the decline rate reduces or increases
A.
Statements A, B, and D are TRUE
B.
Statements A, C, and D are TRUE
C.
Only Statement C is TRUE, and A being TRUE is ambiguous.
D.
Both Statements A and C are true

A published solution is not available for this question yet.

Report a correction for Q227

Question 228 MCQ · 2.0 marks

Consider the following graph representing the volume sales through an E-Commerce run distribution center through 15 days. Which among the following explains Thursday's volume being more than the rest of the days?
Source diagram or notation
Statement 1 : There was a Black Friday sale on Thursday Statement 2 : It’s possible that Thursday’s data is the only day occouring thrice among in the 15 day data Statement 3 : It is not possible to judge trends with this less information Statement 4 : One of the thursdays could be a public holiday/ online sale festival day
A.
Statement 1 is correct
B.
Statements 1,2,4 are correct
C.
Statements 2,4 are correct
D.
Statement 3 is correct

A published solution is not available for this question yet.

Report a correction for Q228

Question 229 MCQ · 2.0 marks

There is a column containing multiple courses a student has registered for like “BDM, TDS, BA, Python, English II” How can you separate these courses/words into distinct cells like this:
Source diagram or notation
A.
Use the "Split" function in Excel/Google Sheets.
B.
Use the "Find and Replace" feature in Excel/Google Sheets.
C.
Use the "Wrap Text" feature in Excel/Google Sheets.
D.
Use the "Text to Columns" feature in Excel/Google Sheets.

A published solution is not available for this question yet.

Report a correction for Q229

Question 230 MCQ · 2.0 marks

Consider the following screenshot. Which among the following will be the correct syntax to put in the formula box for cell I2? Consider a situation where the company takes 2.5% as a commission on all application amounts for processing the application.
Source diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q230

Question 231 NAT · 2.0 marks

Calculate the given subquestion for Gear Broaching Process for Week 1
Source diagram or notation
Availability - _______% (upto one decimal point)

A published solution is not available for this question yet.

Report a correction for Q231

Question 232 NAT · 2.0 marks

Calculate the given subquestion for Gear Broaching Process for Week 1
Source diagram or notation
Performance ________% (upto one decimal point)

A published solution is not available for this question yet.

Report a correction for Q232

Question 233 NAT · 2.0 marks

Calculate the given subquestion for Gear Broaching Process for Week 1
Source diagram or notation
Quality ________% (upto one decimal point)

A published solution is not available for this question yet.

Report a correction for Q233

Question 234 NAT · 2.0 marks

Calculate the given subquestion for Gear Broaching Process for Week 1
Source diagram or notation
OEE _______ (Enter a number between 0 and 1 up to 3 decimal places)

A published solution is not available for this question yet.

Report a correction for Q234

Question 235 NAT · 2.0 marks

Answer the given subquestions concerning the Hobbing process of gear manufacturing.
Source diagram or notation
Total Output of Gear casts after Hobbing: 2600. Cost of Hobbing: INR 33 per Gear cast, Raw Material Cost: INR 37 per Gear Cast
Scrap Percentage after broaching process_______________%

A published solution is not available for this question yet.

Report a correction for Q235

Question 236 NAT · 2.0 marks

Answer the given subquestions concerning the Hobbing process of gear manufacturing.
Source diagram or notation
Total Output of Gear casts after Hobbing: 2600. Cost of Hobbing: INR 33 per Gear cast, Raw Material Cost: INR 37 per Gear Cast
Loss due to scrap after broaching_______________

A published solution is not available for this question yet.

Report a correction for Q236

Question 237 MCQ · 3.0 marks

Consider the following dataset:
Source diagram or notation
Here all the factors are “more the better” . You can combine all the criteria as : Composite Score= Sum of all criteria on the same scale Rank the above candidates and choose the correct ranking from the below options
A.
Alpha > Tango > Gamma > Beta
B.
Gamma > Tango > Beta> Alpha
C.
Alpha < Gamma < Tango < Beta
D.
Gamma < Tango < Beta< Alpha

A published solution is not available for this question yet.

Report a correction for Q237

Question 238 MCQ · 3.0 marks

Consider the following Volume Sales Data for 4 different SKUs. Analyze and interpret - which of the following datasets qualifies the Volume Pareto criteria?
Source diagram or notation
A.
A
B.
B
C.
C
D.
D       **System Commands** **Section Id :** 64065338406 **Section Number :** 9 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 14 **Number of Questions to be attempted :** 14 **Section Marks :** 100

A published solution is not available for this question yet.

Report a correction for Q238