Infosys Oracle SCM Functional Consultant Interview Questions, Process, and Tips

Azure PaaS services are cloud-based services that allow developers to build, deploy, and manage applications without having to manage the underlying infrastructure.

• Examples include Azure App Service, Azure Functions, Azure SQL Database, Azure Cosmos DB, and Azure Event Grid.

• Azure App Service allows developers to build and deploy web and mobile apps.

• Azure Functions is a serverless compute service that allows developers ...read more

Storage Queue, Service Bus Queue, Event Hub, IoT Hub, and Event Grid are different messaging services in Azure.

• Storage Queue is a simple message queue for reliable messaging between components within an application.

• Service Bus Queue is a fully-featured messaging service for decoupling applications and enabling reliable communication.

• Event Hub is a big data streaming platform for ingesting and processing large volumes o...read more

Designing Azure architecture using VM, VNet, and Load Balancers involves creating virtual machines, virtual networks, and load balancers to ensure scalability, availability, and performance.

• Start by creating a virtual network (VNet) to establish a private network in Azure.

• Create virtual machines (VMs) within the VNet to host your applications and services.

• Configure load balancers to distribute incoming traffic across m...read more

I know that the company is a leading consulting firm known for its innovative solutions. Regarding compensation, I am aware of the competitive salary and benefits package offered.

• The company is known for its innovative solutions in the consulting industry

• They have a strong reputation for delivering high-quality services to clients

• I am aware that the compensation package includes competitive salary and benefits

• The compa...read more

IAM major components are authentication, authorization, and identity management.

• Authentication: verifying the identity of a user or system

• Authorization: granting access to resources based on user roles and permissions

• Identity management: managing user identities and their access to resources

• Examples: Single Sign-On (SSO), Multi-Factor Authentication (MFA), Role-Based Access Control (RBAC)

OLAP in IDT and UDT and generating reports without universe

• OLAP can be used in both IDT and UDT for data analysis

• Reports can be generated without a universe using OLAP

• OLAP allows for multidimensional analysis of data

HANA, ERP, and BW are all data sources that can be used to create reports in BI.

• HANA can be used as a data source for BI reports, allowing for real-time reporting and analysis.

• ERP data can also be used to create BI reports, providing insights into business operations and performance.

• BW is a data warehousing solution that can be used to store and manage data for BI reporting.

• All three data sources can be integrated with...read more

Report customisation can be done by using tools like Crystal Reports or SSRS to modify the layout and data displayed.

• Identify the report to be customised

• Determine the changes to be made

• Use a report customisation tool like Crystal Reports or SSRS

• Modify the layout and data displayed

• Test the customised report to ensure accuracy

Report managing under CMC involves creating, scheduling, and distributing reports.

• Create reports using CMC's report creation tools

• Schedule reports to run at specific times or intervals

• Distribute reports to specific users or groups

• Monitor report usage and performance

• Customize report templates and layouts

• Examples: Sales reports, financial reports, inventory reports

BI reports have filters at both report level and query level.

• Report level filters allow users to filter data within the report itself.

• Query level filters are applied to the underlying data source before the report is generated.

• Common filters include date filters, dimension filters, and measure filters.

• Report level filters can be applied to specific visualizations or the entire report.

• Query level filters can be used to ...read more

There are multiple ways to resolve loops during universe building.

• One way is to use aggregate awareness to avoid loops.

• Another way is to use aliases to create a self-join.

• A third way is to use contexts to define the scope of the query.

• It is also important to ensure that the join paths are correct and optimized.

• Testing and debugging can help identify and resolve any remaining loops.

Yes, I am satisfied with my current salary.

• I am content with my current salary as it meets my financial needs

• I feel valued for my work and contributions at my current salary level

• I have compared my salary with industry standards and feel it is fair

The speed of the person sitting under the train is zero.

• The person sitting under the train is stationary.

• The speed of the train does not affect the speed of the person.

• The person's speed is relative to the ground, not the train.

Water does not fall from a filled glass because of surface tension and gravity.

• Surface tension of water creates a force that holds it together and prevents it from overflowing.

• Gravity pulls the water downwards, keeping it inside the glass.

• The shape of the glass also plays a role in containing the water.

• If the glass is filled beyond its capacity, the surface tension may break and water will overflow.