1.
I am a part of Biztalk Team :)
Correct Answer
A. Aditya Agrawal
Explanation
The given answer "Aditya Agrawal" is the correct answer because the question states that the person is a part of the Biztalk Team, and Aditya Agrawal is mentioned as one of the members of the team.
2.
Technologies which are part of the Middleware Team are:
Correct Answer(s)
A. WAS
B. Control M
D. Informatica
Explanation
The correct answer includes the technologies that are part of the Middleware Team, which are WAS (WebSphere Application Server), Control M, and Informatica. These technologies are commonly used in middleware architecture to facilitate communication and integration between different applications and systems. WAS is a popular application server that provides a runtime environment for Java-based applications. Control M is a workload automation tool used for scheduling and managing batch jobs. Informatica is a data integration and management software used for ETL (Extract, Transform, Load) processes.
3.
PRINCE BABU has a requirement to schedule a task at some specific time which sends notification of failure and has zero downtime . Which tool should PRINCE BABU select ?
Correct Answer
C. CONTROL M
Explanation
PRINCE BABU should select CONTROL M because it is a tool that allows for scheduling and automating tasks. It is known for its reliability and ability to handle complex job dependencies. With CONTROL M, PRINCE BABU can schedule the task at the specific time and ensure that notifications of failure are sent promptly. Additionally, CONTROL M is designed to minimize downtime, making it a suitable choice for PRINCE BABU's requirement of zero downtime.
4.
Who is the product owner of Biztalk in FIL?
Correct Answer
D. PANKAJ NEGI
Explanation
Pankaj Negi is the product owner of Biztalk in FIL.
5.
Who is the product owner of Informatica in FIL?
Correct Answer
B. PRAVEEN KUMAR
Explanation
Praveen Kumar is the product owner of Informatica in FIL.
6.
Which middleware tool is name of a famous shoe brand?
Correct Answer
C. LIBERTY
Explanation
LIBERTY is the correct answer because it is the name of a famous shoe brand. The other options, LANCER, ACTION, and ROCKPORT, are not well-known shoe brands.
7.
What does M stands for in Control M ?
Correct Answer
D. MISSION
Explanation
The letter "M" in Control M stands for "MISSION". Control M is a workload automation software that allows organizations to automate and manage their batch and real-time workflows. The term "MISSION" suggests that Control M is designed to help organizations accomplish their goals and objectives efficiently and effectively.
8.
Informatica connects to below databases for ETL:
Correct Answer
D. All of the above
Explanation
The correct answer is "All of the above" because Informatica is a powerful ETL (Extract, Transform, Load) tool that can connect to multiple databases for data integration. It supports various database platforms including Oracle, DB2, and Sybase, allowing users to extract data from these databases, transform it according to their requirements, and load it into the target system. Therefore, the statement "All of the above" accurately represents the databases that Informatica can connect to for ETL purposes.
9.
Which of them is a Data-Warehousing tool:
Correct Answer
C. Informatica
Explanation
Informatica is a data-warehousing tool used for extracting, transforming, and loading data from various sources into a data warehouse. It provides a comprehensive platform for managing and integrating data to support business intelligence and analytics. With its features like data profiling, data quality management, and data integration, Informatica is widely used in organizations for data warehousing purposes.
10.
Which of them are Informatica artefacts:
Correct Answer
D. All of the above
Explanation
All of the options listed (Workflow, Mapping, and Mapplets) are Informatica artifacts. Informatica is a data integration and management software that uses these artifacts to design and execute data integration processes. Workflows are used to define the sequence of tasks and transformations, mappings are used to define the transformation logic for data, and mapplets are reusable transformation objects that can be used in multiple mappings. Therefore, all three options are valid Informatica artifacts.
11.
Informatica can loads the data into the following:
Correct Answer
D. All of the above
Explanation
Informatica is a data integration tool that can load data into various destinations. It supports loading data into flat files, relational tables, and XML files. Therefore, the correct answer is "All of the above" as Informatica can load data into all these types of destinations.
12.
Which Informatica transformation is used to combine data from different sources?
Correct Answer
A. Joiner
Explanation
The Joiner transformation in Informatica is used to combine data from different sources. It allows you to join two or more sources based on a common key and retrieve data from all the joined sources into a single output. By using the Joiner transformation, you can merge data from multiple tables or files that have related columns. This transformation is commonly used in data integration scenarios where data from multiple sources needs to be combined for further processing or analysis.
13.
OLAP stands for?
Correct Answer
B. On-Line Analytical Processing
Explanation
OLAP stands for On-Line Analytical Processing. This term refers to a technology used in data analysis and reporting, particularly in business intelligence systems. It allows users to perform complex queries, multidimensional analysis, and data mining on large datasets. OLAP enables users to gain insights from data by providing a flexible and interactive environment for exploring and analyzing data from different perspectives. It is commonly used in decision-making processes and strategic planning in various industries.
14.
What does QPASA mean in Spanish?
Correct Answer
A. What's up?
Explanation
The correct answer is "what's up?" because QPASA is a slang abbreviation in Spanish that stands for "¿Qué pasa?", which translates to "What's up?" in English. It is commonly used as a casual greeting to ask someone how they are doing or to initiate a conversation.
15.
Which middleware platform is hosting Debit Card Authorisation system?
Correct Answer
A. TLG HSM
Explanation
The correct answer is TLG HSM. TLG HSM stands for Transaction Link Gateway Hardware Security Module, which is a middleware platform used for hosting the Debit Card Authorisation system. It provides secure storage and processing of sensitive data related to debit card transactions, ensuring the confidentiality and integrity of the information.
16.
Which products are used in Fil File Transfer Service Interval?
Correct Answer
D. All
Explanation
All of the mentioned products (GoAnywhere Director, GoAnywhere Services, and GoAnywhere Gateway) are used in the Fil File Transfer Service Interval.
17.
Is Fil File Transfer Service PCI Compliant?
Correct Answer
A. True
Explanation
Fil File Transfer Service is PCI compliant. This means that it meets the requirements set by the Payment Card Industry Data Security Standard (PCI DSS) for securely handling credit card information. Being PCI compliant ensures that the service has implemented necessary security measures to protect sensitive cardholder data during transmission and storage.
18.
BizTalk middleware can be installed on below OS:
Correct Answer
A. Windows
Explanation
BizTalk middleware can be installed on Windows operating system. It is not compatible with Unix or IOS operating systems.
19.
MQ middleware can be installed on below OS :
Correct Answer
C. Both
Explanation
The MQ middleware can be installed on both Windows and Unix operating systems. This means that users have the flexibility to choose either of these operating systems to install and use the MQ middleware. The middleware is not compatible with the IOS operating system, so it cannot be installed on IOS devices.
20.
Which tool monitors MQ?
Correct Answer
B. QPASA
Explanation
QPASA is a tool that stands for Queue Performance and Availability System for MQ. It is specifically designed to monitor and manage IBM MQ environments. It provides real-time monitoring of queue performance and availability, allowing administrators to proactively identify and resolve any issues that may arise. Therefore, QPASA is the correct answer for the tool that monitors MQ.
21.
Which tool monitors BizTalk?
Correct Answer
A. BizTalk360
Explanation
BizTalk360 is the correct answer because it is a tool specifically designed to monitor BizTalk. It provides a comprehensive set of features and functionalities to monitor and manage BizTalk environments effectively. It offers real-time monitoring, alerts, dashboards, and analytics to ensure the smooth functioning of BizTalk applications and integration processes. With its user-friendly interface and extensive monitoring capabilities, BizTalk360 is widely used by organizations to monitor and optimize their BizTalk environments.
22.
BizTalk's backend database is..
Correct Answer
A. MS SQL
Explanation
The correct answer is MS SQL because BizTalk, a Microsoft integration and connectivity server, is primarily designed to work with Microsoft technologies. MS SQL is a relational database management system developed by Microsoft, making it the most compatible and commonly used backend database for BizTalk.
23.
QPASA's backend database is..
Correct Answer
B. Oracle
Explanation
The backend database for QPASA is Oracle.
24.
Is a database prerequisite for MQ or WMB?
Correct Answer
B. False
Explanation
A database is not a prerequisite for MQ or WMB. MQ (Message Queue) and WMB (WebSphere Message Broker) are middleware technologies used for messaging and integration purposes. They facilitate the exchange of messages between different applications and systems. While a database can be used to store and retrieve data, it is not a mandatory requirement for the functioning of MQ or WMB. These technologies can operate independently of a database and can be used to integrate systems that may or may not involve a database.
25.
Latest Websphere application server version :
Correct Answer
B. 8.5.5.X
Explanation
The correct answer is 8.5.5.X because it is the latest version mentioned in the given options. The other versions mentioned are either older or not the latest.
26.
Websphere supports which all database:
Correct Answer
D. All
Explanation
Websphere supports all types of databases, including Oracle, Db2, and SQL. This means that Websphere can be integrated with any of these databases, allowing users to easily connect and interact with their preferred database system. This flexibility makes Websphere a versatile platform for database management and integration, as it can accommodate various database technologies based on user requirements.
27.
Websphere Application Server is a flagship product within ______’s brand:
Correct Answer
C. IBM
Explanation
Websphere Application Server is a flagship product within IBM's brand.
28.
What’s the scripting tool available with Websphere Application Server ?
Correct Answer
B. Wsadmin
Explanation
Wsadmin is the scripting tool available with Websphere Application Server. It is a command-line tool that allows administrators to automate administrative tasks, configure server settings, and manage applications deployed on the server. Wsadmin provides a scripting language that allows users to write scripts to perform these tasks. It is a powerful tool that helps streamline administration and improve efficiency in managing Websphere Application Server.
29.
1) Queue : Is point – to – point communication and2) topic is publish-subscriber communicationChoose correct answer :
Correct Answer
A. Both 1) and 2) are correct
Explanation
Both 1) and 2) are correct because a queue is a point-to-point communication mechanism where messages are sent from a single sender to a single receiver, while a topic is a publish-subscriber communication mechanism where messages are published by a sender and received by multiple subscribers who are interested in that topic. Therefore, both options accurately describe the characteristics of queues and topics.