Accenture SQL Interview Questions and Answers

Q1. What is difference between Historical Metrics and real time metrics?
Ans. 
Historical metrics are data collected over a period of time, while real-time metrics are collected and displayed instantly.
• Historical metrics are used for trend analysis and long-term planning.

• Real-time metrics are used for immediate monitoring and decision-making.

• Examples: Historical metrics could include monthly sales data, while real-time metrics could include website traffic in the last hour.
Answered by AI
Add your answer
Q2. Limitation ofAWS service
Ans. 
One limitation of AWS services is the potential for unexpected costs due to usage-based pricing.
• Usage-based pricing can lead to higher costs than anticipated if resources are not properly managed

• It can be challenging to accurately predict costs, especially for dynamic workloads

• Lack of visibility into usage patterns can result in cost overruns

• Some services may have complex pricing structures that are difficult to unders
Answered by AI
Add your answer
Q3. Projectexperience
Add your answer

Q1. Project experience
Add your answer

Q1. Why you are leaving current job?
Add your answer

Q1. What are this aws
Ans. 
AWS (Amazon Web Services) is a cloud computing platform that offers a wide range of services for businesses and individuals.
• Provides services such as computing power, storage, databases, machine learning, and more

• Allows users to scale resources up or down based on demand

• Offers a pay-as-you-go pricing model

• Popular services include EC2 (Elastic Compute Cloud), S3 (Simple Storage Service), and RDS (Relational Database Ser
Answered by AI
View 1 more answer
Q2. What are the cloud providers
Ans. 
Cloud providers are companies that offer cloud computing services, allowing users to access and store data and applications on remote servers.
• Amazon Web Services (AWS)

• Microsoft Azure

• Google Cloud Platform

• IBM Cloud

• Oracle Cloud
Answered by AI
View 1 more answer

What are the tools on devops

Q1. Who was first used on aws
Ans. 
The first service used on AWS was Amazon Elastic Compute Cloud (EC2).
• Amazon EC2 was launched in 2006 as one of the first services offered by AWS.

• It allows users to rent virtual servers on which to run their own applications.

• EC2 provides scalable computing capacity in the cloud.

• Many other AWS services, such as S3 and RDS, rely on EC2 instances for their functionality.
Answered by AI
View 1 more answer
Q2. Netflix company
Add your answer

Q1. What are the cloud computing models
Ans. 
Cloud computing models include SaaS, PaaS, and IaaS.
• Software as a Service (SaaS) - applications hosted on cloud and accessed via web browser (e.g. Gmail)

• Platform as a Service (PaaS) - platform and tools provided to develop, test, and deploy applications (e.g. AWS Elastic Beanstalk)

• Infrastructure as a Service (IaaS) - virtualized computing resources like servers, storage, and networking (e.g. AWS EC2)
Answered by AI
View 1 more answer

Q1. What is vpc and scerious
Ans. 
VPC stands for Virtual Private Cloud, a virtual network dedicated to an AWS account. SCERIOUS is not a recognized term in AWS.
• VPC is used to create isolated virtual networks within AWS

• It allows users to define their own IP address range, subnets, and route tables

• VPC provides control over network traffic, security, and connectivity options
Answered by AI
View 1 more answer
Q2. S3 name unique or nonuniqe
Ans. 
S3 bucket names are globally unique.
• S3 bucket names must be unique across all AWS accounts.

• Bucket names can contain lowercase letters, numbers, and hyphens.

• Bucket names cannot contain underscores, uppercase letters, or periods.

• Example of a valid bucket name: my-bucket-123

• Example of an invalid bucket name: My_Bucket
Answered by AI
Add your answer
Q3. Different between bound and unbound
Ans. 
Bound refers to a variable that is assigned to a specific value, while unbound refers to a variable that has not yet been assigned a value.
• Bound variables have a specific value assigned to them, while unbound variables do not.

• Bound variables are used in programming to store and manipulate data, while unbound variables are used to represent unknown values.

• Examples of bound variables include constants and variables that ...read more
Answered by AI
Add your answer
Q4. What are usecase of slave and master
Ans. 
Slaves and masters are used in distributed systems for load balancing and fault tolerance.
• In a distributed system, the master node controls and coordinates the work of the slave nodes.

• Slaves perform tasks assigned by the master and report back their results.

• Masters can be used for load balancing, where they distribute tasks evenly among slaves.

• Masters can also be used for fault tolerance, where they can detect when a s...read more
Answered by AI
Add your answer
Q5. About container which tools using container in aws devops
Add your answer
Q6. Explain Aws and brefi
Ans. 
AWS is a cloud computing platform that provides a wide range of services for building and deploying applications.
• AWS offers services such as compute, storage, databases, and more

• It allows users to easily scale their applications and pay only for what they use

• Brefi is a serverless PHP runtime for AWS Lambda
Answered by AI
Add your answer

They gave some user story according to our coding skills.

Q1. Core python concepts basic and advance both.
Add your answer
Q2. Questiins regarding AWS skills like IAM Role, S3, EC2, Redshift, Lambda, Kinesis, SES, SNS, SQS, CloudWatch, Glu.
Add your answer

Q1. Duscussion for the salary package.
Add your answer

Q1. I mentioned java and python in my skills so 80% questions were from java only
Add your answer
Q2. And then few were from python and oops concepts
Add your answer

Q1. Where do you see yourself in 5 years?
Add your answer
Q2. Why should we hire you?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer
Q4. Tell me about yourself.
Add your answer