What will a cardiologist look for?

I'm going to see a cardiologist and I was wondering what they will look for. can they see if there's pinholes in my heart? can they see if I have heart failure? thank you.