[Ended] Round 9 | Technical Document Scavenger Hunt
  

Sangfor Jojo Lv5Posted 2024-Nov-05 09:29


Dear members,
We are excited to announce the launch of our Technical Document Scavenger Hunt! This activity aims to encourage all users to dive deeper into our newly published technical document in the Knowledge Base, enhancing your understanding and engagement with the material.

By participating, you\'ll not only sharpen your skills but also have the chance to collaborate and share insights with fellow users.
Happy hunting, and may the best reader win!

We have interviewed some participants for their thoughts on this event. Let\\\'s see what they were saying about the Technical Document Scavenger Hunt.

1. Activity Rules                                                                                                                     

1)  All community users are invited to participate in the scavenger hunt.
2)  There will be a total of 6 questions related to the three documents.
3)  Participants must submit their answers under this post by Nov. 11.
4)  Winners will be announced next Tuesday on the community platform.


2. Activity Duration                                                                                                               

Nov. 5 - Nov. 11

3. How to Participate                                                                                                                                                                                                                
1) Browse the Questions:
We have provided a list of questions based on the content of the document. Your goal is to find the
answers within the text.

2) Read the Documents:
Start by simply reading the catalog. Taking your second reading thoroughly with the given questions
which will make you read more efficiently.

3) Use the Search Function:
Most digital documents have a search feature. Use keywords from the questions to quickly locate
relevant sections.

4) Submit Your Answers:
Once you have your answers, post them in the designated thread by the deadline.

5) Collaborate:
Feel free to discuss your findings in the forum and win 100 coins. Sharing thoughts and interpretations can lead to a deeper understanding and may help others in their search.



4.  Rewards                                                                                                                             

1) Correct Answers: 100 coins for each correct answer.

2) All Correct: An additional 100 coins for those who answer all questions correctly.


5. Scavenger Hunt Questions                                                                                             

Read these documents on the left side and answer the questions below.

Sangfor Database Management Platform Operation GuideQ1: What is the impact of on-premises cloud with DMP in VPC network type
and DMP in MCS?
Q2: We must confirm with the customer in advance about the plan to
the change password for database user root. (True or False)
Sangfor DMP_Migrate SQL Server Database to SQL Server Always On DatabaseQ3: What are the two types of migration methods mentioned for transferring a SQL Server database to an Always On database?
Q4: During the migration process, what action must be taken to ensure minimal downtime?
VDI Upgrade PathQ5: How to upgrade the early version 5.1_EN to 5.4.5_EN?
Q6: Which versions can the 5.5.0_EN and 5.4.5_EN versions both directly be upgraded to?



6. How to Reply This Post                                                                                                   

Try to make it simple! Do not repeat the questions again when typing your answers.

--------------------------------------------------------------------------------------------------------------------------------------


Recommended Reading                                                                                                         
Rotring Lv2Posted 2024-Nov-05 12:46
  
Q1:
1. DMP in VPC Network Type (On-Premises Cloud)
-Isolation and Security
-Performance and Latency
-Management and Customization
-Scalability and Elasticity
-Compliance and Data Sovereignty
2. DMP in MCS (Managed Cloud Service)
-Managed Infrastructure
-Hybrid and Multi-Cloud Integration
-Reduced Latency Challenges
-Elasticity and Resource Scaling
-Compliance Challenges
Q2: True
Q3:
The two primary migration methods for transferring a SQL Server database to an Always On Availability Group are:
1.Full Backup and Restore Method
2.Log Shipping Method
Q4:
1.Use Log Shipping or Transaction Log Backups for Synchronization
2.Perform a Final Transaction Log Backup and Restore
3.Switch Over to the Availability Group
Q5:
1.Review the Release Notes
2.Back Up Current Data
3.Check for Upgrade Path Requirements
4.Prepare the Environment
5.Download the Upgrade Package
6.Install the Upgrade:
7.Verify the Upgrade:
8.Rollback Plan
9.Notify Users (if applicable)
Q6:
Both version 5.5.0_EN and version 5.4.5_EN can typically be directly upgraded to version 5.6.0_EN, assuming 5.6.0_EN is the next major release in the sequence. However, it's always best to consult the official upgrade path documentation, as some versions may have specific requirements or dependencies that could require intermediate upgrades.
Newbie517762 Lv5Posted 2024-Nov-05 12:57
  
Q1:
1.Security & Management
2. Customization and Control
3. Performance
4. Scalability and Flexibility
5. Support and Maintenance

Q2. True.

Q3: Full Backup Method & Incremental Backup Method

Q4: To reduce the service downtime during database migration, It is advised to use
full backup plus incremental database backup and recovery method to migrate
the data in the existing SQL Server database to SQL Server database in DMP.

Q5: The version 5.1_EN cannot be directly upgraded to 5.4.5_EN. You are recommended to upgrade it to version 5.3.3_EN before upgrading.

Q6: From 5.4.0_EN, 5.40SP1_EN, 5.4.0R2_EN, 5.41_EN & 5.4.2_EN.
AR Lv1Posted 2024-Nov-05 18:48
  
Q1. Using a DMP (Device Management Platform) in an on-premises cloud within a VPC (Virtual Private Cloud) network provides greater control over data, better security, and reduced latency, as data and management stay on-site.
In contrast, DMP in MCS (Managed Cloud Service) offers scalability, simplified maintenance, and accessibility but may have higher latency and limited control over data handling due to third-party management.

Q2. True.
Confirming with the customer before changing the database user root password is essential to avoid disruptions and ensure proper coordination.

Q3. The two types of migration methods for transferring a SQL Server database to an Always On database are:

Backup and Restore - Taking a backup of the database and restoring it on the Always On replica.
Join Only - Adding an existing database directly to the Always On availability group without needing a backup, if it already meets configuration requirements.

Q4. To ensure minimal downtime during migration:
Plan carefully and test in staging.
Use automated tools for efficiency.
Sync data in real-time or incrementally.
Schedule cutover during off-peak hours.
Monitor closely and communicate with stakeholders.

Q5:  To upgrade from 5.1_EN to 5.4.5_EN:
Backup data.
Review release notes.
Ensure compatibility.
Schedule downtime.
Install upgrade package.
Test functionalities.
Monitor post-upgrade.

Q6:  Both versions 5.5.0_EN and 5.4.5_EN can typically be directly upgraded to version 5.6.0_EN or the latest stable release that supports direct upgrades from these versions, based on the software's upgrade path provided by the vendor. Always check the official upgrade path documentation to confirm.









pmateus Lv2Posted 2024-Nov-05 18:58
  
Hi,
The link Sangfor Database Management Platform Operation Guide is not working.
Enrico Vanzetto Lv4Posted 2024-Nov-05 22:37
  
Q1eploying an on-premises cloud with a DMP in a VPC offers flexibility, control, and isolation, but requires more management. In contrast, MCS provides simplicity, scalability, and managed support, though it may limit control and come with higher costs.
Q2:True
Q3:full and incremental migration method
Q4:It is advised to use ull backup plus incremental database backup and recovery method to migrate he data in the existing SQL Server database to SQL Server database in DMP, wether Single instance or SQL Server with Always on architecture
Q5:The version 5.1_EN cannot be directly upgraded to 5.4.0R2_EN and 5.4.5_EN. You are ecommended to upgrade it to version 5.3.3_EN before upgrading.
Q6:5.5.0R1_EN , 5.5.6_EN
Noviyanto Lv3Posted 2024-Nov-06 09:44
  
Hi Jojo,
The documents of Q1 and Q2 can not be shown. Can you fix it?
Beru Lv2Posted 2024-Nov-06 12:02
  
Q1: causing database restart and impact availability and stability of the service

Q2 : true

Q3:
1. Backup and Recovery method
2. Detach and Attach method

Q4:
Align with the customer about the cut-off day and time
Send out a notice about the time for service stop
Ensure there is no access to the source database except for migration operation
Perform the last incremental backup and recovery to synchronize the data from source to target database
Disable database user access to prevent application or service access to the source database
Kill existing sessions manually

Q5 : upgrade from 5.1_EN to 5.3.8SP1_EN, and then from 5.3.8SP1_EN to 5.4.5_EN.

Q6 : 5.9.0_EN and 5.9.1_EN

Clarence Roque Lv1Posted 2024-Nov-06 13:18
  
Q1: The impact of DMP in an on-premises cloud with a VPC network includes enhanced data control, privacy, and lower latency but requires more infrastructure management, while DMP in Managed Cloud Services (MCS) offers easier scalability, reduced maintenance, and cost-effectiveness, though with potentially less control over physical data location and slightly higher latency.
Q2: True.
Q3: Full and Incremental migration method.
Q4: , It is advised to use full backup plus incremental database backup and recovery method to migrate the data in the existing SQL Server database to SQL Server database in DMP.
Q5: The version 5.1_EN cannot be directly upgraded to 5.4.0R2_EN and 5.4.5_EN. You are recommended to upgrade it to version 5.3.3_EN before upgrading.
Q6: 5.5.0_EN can be upgraded to 5.5.0R1_EN, 5.5.6_EN, 5.9.0_EN, 5.9.1_EN and 5.4.5_EN can be upgraded to 5.5.0_EN, 5.50R1_EN, 5.5.6_EN.
ilham Lv1Posted 2024-Nov-06 15:37
  
Q1: -
Q2: True
Q3: full & incremental methods
Q4: it is advised to use full backup plus incremental database backup and
    recovery method to migrate the data in the existing SQL Server database
    to SQL Server database in DMP               
Q5: recommended to upgrade it to version 5.3.3_EN before upgrading
Q6: 5.5.0R1_EN & 5.5.6_EN