Interview Questions

Dimensional modeling is often used in Data warehousing. In simpler words it is a rational or consistent design technique used to build a data warehouse. DM uses facts and dimensions of a warehouse for its design. A snow and star flake schema represent data modeling.

RBI issued currency notes under Fixed Minimum Reserve System.

Asset means anything that can be converted into cash. Here in banks, the loans disbursed by Bank to its customers is considered as assets because when they are cleared by them, then they are directly converted to cash.

 Test scenarios are derived from requirement documents. We follow each and every functionality (called business rules) mentioned in the requirement document. One functionality can have multiple business rules. For example, let us say in there is one requirement called “Login”. This “Login” may have various scenarios. For example, one scenario is, enter the right User ID and wrong password. The system should display an error message. Another scenario would be to enter wrong User ID and right Password. The system should display an error message. The third scenario could be to enter the right User Name and right Password. The system should allow the user to get into the system. This is how the test cases are derived from the requirement documents or from the Use Cases.

When responding to conflict resolution questions, answer with confidence since you're being considered for a supervisory position where you will frequently be required to work in teams, delegate responsibilities, and handle difficult problems.

The following is an effective way to answer conflict resolution questions:

Before proposing a solution, I collect all relevant facts surrounding the conflict. Conflicts are often resolved if sufficient time is devoted to determining root causes, while disregarding trivial or irrelevant facts.

An effective answer can also be supplemented with the following response:

When resolving a problem between employees, I serve as a neutral third party. When needed, I establish rules of conduct. For an organization to operate efficiently, employees must be on the same page. At most organizations, bad feelings exist among some employees, so a manager is responsible for ensuring that employees are placed in situations where they're comfortable to focus on their job responsibilities. In other words, employees must be situated around others they can work with so productivity is not affected.

virtual LAN (VLAN) is any broadcast domain that is partitioned and isolated in a computer network at the data link layer (OSI layer 2). LAN is the abbreviation for local area network and in this context, virtual refers to a physical object recreated and altered by additional logic.

VLANs work by applying tags to network packets and handling these tags in networking systems – creating the appearance and functionality of network traffic that is physically on a single network but acts as if it is split between separate networks. In this way, VLANs can keep network applications separate despite being connected to the same physical network, and without requiring multiple sets of cabling and networking devices to be deployed.

The mapreduce framework contains most of the key architecture principles of cloud computing such as:

- Scale: The framework is able to expand itself in direct proportion to the number of machines available.

- Reliable: The framework is able to compensate for a lost node and restart the task on a different node.

- Affordable: A user can start small and over time can add more hardware.