Blackstone Center of Excellence Senior Analyst Interview Questions and Answers

Accounts payable is the amount of money a company owes to its suppliers or vendors for goods or services purchased on credit.

• Accounts payable is a liability on the balance sheet

• It represents the amount of money owed by a company to its suppliers or vendors

• It is typically recorded when goods or services are received but payment has not yet been made

• Accounts payable is an important part of a company's working capital man

Yes, I have experience working in the invoice process.

• I have experience handling invoices, processing payments, and resolving discrepancies.

• I am familiar with using accounting software to track and manage invoices.

• I have worked closely with vendors and internal teams to ensure timely and accurate invoicing.

• I have experience in reconciling invoices and resolving any billing issues.

nodup vs nodupkey: nodup removes duplicates based on all variables, nodupkey removes duplicates based on key variables. if vs where: if is used for conditional processing, where is used for subsetting data.

• nodup removes duplicates based on all variables, while nodupkey removes duplicates based on key variables

• if is used for conditional processing within a data step or procedure, while where is used for subsetting data ...read more

if is used for conditional statements, where is used for filtering data in SQL queries.

• if is used in programming languages for conditional statements, where is used in SQL queries for filtering data

• if can be used to execute a block of code based on a condition, where is used to filter rows based on a condition in SQL

• if can be used in various programming languages like Java, Python, etc., where is specific to SQL querie

Types of joins in SQL include inner join, left join, right join, and full outer join.

• Inner join: returns rows when there is at least one match in both tables

• Left join: returns all rows from the left table and the matched rows from the right table

• Right join: returns all rows from the right table and the matched rows from the left table

• Full outer join: returns rows when there is a match in one of the tables

SQL Server Always On is a high availability and disaster recovery solution that provides redundancy and failover capabilities.

• SQL Server Always On is a feature in SQL Server that provides high availability and disaster recovery solutions.

• It allows for automatic failover between multiple replicas to ensure minimal downtime.

• There are two types of Always On configurations: Always On Failover Cluster Instances (FCI) and Al...read more

Setting up failover clustering involves several steps to ensure high availability and reliability of systems.

• Install the Failover Clustering feature on all servers that will participate in the cluster.

• Configure shared storage for the cluster, such as a SAN or NAS.

• Create a cluster by running the Failover Cluster Manager and following the wizard to add servers to the cluster.

• Configure cluster networks and assign IP addre...read more