Design a windows 10/8.1 tablet application that also runs offline

I want to design a business application for a windows tablet. The app's database should be in sync with a cloud server.[Azure/AWS]. But the app should run perfectly without internet connection. The data should get synced to server when connection in on. And the sync should be two way also.

Till now I have come across this solution Using Offline Data With Azure Mobile Services

But I want to know

• How much data can I save in my sqlitelocalstore. Is this same as much as sqlite supports.? [to be precise can I use this to store 5GB data locally for a LOB app].
• Is there a way to sync few columns of a table to server?
• Can I support few Database transactions in my client code?

Is there any better way to solve the above problem.