Informatica MCQ.pdf

Term 2 MCQ Assessment 10 rows of numeric values are present from column B to Column G. Average of the cell range has to be caluated. Choose the cell range to be given for the average calculation in the formula provided =Average(___________) B1;G1...

Term 2 MCQ Assessment 10 rows of numeric values are present from column B to Column G. Average of the cell range has to be caluated. Choose the cell range to be given for the average calculation in the formula provided =Average(___________) B1;G10(0.0) B1-G10(0.0) B1,G10(0.0) B1:G10(1.0) All formula in Excel starts with =(1.0) $(0.0) #(0.0) @(0.0) Which shortcut key used to insert new sheet left to the current sheet? Shft + F11(1.0) Shft + F12(0.0) Shft + F13(0.0) Shft + F14(0.0) What are the total no of rows in excel sheet? 1048576(1.0) 500000(0.0) 1000000(0.0) 1050000(0.0) What are the total no of columns in excel sheet? 16384(1.0) 10000(0.0) 25000(0.0) 50000(0.0) Identify the shortcut in MS Excel to insert new column. Ctrl + Shift + +(1.0) Alt + +(0.0) Ctrl + Alt + V(0.0) Shift + Alt + Col(0.0) Which of the following syntax is correct regarding to SUM function in Excel? SUM(A1-A10)(0.0) SUM(A1+A10)(0.0) SUM(A1:A29)(0.5) SUM(A1,B1,C1)(0.5) Which function in Excel checks whether a condition is true or not ? IF(1.0) Sumif(0.0) Sumifs(0.0) CountIFS(0.0) Where is the source and targer transformationstored? Repository Database(1.0) Repository Server(0.0) Informatica Server(0.0) All of the above(0.0) Which of the following is a best practice for designing mapping?  Using a single data source(0.0) Using a single data transformation tool(0.0) Documenting the mapping design and implementation(1.0) All the above(0.0) The workflow is managed by the Integration Service(1.0) Node(0.0) Domain(0.0) Repository manager(0.0) What are csv files? Flat files(1.0) Relational files(0.0) Cloud files(0.0) Data security files(0.0) What is data transformation in mapping? The process of extracting data from a source system(0.0) The process of loading data into a target system(0.0) The process of modifying data to meet the requirements of the target system(1.0) All the above(0.0) What is the purpose of a source system in mapping? To store the transformed data(0.0) To provide the data to be transformed(1.0) To validate the transformed data(0.0) All the above(0.0) Which of the following is a basic component of mapping in data integration? Source system(0.0) Target system(0.0) Data transformation(0.0) All the above(1.0) What is the main advantage of using a staging area in an ETL process? It allows for easier data cleansing and transformation(0.0) It reduces the risk of data loss or corruption(0.0) It improves data quality by enabling error correction(0.0) It enables faster and more efficient data loading into the target system(1.0) What is the primary purpose of an ETL process in data warehousing? To extract data from various sources and load it into a central data warehouse(1.0) To transform the data to ensure consistency and accuracy(0.0) To create reports and dashboards for end-users(0.0) All of the above(0.0) What is the main objective of the extraction phase of an ETL process? To identify relevant data from source systems(1.0) To clean and filter data for quality assurance(0.0) To transform data into a standardized format(0.0) To load data into a target system(0.0) What is the purpose of data mapping in an ETL process? To identify the relationships between source and target data(1.0) To cleanse and filter data for quality assurance(0.0) To aggregate data from multiple sources(0.0) To load data into a target system(0.0) Which of the following is NOT a best practice for building an ETL process? Documenting the ETL process design and implementation(0.0) Testing and validating the ETL process before deploying it to production(0.0) Using a single ETL tool for all data sources and target systems(1.0) Monitoring the ETL process for errors and performance issues(0.0) What is the primary challenge of building an ETL process? Not Ensuring data quality and consistency(0.0) Managing data privacy and security(1.0) Not Handling large volumes of data(0.0) All the above(0.0) What is the difference between an active and passive Informatica transformation? An active transformation modifies data, while a passive transformation does not(1.0) An active transformation can be connected to a target, while a passive transformation cannot(0.0) An active transformation must be placed downstream of a source qualifier, while a passive transformation can be placed anywhere in a mapping(0.0) All the above(0.0) Which Informatica transformation can be used to create a dynamic lookup cache? Aggregator transformation(0.0) Joiner transformation(0.0) Lookup transformation(1.0) Rank transformation(0.0) What is the rank criteria in rank transformation? Ranks given based on rows(0.0) Ranks given based on columns(1.0) Both A and B(0.0) none(0.0) Sorter transformation can be used on Relational file source(0.0) Flat file source(0.0) Both A and B(1.0) none(0.0) What is the "Distinct" property in the Sorter transformation used for? To generate unique values(1.0) Remove duplicates after sorting(0.0) Remove duplicates before sorting(0.0) none(0.0) What is the default sort order in the Sorter transformation? Ascending(1.0) Descending(0.0) undefined(0.0) none(0.0) Can multiple sort keys be defined in the Sorter transformation? Yes(1.0) No(0.0) May or may not be(0.0) None(0.0) Which transformation is used to exclude duplicate records from a data set in Informatica? Filter(0.0)  Sorter(1.0) Joiner(0.0) Lookup(0.0) Which transformation is used to convert data types in Informatica? Conversion(1.0) Expression(0.0) Sorter(0.0) Filter(0.0) Which transformation is used to update or insert data into a target table in Informatica? Update Strategy(1.0) insert(0.0) update(0.0) delete(0.0) Which transformation is used to compare data from two sources and return matching records in Informatica? Router(0.0) Sorter(0.0) Joiner(1.0) Selector(0.0) Which transformation is used to split data into multiple streams based on specific conditions Router(1.0) Sorter(0.0) Joiner(0.0) Selector(0.0) Which transformation is used to sort data based on one or more columns in Informatica? Sorter(1.0) Filter(0.0) Joiner(0.0) Router(0.0) Which transformation is used to combine data from two or more sources in Informatica? Sequence Generator(0.0) union(1.0) Selection(0.0) Filter(0.0) Which transformation is used to generate unique sequence numbers in Informatica? Sequence Generator(1.0) union(0.0) Selection(0.0) None(0.0) Which of the following is a benefit of using the Power Center Workflow Manager in the Informatica Power Center tool stack? It allows for real-time monitoring of ETL workflows(0.0) It allows for the creation of complex ETL workflows using a graphical user interface.(1.0) It allows for the transformation of data using machine learning algorithms.(0.0) It allows for the creation of reports and dashboards from ETL data.(0.0) Which of the following is NOT a component of the Informatica Power Center tool stack? Power Center Designer(0.0) Power Center Workflow Manager(0.0) Power Center Workflow Monitor(0.0) Power Center Data Loader(1.0) Which of the following is a benefit of using a columnar database for data warehousing?  Faster data retrieval(0.0) Lower storage requirements(1.0) Lower cost(0.0) Higher data compression(0.0) Which of the following is a popular open-source data warehousing platform? Microsoft SQL Server(0.0) Oracle Database(0.0) IBM DB2(0.0) PostgreSQL(1.0) Which of the following is NOT a type of data storage in data warehousing? Relational database(0.0) Multidimensional database(0.0) Columnar database(0.0) None of the above(1.0) What type of sources does informatica support ? Relational(0.0) Flat file source(0.0) XML(0.0) All of the above(1.0) What is the purpose of an ETL tool in data warehousing? To create reports from data stored in a data warehouse(0.0) To manage data backups in a data warehouse(0.0) To extract, transform, and load data into a data warehouse(1.0) To secure data stored in a data warehouse(0.0) Which of the following is NOT a layer in the typical data warehousing architecture? Data source layer(0.0) Data storage layer(0.0) Data access layer(0.0) Data analysis layer(1.0) The default transformation in informatica that comes with every source is Router Transformation(0.0) Joiner transformation(0.0) Oracle Essbase(0.0) Source Qualifier(1.0) What does OLTP stand for? Online Transaction Processing(1.0) Offline Transaction Processing(0.0) Online Transfer Processing(0.0) Online Transaction Production(0.0) What is the Workflow Manager in Informatica PowerCenter Client used for? Creating and managing connections to external data sources(0.0) Designing and configuring ETL workflows(1.0) Managing metadata, user permissions, and system settings(0.0) All the above(0.0) What is the Designer in Informatica PowerCenter Client used for? Creating and managing connections to external data sources(0.0) Designing and configuring ETL workflows(1.0) Managing metadata, user permissions, and system settings(0.0) All the above(0.0) What is the Repository Manager in Informatica PowerCenter Client used for? Creating and managing connections to external data sources(0.0) Designing and configuring ETL workflows(0.0) Managing metadata, user permissions, and system settings(1.0) All the above(0.0) What are the main components of the Informatica PowerCenter Client? Repository Manager(0.0) Workflow Manager(0.0) Workflow Monitor(0.0) All the above(1.0) What is the difference between a data mart and a data warehouse? A data mart is a smaller version of a data warehouse.(0.0) A data warehouse is a subset of a data mart.(0.0) A data mart is designed for a specific business unit or department, while a data warehouse is designed for the entire organization. (1.0) A data warehouse is more expensive to implement than a data mart.(0.0) Which of the following is NOT a key characteristic of a data warehouse? Subject-oriented(0.0) Integrated(0.0) Historical(0.0) Transactional(1.0) What is OLAP in data warehousing Online Analytical Processing used for reporting and analysis(1.0) Online Transaction Processing used for real-time data entry and processing(0.0) Object Linking and Embedding used for integrating data between applications(0.0) None of the above(0.0) What is a data mart? A subset of a data warehouse focused on a particular business function or department(1.0) A tool for real-time data processing and analysis(0.0) A type of database used for storing unstructured data(0.0) All the above(0.0) The repository consists of database tables that store metadata(1.0) tabledata(0.0) domain data(0.0) None of the above(0.0) The PowerCenter repository is a relational database managed by the Repository Service.(1.0) Data Service(0.0) Integrtion Service(0.0) Node Service(0.0) A Domain in informatica represents group of data(0.0) group of nodes and services(1.0) group of only services(0.0) All the above(0.0) What are the special columns in sequence generator transformation Nextval,Fwdval(0.0)  Nextval,Currval(1.0) No such columns(0.0) Oneval,twoval(0.0) What is the main goal of data warehousing? To perform transaction processing in real-time(0.0) To store historical data for reporting and analysis(1.0) To streamline data entry and improve data quality(0.0) All the above(0.0) What is a data warehouse? A collection of databases used for online transaction processing (OLTP)(0.0) A centralized repository of integrated data from one or more disparate sources(1.0) A tool for data mining and predictive analytics(0.0) All the above(0.0)