1What is a primary characteristic that distinguishes a Cloud Database from a traditional on-premise database?
A.It does not support SQL.
B.It requires the user to purchase physical hardware.
C.It is accessed through a cloud platform and often offered as a service.
D.It is always slower than on-premise databases.
Correct Answer: It is accessed through a cloud platform and often offered as a service.
Explanation:
Cloud databases run on cloud computing platforms (like AWS, Azure, GCP) and are typically accessed via the internet, removing the need for local hardware management.
Incorrect! Try again.
2Which financial model is typically associated with Cloud Databases compared to traditional databases?
A.OPEX (Operating Expenditure)
B.Hidden surcharges
C.CAPEX (Capital Expenditure)
D.Fixed annual licensing only
Correct Answer: OPEX (Operating Expenditure)
Explanation:
Cloud databases usually operate on a pay-as-you-go subscription model (OPEX), whereas traditional databases often require upfront hardware and license investment (CAPEX).
Incorrect! Try again.
3What does 'DBaaS' stand for in the context of cloud computing?
A.Digital Backup as a Service
B.Data base and Storage
C.Database Authorization and Security
D.Database as a Service
Correct Answer: Database as a Service
Explanation:
DBaaS stands for Database as a Service, a managed service where the cloud provider handles administrative tasks like patching and backups.
Incorrect! Try again.
4Which of the following is a key benefit of cloud databases regarding resource management?
A.Elasticity
B.Manual hardware replacement
C.Single-point availability
D.Static resource allocation
Correct Answer: Elasticity
Explanation:
Elasticity allows cloud databases to scale resources (compute, storage) up or down automatically or on-demand based on traffic.
Incorrect! Try again.
5In a cloud database environment, who is typically responsible for physical hardware maintenance?
A.The Cloud Service Provider
B.The Database Administrator (DBA)
C.The Network Engineer
D.The End User
Correct Answer: The Cloud Service Provider
Explanation:
The cloud provider (e.g., Amazon, Microsoft, Google) manages the underlying physical infrastructure, power, and cooling.
Incorrect! Try again.
6What is 'Scalability' in the context of cloud databases?
A.The ability to delete data permanently.
B.The process of moving data to a hard drive.
C.The ability to encrypt data at rest.
D.The ability to handle increased workloads by adding resources.
Correct Answer: The ability to handle increased workloads by adding resources.
Explanation:
Scalability is the capability to expand the database's capacity to handle growing amounts of data or user requests.
Incorrect! Try again.
7Which of the following is a potential consideration or challenge when adopting cloud databases?
A.Vendor Lock-in
B.Zero latency guarantees
C.Unlimited free storage
D.Physical server access
Correct Answer: Vendor Lock-in
Explanation:
Vendor lock-in is a risk where moving data or applications to a different provider becomes difficult or expensive due to proprietary technologies.
Incorrect! Try again.
8How does High Availability (HA) typically function in a cloud database?
A.By using a single server to save power.
B.By restricting access to business hours.
C.By replicating data across multiple availability zones or regions.
D.By using tape backups.
Correct Answer: By replicating data across multiple availability zones or regions.
Explanation:
Cloud providers often replicate data across different physical locations (zones/regions) to ensure the database remains accessible even if one data center fails.
Incorrect! Try again.
9Which of the following is a popular NoSQL cloud database provided by Amazon Web Services (AWS)?
A.DB2
B.SQL Server
C.Oracle 12c
D.DynamoDB
Correct Answer: DynamoDB
Explanation:
Amazon DynamoDB is a fully managed, serverless, key-value NoSQL database designed to run high-performance applications at any scale.
Incorrect! Try again.
10What is Google Cloud's fully managed, serverless data warehouse?
A.Snowflake
B.BigQuery
C.Synapse
D.Redshift
Correct Answer: BigQuery
Explanation:
BigQuery is Google Cloud's serverless, highly scalable, and cost-effective multi-cloud data warehouse designed for business agility.
Incorrect! Try again.
11Which Microsoft Azure service acts as a globally distributed, multi-model database service?
A.Azure SQL Database
B.Access Online
C.Azure Blob Storage
D.Cosmos DB
Correct Answer: Cosmos DB
Explanation:
Azure Cosmos DB is a fully managed NoSQL database for modern app development, known for its global distribution and multi-model support.
Incorrect! Try again.
12Snowflake is best described as:
A.A localized ETL tool.
B.An on-premise relational database.
C.A cloud-native data warehouse/platform.
D.A specialized hardware appliance.
Correct Answer: A cloud-native data warehouse/platform.
Explanation:
Snowflake is a Data Cloud platform built specifically for the cloud, separating compute and storage to offer unique scalability.
Incorrect! Try again.
13Which traditional database task is frequently automated in a DBaaS model?
A.Application logic design
B.Query writing
C.Data modeling
D.Software patching and backups
Correct Answer: Software patching and backups
Explanation:
In a DBaaS model, the provider automates routine maintenance tasks like OS patching, database software updates, and backups.
Incorrect! Try again.
14What is 'Data Sovereignty' as a consideration for cloud databases?
A.The legal requirement that data is subject to the laws of the country in which it is located.
B.The format of the database schema.
C.The speed of data transfer.
D.The ownership of the cloud hardware.
Correct Answer: The legal requirement that data is subject to the laws of the country in which it is located.
Explanation:
Data sovereignty refers to jurisdictional control; organizations must ensure their cloud data resides in specific regions to comply with local laws (e.g., GDPR).
Incorrect! Try again.
15The 'Shared Responsibility Model' in cloud security implies that:
A.Security obligations are divided between the provider and the customer.
B.The provider handles all security aspects.
C.Security is optional.
D.The user handles all security aspects.
Correct Answer: Security obligations are divided between the provider and the customer.
Explanation:
The provider secures the infrastructure (security 'of' the cloud), while the customer secures the data and access (security 'in' the cloud).
Incorrect! Try again.
16Which of the following describes 'Horizontal Scaling' (Sharding) in cloud databases?
A.Deleting old data to make space.
B.Switching to a newer database version.
C.Adding more machines/nodes to the pool of resources.
D.Adding more CPU and RAM to a single machine.
Correct Answer: Adding more machines/nodes to the pool of resources.
Explanation:
Horizontal scaling involves adding more servers to distribute the load, which is a common pattern in cloud architectures.
Incorrect! Try again.
17Which factor is generally considered a 'feature' rather than a 'drawback' of cloud databases?
A.Unknown data location
B.Latency due to internet connection
C.Rapid provisioning
D.Reliance on internet connectivity
Correct Answer: Rapid provisioning
Explanation:
Rapid provisioning is a benefit, allowing developers to spin up a database instance in minutes rather than waiting weeks for hardware procurement.
Incorrect! Try again.
18What is 'Master Data'?
A.Temporary cache data.
B.Core business entities used repeatedly across the organization (e.g., Customer, Product).
C.Log files generated by servers.
D.Transactional data created every second (e.g., sales receipts).
Correct Answer: Core business entities used repeatedly across the organization (e.g., Customer, Product).
Explanation:
Master data represents the 'nouns' of a business—essential non-transactional data like customers, products, employees, and suppliers.
Incorrect! Try again.
19Which of the following is NOT typically classified as Master Data?
A.Product SKU
B.Sales Transaction Timestamp
C.Employee ID
D.Customer Address
Correct Answer: Sales Transaction Timestamp
Explanation:
A sales transaction timestamp is transactional data (an event), whereas Master Data describes the entities involved in the event.
Incorrect! Try again.
20What problem does Master Data Management (MDM) primarily aim to solve?
A.Lack of storage space.
B.Data silos and inconsistent data versions across the enterprise.
C.Hardware failure rates.
D.Slow internet speeds.
Correct Answer: Data silos and inconsistent data versions across the enterprise.
Explanation:
MDM addresses the issue of fragmented data where different departments hold conflicting or duplicate information about the same entity.
Incorrect! Try again.
21What is the 'Golden Record' in MDM?
A.The first record entered into the system.
B.The single, trusted, and consolidated version of an entity.
C.The most expensive record in the database.
D.A backup record.
Correct Answer: The single, trusted, and consolidated version of an entity.
Explanation:
The Golden Record is the result of cleaning, matching, and merging data from multiple sources to create a single source of truth.
Incorrect! Try again.
22Why is managing Master Data critical for Business Intelligence (BI)?
A.It removes the need for visualization tools.
B.It automates SQL queries.
C.It increases the size of the data warehouse.
D.It ensures reports are based on accurate and consistent definitions of business entities.
Correct Answer: It ensures reports are based on accurate and consistent definitions of business entities.
Explanation:
Without MDM, BI reports may show conflicting numbers (e.g., total customer count) depending on which system provides the data.
Incorrect! Try again.
23Which of the following is a key function of an MDM solution?
A.Data Deduplication
B.Network routing
C.Hardware virtualization
D.Virus scanning
Correct Answer: Data Deduplication
Explanation:
Deduplication is a core MDM function that identifies and merges duplicate records referring to the same entity.
Incorrect! Try again.
24What is 'Data Stewardship' in the context of MDM?
A.The responsibility for maintaining data quality, security, and usage policies.
B.Writing code for the database kernel.
C.Selling data to third parties.
D.The physical storage of backup tapes.
Correct Answer: The responsibility for maintaining data quality, security, and usage policies.
Explanation:
Data Stewards are individuals or teams responsible for ensuring the master data remains accurate, consistent, and governed.
Incorrect! Try again.
25How does MDM support a 'Customer 360' view?
A.By deleting old customer data.
B.By aggregating all data points related to a customer from various systems into one view.
C.By asking the customer to re-enter their data.
D.By rotating the monitor 360 degrees.
Correct Answer: By aggregating all data points related to a customer from various systems into one view.
Explanation:
MDM consolidates data from sales, support, marketing, and billing to provide a complete, holistic view of the customer relationship.
Incorrect! Try again.
26Which architecture style involves leaving master data in source systems and creating a central index?
A.Transaction Style
B.Registry Style
C.Consolidation Style
D.Centralized Style
Correct Answer: Registry Style
Explanation:
The Registry style creates a central index that points to the master data in various source systems without moving the full physical records to a central hub.
Incorrect! Try again.
27What is 'Reference Data' in relation to MDM?
A.Data that changes every second.
B.Random numbers.
C.User passwords.
D.Standardized values used to categorize other data (e.g., Country codes, Currencies).
Correct Answer: Standardized values used to categorize other data (e.g., Country codes, Currencies).
Explanation:
Reference data defines the set of permissible values to be used by other data fields, ensuring consistency (e.g., using 'USA' instead of 'U.S.', 'US', 'America').
Incorrect! Try again.
28Which is a benefit of MDM during Mergers and Acquisitions (M&A)?
A.It lowers the stock price.
B.It prevents the merger.
C.It increases the number of employees.
D.It speeds up the integration of disparate IT systems and customer lists.
Correct Answer: It speeds up the integration of disparate IT systems and customer lists.
Explanation:
MDM facilitates the mapping and merging of customer and product data from the acquiring and acquired companies.
Incorrect! Try again.
29What does 'Survivorship' mean in MDM?
A.Rules determining which data value is kept when merging conflicting records.
B.The backup retention policy.
C.How long a record stays in the database.
D.The ability of the server to survive a power outage.
Correct Answer: Rules determining which data value is kept when merging conflicting records.
Explanation:
Survivorship rules dictate which attribute value (e.g., the phone number from the CRM vs. the Billing system) wins and populates the Golden Record.
Incorrect! Try again.
30In the context of Master Data, what is 'volatility'?
A.How dangerous the data is.
B.The speed of the processor.
C.The cost of storing the data.
D.How often the data changes.
Correct Answer: How often the data changes.
Explanation:
Master data typically has low volatility (it changes infrequently) compared to transactional data.
Incorrect! Try again.
31Which of the following is a leading cloud provider for MDM solutions (Informatica context)?
Informatica offers cloud-native master data management solutions as part of its Intelligent Data Management Cloud.
Incorrect! Try again.
32What is the relationship between Data Quality and MDM?
A.MDM relies on Data Quality tools to clean data before or during the mastering process.
B.They are unrelated.
C.Data Quality creates duplicates for MDM.
D.MDM replaces the need for quality.
Correct Answer: MDM relies on Data Quality tools to clean data before or during the mastering process.
Explanation:
You cannot have reliable Master Data without Data Quality processes (profiling, cleansing, standardization) to ensure the inputs are correct.
Incorrect! Try again.
33A key benefit of Cloud Databases over traditional ones regarding 'Global Reach' is:
A.Ability to deploy regions worldwide with a few clicks.
B.Exemption from international laws.
C.Free shipping of hardware.
D.Lower latency for local-only users.
Correct Answer: Ability to deploy regions worldwide with a few clicks.
Explanation:
Cloud providers have data centers globally, allowing businesses to deploy databases near their users anywhere in the world instantly.
Incorrect! Try again.
34Multi-tenancy in cloud databases refers to:
A.One user having multiple passwords.
B.One database storing multiple data types.
C.A tenant paying rent to the database administrator.
D.Multiple customers sharing the same underlying computing resources while keeping data isolated.
Correct Answer: Multiple customers sharing the same underlying computing resources while keeping data isolated.
Explanation:
Multi-tenancy is a cloud architecture where a single instance of software serves multiple customers (tenants), providing cost efficiency.
Incorrect! Try again.
35Which type of Master Data would include 'Supplier' information?
A.Party / Customer Data domain
B.Asset Data domain
C.Product Data domain
D.Location Data domain
Correct Answer: Party / Customer Data domain
Explanation:
Suppliers are typically categorized under 'Party' data (individuals or organizations involved with the business).
Incorrect! Try again.
36What is 'Hierarchy Management' in MDM?
A.Prioritizing tasks.
B.Sorting data alphabetically.
C.Defining and managing relationships between data records (e.g., Parent-Child companies).
D.Managing the org chart of the IT team.
Correct Answer: Defining and managing relationships between data records (e.g., Parent-Child companies).
Explanation:
Hierarchy management handles complex relationships, such as corporate families, bill-to/ship-to relationships, or product categories.
Incorrect! Try again.
37The 'Hub' style of MDM architecture implies:
A.A connection only to the internet.
B.A read-only database.
C.A centralized repository holding the golden copy of master data.
D.A decentralized network of spreadsheets.
Correct Answer: A centralized repository holding the golden copy of master data.
Explanation:
In the Hub style, master data is consolidated into a central repository which synchronizes with source systems.
Incorrect! Try again.
38What is a risk of NOT implementing MDM?
A.Faster decision making.
B.Reduced storage costs.
C.Too much consistency.
D.Operational inefficiencies and poor customer service due to fragmented data.
Correct Answer: Operational inefficiencies and poor customer service due to fragmented data.
Explanation:
Without MDM, staff waste time reconciling data, shipments go to wrong addresses, and customers get duplicate marketing, leading to inefficiency.
Incorrect! Try again.
39Which feature of cloud databases helps in Disaster Recovery?
A.Manual tape backups.
B.Point-in-time recovery and geo-replication.
C.Local hard drive storage.
D.Single availability zone deployment.
Correct Answer: Point-in-time recovery and geo-replication.
Explanation:
Cloud databases offer automated backups that allow restoring to a specific moment and replicating data to geographically distant centers.
Incorrect! Try again.
40When migrating to a cloud database, 'Lift and Shift' refers to:
A.Physically moving servers.
B.Only moving the data, not the application.
C.Moving the application and database to the cloud with minimal changes.
D.Rewriting the application from scratch.
Correct Answer: Moving the application and database to the cloud with minimal changes.
Explanation:
Lift and Shift (Rehosting) involves moving the existing stack to the cloud infrastructure without redesigning it for cloud-native features.
Incorrect! Try again.
41Master Data Governance refers to:
A.The strategic framework, policies, and roles ensuring data is managed as an asset.
B.The hardware specs for the MDM server.
C.The software installation process.
D.The speed of the network.
Correct Answer: The strategic framework, policies, and roles ensuring data is managed as an asset.
Explanation:
Governance is the 'people and process' side of MDM, defining who owns the data and the rules for maintaining it.
Incorrect! Try again.
42What distinguishes 'Analytical' MDM from 'Operational' MDM?
A.Analytical is faster.
B.There is no difference.
C.Operational is cheaper.
D.Analytical is for reporting/BI; Operational is for real-time transaction support.
Correct Answer: Analytical is for reporting/BI; Operational is for real-time transaction support.
Explanation:
Operational MDM feeds clean data back to source systems for daily ops, while Analytical MDM feeds data warehouses for analysis.
Incorrect! Try again.
43Which of the following is an example of 'Location' master data?
A.A GPS coordinate of a moving truck.
B.A dynamic IP address.
C.A standardized Warehouse Address.
D.A flight path.
Correct Answer: A standardized Warehouse Address.
Explanation:
Fixed physical locations like warehouses, stores, or headquarters are considered Location Master Data.
Incorrect! Try again.
44Cost savings in cloud databases are primarily achieved through:
A.Eliminating the need for upfront capital investment and paying only for usage.
B.Using older hardware.
C.Reducing data quality.
D.Firing all DBAs.
Correct Answer: Eliminating the need for upfront capital investment and paying only for usage.
Explanation:
The 'Pay-as-you-go' model and the removal of data center maintenance costs are the primary drivers of cost savings.
Incorrect! Try again.
45What is 'Fuzzy Matching' in MDM?
A.Randomly connecting records.
B.Matching based on probable likeness (e.g., 'Jon' vs 'John').
C.Matching images.
D.Matching based on exact spelling only.
Correct Answer: Matching based on probable likeness (e.g., 'Jon' vs 'John').
Explanation:
Fuzzy matching algorithms identify potential duplicates that are not identical character-for-character but represent the same entity.
Incorrect! Try again.
46What is a 'Silo' in data management?
A.A backup drive.
B.A secure storage vault.
C.A type of cloud database.
D.A collection of data held by one group that is not easily accessible by other groups.
Correct Answer: A collection of data held by one group that is not easily accessible by other groups.
Explanation:
Data silos occur when departments run separate systems that don't talk to each other, preventing a unified view of the business.
Incorrect! Try again.
47Cloud Database 'Serverless' architecture means:
A.There are no servers involved at all.
B.It is free.
C.The database runs on the client's computer.
D.The developer does not have to manage or provision the servers.
Correct Answer: The developer does not have to manage or provision the servers.
Explanation:
Serverless doesn't mean no servers exist; it means the cloud provider abstracts the server management entirely from the user.
Incorrect! Try again.
48The primary goal of 'Data Enrichment' in MDM is to:
A.Make the data file larger.
B.Encrypt the data.
C.Translate the data.
D.Enhance internal data with external 3rd party data (e.g., D&B credit scores).
Correct Answer: Enhance internal data with external 3rd party data (e.g., D&B credit scores).
Explanation:
Enrichment adds value to master records by appending missing information from trusted external sources.
Incorrect! Try again.
49Which cloud service model does a standard installation of Oracle Database on an AWS EC2 instance represent?
A.IaaS (Infrastructure as a Service)
B.PaaS (Platform as a Service)
C.SaaS (Software as a Service)
D.DaaS (Data as a Service)
Correct Answer: IaaS (Infrastructure as a Service)
Explanation:
Running your own database software on a raw virtual machine (like EC2) is Infrastructure as a Service; you manage the OS and DB, the provider manages the hardware.
Incorrect! Try again.
50In the context of Informatica and MDM, what is the role of 'Metadata'?
A.It is the data about the data (definitions, lineage, rules).
B.It is the user interface.
C.It is the financial report.
D.It is the transactional data.
Correct Answer: It is the data about the data (definitions, lineage, rules).
Explanation:
Metadata is crucial in MDM for defining the structure, constraints, source systems, and transformation rules for the master data.
Incorrect! Try again.
Did this save you a night before the exam?
LPU Notes is free, and it stays free. Ads cover part of the server bill.
The rest comes out of a student's own pocket: the domain, the storage,
and keeping the site up through the weeks everyone needs it at once.
The payment button didn't load. An ad blocker or a filtered network is the usual reason.
to try again.
Nothing here is ever locked, and nothing unlocks. Chip in only if it was worth it.
What it pays for →