Combined Bank Senior Officer (IT) — Exam: 13.10.2023 (MIST) | প্রশ্ন ও সমাধান

Written question 1Computer Architecture

Difference between 32 bit Microprocessor and 64 bit Microprocessor with example. What is the meaning of 2.40GHz Microprocessor? Differentiate among Core Intel i3, i5 and i7 processor. Why do you prefer SSD instead of HD?

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 2Computer Architecture

40GHz Microprocessor:

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 3Computer Architecture

Differentiate among CPU register, Cache memory, Main memory and Secondary memory.

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 4Networking

Differentiate among TDM, FDM and WDM. How does working process in TDM?

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 5Networking

What is Topology in data communication? What are differences between Bus, Ring, Tree and Star topology? Purpose of IEEE 802.11 committee.

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 6Cyber Security

What is Cyber Security? Write down the top 10 cyber attack. Discuss about Ransomware and DDoS attack.

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 7Cyber Security

What is Cryptography? Difference between Symmetric and Asymmetric encryption with example. Draw and design public key encryption using Hash function. Draw a diagram for e-commerce online transactions.

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 8Software Engineering

What is platform independent software discuss with example?

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 9Programming

Write a program in any language that takes two matrices A and B as inputs ensure your code handles matrices of different dimensions-

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 10Database

Differentiate among Database, Data Warehouse and Data Mining with real world example.

Model answer

Aspect	Database	Data Warehouse	Data Mining
Purpose	Store & manage day-to-day operational data	Consolidate historical data from many sources for analysis	Discover hidden patterns in stored data
Data type	Current, detailed (OLTP)	Historical, summarized, integrated (OLAP)	Uses warehouse/database data as input
Typical operations	Insert/Update/Delete/Select	Complex read-heavy aggregate queries	Clustering, classification, association-rule algorithms
Update frequency	Real-time/continuous	Periodic batch loads (ETL)	Run periodically over stored data
Real-world example	A bank's core system recording each deposit/withdrawal	The bank's warehouse combining 5 years of branch, customer, and transaction data	Discovering that customers opening FDs in Q4 often apply for a loan within 6 months

graph LR
    OLTP1[("Branch DB 1")] --> ETL["ETL: Extract-Transform-Load"]
    OLTP2[("Branch DB 2")] --> ETL
    OLTP3[("CRM System")] --> ETL
    ETL --> DW[("Data Warehouse")]
    DW --> DM["Data Mining Algorithms"]
    DM --> INS["Business Insights"]

Exam takeaway: a Database records current operational data, a Data Warehouse integrates historical data for analysis, and Data Mining extracts non-obvious patterns from that warehouse — three sequential layers moving from raw data to actionable intelligence.

Written question 11Database

To achieve a '0-bit data loss' for its 24 x 7 x 365 banking operation, what steps or technology should an online bank employ to safeguard its data against any potential threats of data loss?

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 12Database

Discuss different tools and techniques to develop a Business Intelligence Dashboard for a bank. How can data be captured and aggregated from various sources within the bank to monitor the business performance?

Model answer

Building a bank's BI dashboard follows a data value chain from raw operational systems to an executive-ready visualization.

Steps:

Define objectives/KPIs — e.g., customer acquisition, loan approval rate, NPA (non-performing loan) ratio, branch profitability.
Identify data sources — Core Banking System (transactions, balances), CRM (customer interactions), Risk Management System (credit/operational risk), external market data (rates, competitor benchmarks).
ETL (Extract, Transform, Load) — pull data from each source, clean/standardize it, and load it into a common store, using tools like Apache NiFi, Talend, or SSIS.
Data Warehouse/Data Mart — a consolidated, query-optimized store (Snowflake, SQL Server, Redshift).
OLAP/semantic layer — pre-aggregated cubes so dashboards query fast.
Visualization — Power BI, Tableau, or QlikView renders the KPIs as charts/scorecards.
Governance — access control and scheduled refresh keep the dashboard secure and current.

graph LR
    S1[("Core Banking")] --> ETL["ETL Pipeline"]
    S2[("CRM")] --> ETL
    S3[("Risk Mgmt System")] --> ETL
    S4[("External Market Data")] --> ETL
    ETL --> DW[("Data Warehouse")]
    DW --> OLAP["OLAP / Semantic Layer"]
    OLAP --> BI["BI Dashboard"]
    BI --> USR["Executives / Managers"]

Exam takeaway: a BI dashboard's reliability depends far more on a solid ETL + warehouse foundation aggregating disparate core-banking, CRM, and risk data than on the visualization tool itself.

Written question 13Software Engineering

Project management related question (what are the approaches)

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 14Database

Software scenario question- Business Intelligence Model

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 15Bangla

বিজ্ঞানমনস্কতা - নিয়ে একটি রচনা লিখুন।

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 16Cloud & Emerging Tech

What is ChatGPT? Write down the Pros and cons of ChatGPT.

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 17English

Translation ( Bangla to English)

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 18Bangla

Translation ( English to Bangla)

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 19General Knowledge

Who won the Nobel Prize in Physics in 2023?

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 20General Knowledge

Write down the names of new members of BRICS.

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 21General Knowledge

Main Purposes of UNESCO.

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 22General Knowledge

What Is RTGS related to?

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 23General Knowledge

Which city of China, the Asian Olympic be held in 2023?

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 24General ICT

The role of ICT in education sector

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 25English

Bangla to English Translation

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন

Written question 26English

English to Bangla Translation

Sign up free to see the model answer · উত্তর দেখতে বিনামূল্যে সাইন আপ করুন